web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : Qg5YU2m5XUm55r1SkbdCVI
Power Apps - Microsoft Dataverse
Unanswered

Power Automate Dataverse List rows action with fetchxml - Column display name

Like (0) ShareShare
ReportReport
Posted on 28 Mar 2024 10:42:30 by 34

Hello,

 

I am using Power Automate to extract data from Dataverse table. I am using "List Rows" action with Fetch XML Query option to get defined set of columns. I am storing this data in an array and using "Create CSV Table" action to generate CSV file. How can I show column display names instead of internal names in the generated CSV file. Below is the screenshot of the action:

aaaaaaaDDD_0-1711622262811.png

 

I tried below code in "Fetch XML Query" to show column display name but that did not work.

 

<entity name='cr6a6_xx'>Column Name</attribute>

 

 

I also tried "Select" action to map the column names with the columns from the array however I am not able to provide correct expression.

Can I use "Custom" columns option to show display name? what expression to use in "Value" field?

 

aaaaaaaDDD_1-1711622486937.png

 

Regards,

-N

 

Categories:
I have the same question (0)
  • aaaaaaaDDD Profile Picture
    34 on 28 Mar 2024 at 10:52:04
    Re: Power Automate Dataverse List rows action with fetchxml - Column display name

    I fixed it with this 🙂

     

    item()?['cr6a6_useremail']

     

    aaaaaaaDDD_0-1711623083741.png

     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 629 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 397 Super User 2025 Season 2

#3
wolenberg_ Profile Picture

wolenberg_ 232 Moderator

Last 30 days Overall leaderboard

Featured topics

Loading complete