Answered

Add or Update Dataverse Row

(0) Share

Report

Posted on by 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.

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (1)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
amg92 21 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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,

Was this reply helpful? Yes No
amg92 21 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @amg92 ,

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

Best regards,

Was this reply helpful? Yes No
amg92 21 on at

Like (0)

Report
Copy link

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

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
amg92 21 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @amg92 ,

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

Best regards,

Was this reply helpful? Yes No
amg92 21 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No