You’re offline. This is a read only version of the page.
Announcements
254
Is there a way in PowerAutomate that I can get the internal Sharepoint column names from a list and store each of them in it's own variable?
I have a flow which I frequently export and import as new on different lists, the problem is, some people put spaces in their column names, some people don't etc so it's a lot of work manually typing in the column internal names when I'm updating specific column values with JSON in the Item value section of update item. I'd like to store each column name in a variable and reference the column name via the variable in the json e.g.
{
"variable for column name":"column value"
}
Mmmm...
Internal column names are a nightmare are perfectly explained by Tom Riha
What is SharePoint column internal name and where to find it (tomriha.com)
The following post includes the description of two common methods to figure out what the internal column name is... but I am afraid both of them are manual
Solved: Sort in GET ITEMS by column with space - Power Platform Community (microsoft.com)
The good news are, it seems to be a method to query 'Send HTTP request to Sharepoint' and get back the internal columns name list my means of a GET method
Share
Report
All responses (
Answers (
/_api/web/lists/getByTitle('List Name')/fields
GReat stuff here
SharePoint REST API call with PowerAutomate (ludovicperrichon.com)
Hope this helps
