Add or Update Dataverse Row

[amg92]

Hello. I am trying to update a dataverse row with a condition stating that two specific values match. If there is a match, update the row. If they don't, add a new row. When I run this workflow, it updates every row to the same item.

 

[v-jefferni]

Hi @amg92 ,

The logic of your flow is incorrect. It compares all rows of Dataverse table with each item in the array output from Parse JSON. What you need instead is a Filter array, for each array from Parse JSON, Filter the Dataverse table, in the Condtion control if one item matches the output (length('Filter_array') = 1), update current row (Apply_to_each will come up automatically), otherwise add a new row.

Best regards,

[amg92]

What does the Filter array and filtering the dataverse table look like?

[v-jefferni · Accepted solution]

Hi @amg92 ,

This is the basic steps in your flow. I don't have a table and JSON array as yours to test with, so, it's just a demonstration:

In Apply to each, its input is body('Parse_JSON'), and in filter array, you need to write expression to set the two

conditions:

@and(equals(item()['Column1'], items('Apply_to_each')['Column1']),equals(item()['Column2'], items('Apply_to_each')['Column2']))

In Condition, the expression is:

length(body('Filter_array'))   is equal to  1

In Apply to each to, the array it's from is body('Filter_array')

Best regards,

[amg92]

I've updated my workflow to match what you have above and I am still getting the same result. The workflow continues to add additional rows instead of updating a row in a Dataverse table. For example: row "1212" in the dataverse table states the item is "rejected." If this status changes to "approved," I want to update row "1212" in the dataverse instead of adding an additional row.

 

[v-jefferni]

Hi @amg92 ,

Please share a screenshot about your current Filter array and the Condition control.

Best regards,

[amg92]

Filter array: @And(equals(item()?['blank_sownumber'], items('Apply_to_each')?['sow-number']),equals(item()?['blank_approvalstep'], items('Apply_to_each')?['approval-step']))

• 
• Condition
  • 

[v-jefferni]

Hi @amg92 ,

How many items are there in Filter array result? It may be more than 1 so please try and change the condition to larger than 0.

Best regards,

[amg92]

Within the apply to each loop there are lots of results. Below is a screenshot.

I tried changing the condition to greater than 0 and it has been running for 5 hours now. It did update the rows properly and it appears to not be duplicating rows anymore, but seems to be stuck in a loop.

[v-jefferni]

Hi @amg92 ,

You have 2268 rows in the ParseJSON outcome. Is it correct?

Best regards,

[amg92]

Yes, that is correct. Which can be filtered to rows where column X has a date within the last 24 hours or 48 hours to reduce the length of time. I have not found a good way to filter a dynamic date

[v-jefferni]

Hi @amg92 ,

I cannot understand the dynamic condition, why it's 24 or 48 hours? Anything within 24 hours will also be within 48 hours.

Best regards,

[amg92]

Sorry, I was stating 24 or 48 hours as examples. I was seeing if there is a way to pull only responses that have an approval date within the last 48 hours. I have seen filtering completed by a set date in time such as pulling all data since 1/1/2024. But I have not seen an example of pulling the last 48 hours.

[v-jefferni]

Hi @amg92 ,

So, after Parse JSON action you can have a Filter array to filter on the date column, filter criteria would be:

@greater(item()['Step Completed'], addHours(utcNow(),-48))

Best regards,