Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

How to Map lookup column

(0) ShareShare
ReportReport
Posted on by

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.

  • Pstork1 Profile Picture
    Pstork1 64,942 on at
    Re: How to Map lookup column

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard