Notifications
Announcements
I would like to update the Value against a column in Excel to dataverse.
Excel data
The field in Dataverse is Payment Method as it is a lookup field how do I add it using power automate
**/table(GUID of the payment method value) --- I don't want this as I don't want to specify the GUID.
Hi @snitikal
With Power Automate you won't be able to do that, in the end Power Automate is following the Odata protocol to be able to update the data.
If you want to do it without using power automate, you can do it using data export and import and it will be easier because you do not refer to the GUID; If not, the name of the table, which in the end is the value that is shown to the user
If I have answered your question, please mark your post as Solved. If you like my response, please give it a Thumbs Up. You can accept more than one post as a solution
I am sure there is a way.
How we can otherwise import lookup values to dataverse from Excel. I have around 20 fields like this to be used in my flow.
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 796 Most Valuable Professional
Michael E. Gernaey 327 Super User 2025 Season 2
Power Platform 1919 268
