As topic, is there a way to show all column name from a sharepoint list? maybe a function that can generate a collection that contain all column name from a SP list?
I have made a custom solution
I'd recommend using Power Automate to get the column names. I got the idea how to solve using @3tsolutions 's post here: https://powerusers.microsoft.com/t5/Building-Power-Apps/How-get-columns-name-from-sharepoint-list/m-...
Here's the gist:
1. Get Items from your list (Top Count = 1).
2. Create CSV table (Columns = Automatic).
3. Create Variable that is a string of the headers.
4. Create an Array variable from the string of headers:
When run will give you this output that contains all the column titles. You can copy from the output and paste into your formula (clean the list as needed)
Paste into PowerApps with column names cleaned as required (I had to remove a few that were causing errors and some others I didn't want):
Takes a few minutes to set up but is worth it to get the column names especially if you need to write out (for e.g.) 50 columns.
Cheers,
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
192 | |
67 | |
46 | |
41 | |
22 |
User | Count |
---|---|
251 | |
122 | |
83 | |
80 | |
68 |