I really need some help with a board mutation (create item) that I am trying to achieve using Monday and Data Integromat.
We check One drive for a new file or changes to the file > We create a csv file with the values > We break down the CSV file > We aggregate those items into an array and passed to Monday > We pass the arrays to Monday to create items for an existing board.
I have been able to get the integration to work, but only under two conditions:
- Remove the TAG from the integration, where a dynamic variable is passed to the Monday board- to create a new tag.In
- Dont map the tag to a dynamic variable, but rather assign the column name to the TAG value. Using that approach the integration works and the tag is created BUT the tag name is the column name, i.e. #AccountManager when what I want is the value of the variable for that record to be created
Here is the diagrammatic view of the Integromat integration: We check One drive for a new file or changes to the file > we create a csv file with the values > the collection are broken down into into items > those items are then aggregated into an array and passed to Monday.
Below is the output from the Iterator step
The step below is the last hop, i.e. the Aggregator, before the Monday board- one bundle is output into a single array, with 8 columns.
If I remove the last column, number 8, which is for a tag that I am wanting to create (that does not exist) the Monday board is updated and all the items are created without issue.
If I don’t map the last column to a variable, but ather assign it the value of account manager, then the tag is created, but it is created in the format #AccountManager. I want the tag value to be dynamically assigned based on the value assigned to the variable, i.e. whatever is in column 8.
Below is the definition in the Monday step, in Intrgromat. Dynamic variables have been assigned to each column in the board.
The problem column is the tags
Below is the feedback from running the integration- I can see the value assigned to the variable, for which I want the tag to be automatically created. The column name is Account Manager, and the value for the line item in question is: Aaron Smallcombe
Here is the error that is generated- I think the error is related to the format of the input for the tag column, and I think I need to provide the JSON format for the variable…but all of the other text columns are converted perfectly, if I remove the tag column from the integration.
Not sure what I am doing wrong?