
Announcements
I am trying to write a Power Automate flow to allow export of a Dataverse table - however, several of the columns in that table are lookup columns.
Is there a way I can convert the columns to text so they show up in the exported csv? I am a newbie and hoping there's a relatively simple way to do this?
Hi @ccctotheH ,
I usually utilize the approach identified here: https://softchief.com/2021/07/13/get-text-or-name-value-of-lookup-field-in-power-automate-in-power-apps/
Another option (although not as efficient) would be to GetRowById on the referenced table and you could then grab any field you need (including primary name field of course) to export.