Due to large SharePoint library delegation issues, I had to create a Power Automate flow to return a list of files and properties. The data comes back like this:
I want to populate a gallery in Power Apps with the file names only, and then use the file name the user selects to populate a form with the rest of the file’s details. I’m using the following Split function OnSelect to separate the fields, but it’s not giving me the list I want:
Set(isGettingDocs, true);
Set(
FileNames,
GetDocuments.Run(varFolderPathCurrent)
);
Set(isGettingDocs, false);
ClearCollect(colDocuments,With({items:Split(FileNames.filenames,",")},ForAll(Sequence(CountRows(items),1,1),{ID:Index(items,Value).Value,FN:Index(items,Value +1)}))
)
How do I use Split to get at the column of file names only for my gallery? Thanks in advance for the help.

Report
All responses (
Answers (