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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Need help with complex...
Power Apps
Answered

Need help with complex Split function

(0) ShareShare
ReportReport
Posted on by

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:

djr0gers2020_0-1690729448726.jpeg

 

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.

Categories:
I have the same question (0)
  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @djr0gers2020 ,

     

    There is no need to use the split , you could try one of these ways to get a table:

    Solution1: Using the response action to make the flow return a table directly.

    https://www.youtube.com/watch?v=hcMruU_ME_c

    Solution2:Using the parsejson action to parse the json string.

    https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-parsejson

     

    Best Regards,

    Bof

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 493 Most Valuable Professional

#2
11manish Profile Picture

11manish 479

#3
Haque Profile Picture

Haque 328

Last 30 days Overall leaderboard