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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / getting column names f...
Power Automate
Unanswered

getting column names for an excel file

(0) ShareShare
ReportReport
Posted on by 135
Hello all, I am having a hard time getting the values from a list rows present in a table action. This is what my flow looks like

Here is what the values look like from the list rows present in a table action
[
  {
    "@odata.etag""",
    "ItemInternalId""2f969558-5d85-4604-b879-948f4f069b0a",
    "Heading1""Heading 1",
    "Heading2""Heading 2",
    "Heading3""Heading 3"
  },
  {
    "@odata.etag""",
    "ItemInternalId""c671e1f3-ee92-47a7-98a6-a6f0b5c88ef2",
    "Heading1""This",
    "Heading2""Is",
    "Heading3""A test"
  }
]

This gets the columns and values from each file in a sharepoint folder. Now, I just want a compose that shows me all the column names
because I am going to use the column names in a check to see if something exist. The column names can be different so I can hard code anything
It needs to basically loop through and get the column names from the file. Any ideas? I tried 
join(keys(items('Apply_to_each_2')), ', ') based on research, and then tried it without the join as well and I get the same error
 
Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template function 'keys' is not defined or not valid.'.
 
 
Categories:
I have the same question (0)

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard