Unanswered

How to update list of records in dataverse using power automate

(0) Share

Report

Posted on by Dronzer10

Hello,

I am try to update a field in a Dataverse table based on condition. I am using power automate for this . But I am getting error when I am trying to update the list of records when i am trying to update using power automate. Please help .

Many Thanks,

Nilanjan

Categories:

Microsoft Dataverse with Power Apps

Sc1.JPG

sc2.JPG

sc3.JPG

I have the same question (0)

All responses (6)

Answers (0)

v-xiaochen-msft on at

Like (0)

Report

Hi @Dronzer10 ,

Why did you use the 'question id' value in the row id column?

The row id column 's value is a guid value. It's unique.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Dronzer10 51 on at

Like (0)

Report

Hello,

Question id is "items('Apply_to_each')['Question ID'])". This is also I am using in Filter array. I am also not sure what to put in this area, frankly speaking. As I am passing an array of items and this update should run for all of these items. I am attaching the screenshot of error .

sc4.JPG

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @Dronzer10 ,

As I said before, flow needs to know which record you want to update.

Every record in dataverse has a guid value. When the recored is created, the guid value is automatically generated.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Dronzer10 51 on at

Like (0)

Report

Correct, See I am attaching a screenshot which I have used in other flow. Here I am extracting the 1st record. The outputs from Compose i am using for Update the record.
But here I am trying to get the array of records so I am facing the challenge. How I will get the row id in the present case.
Please advise.

sc5.JPG

sc6.JPG

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @Dronzer10 ,

In your case, you are getting the value of the 'qustionid' column for your firsr item in the 'compose' action.

If you want to get the id of this item , I did a sample for you.

first(outputs('List_rows')?['body/value'])?['crba2_testl16id']

// The column name you could find in the dataverse table . In my sample , its name is crba2_testl16id.

In addition, if you want to get records' ids (array), you could use select action.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Dronzer10 51 on at

Like (0)

Report

Correct for the array of items, I am using select and the compose. But I am not getting what to use in row id at Update a row operation. If I am using the Outputs of the compose its still give me error. I am attching the screen shot of this error.

sc8.JPG

sc7.JPG

Was this reply helpful? Yes No