Answered

Clearcollect to only return column headers of a SharePoint list

(0) Share

Report

Posted on by Grantx

I am using the following code to retrieve certain columns from my list. If I comment out the 'Clear' function at the bottom, it returns all columns including data.

When I uncomment the 'clear' function, it deletes everything including the column headers. How do I retrieve only column names from my sharepoint list and then populate that collection at runtime?

ClearCollect(
ColTaskUpdates,
ShowColumns(('HelpDesk'),
"Title",
"Description",
"Status",
"Priority",
"AssignedTo",
"Category",
"ResolutionSummary",
"Comments"
)
);

Clear(ColTaskUpdates)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Grantx - you can configure the sample expression below to return the column headers of a SharePoint list:

//Create a collection ClearCollect( myCollection, DropColumns( 'Sample Data', "{Attachments}" ) ); // Get column names Set( myJSON, Distinct( Ungroup( MatchAll( JSON( myCollection, JSONFormat.IgnoreBinaryData ), "([^""]+?)""\s*:" ).SubMatches, "SubMatches" ), Value ) )

I am not clear on your comment re populating the Collection at runtime, because that is the purpose of the ClearCollect function. It will remove the data in the Collection with Clear, and then repopulate the Collection with data using Collect.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
Grantx 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your reply. Unfortunately that doesn't work. That pulls the entire table and all contents same as the ClearCollect command.

Was this reply helpful? Yes No
Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Grantx that's probably because you're not looking at myJSON (which returns a Table of your data source column headers across rows).

You can create a Blank Collection, but not an Empty Collection with e.g.:

Collect( myBlankCollection, Defaults('HelpDesk') );

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No