Hi,
I have the excel data where i'm importing excel to dataverse by using power automate cloud flow.
I have the state column where it is lookup column and i would like to map the excel state value to lookup column in dataverse state column. How to do that dynamically?
Thanks.
To update a value in a Dataverse lookup column you need to specify the entity (tablename) for the column and the GUID for the row in the other table. Here's an article that explains: How to update Dataverse lookup column with Power Automate (tomriha.com) Since you won't have the GUID you'll need to list the rows in the other table and then filter on the value from the Excel Row. That should give you one record in an array. YOu can then use the ID of that first record and the table name to update the row in your Dataverse table.