Unanswered

How to update Dataverse lookup column with Power Automate from CSV file

(2) Share

Report

Posted on by Beelieve

Hi everyone,

I would like to ask on how to update look up field when adding a row from CSV file. I successfully created a flow that create a record from CSV, however I also want to add update lookup field but I'm getting an error.

Csv File Contents

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

sandeepstw 312 Moderator on at

Like (0)

Report

Hi There,

For the lookup column you need to provide JSON -

In the field for your lookup column, you need to provide a JSON object that contains two properties:
Id: the identifier of the item in the referenced list
Value: the text value of the item
The JSON structure should look like this:

{
"Id": [Your Lookup Value Id],
"Value": "[Your Lookup Value Text]"
}

This article will also help you get a clear view -
https://www.youtube.com/watch?v=BrjobdJqvEQ

Please give kudos and mark as solution if it helps.

Thanks,
Sandeep Mishra

Was this reply helpful? Yes No
Linn Zaw Win 2,996 on at

Like (0)

Report

@Beelieve
To set the lookup column, you need to retrieve the GUID of the lookup value first. (E.g. use the List Rows action to retrieve the Account with the Name = Account1). Then, you need to define the logic on how to handle if you identify more than one record or if there is no record.
Once you get a single GUID value (usually the [0] value from the array output of the List Rows action), you can set the lookup value using the «EntitySetName»(«RecordGUID» format. Please refer to my blog post below for more details.
https://linnzawwin.blogspot.com/2019/11/power-automate-how-to-set-lookup-field.html

Was this reply helpful? Yes No
Ma03 9 on at

Like (1)

Report

Hello,

I was with the same issue, watching videos and trying to figure out how to add a row which is a Lookup from an Excel.
I founded this site: https://angelogulisano.com/dataverse-create-item-with-lookup-field-power-automate/
Basically after you "List Rows" with the schema that should be linked you need to add an expression on the field that you want to be populated with the lookup value with the ROWGUID

here is the expression: first(body('List_rows')?['value'])?['@odata.id']

Good luck!!

Was this reply helpful? Yes No