Answered

Filter list of values output from get files (properties only) to get sharepoint file name

(0) Share

Report

Posted on by NewUser22

After using Get files (properties only) action in SharePoint, i have a output value --> List of items. I have found the link and the name of the file within the output. How can i filter the output to get either the name or the file URL?

Cut out sample of the output

"{Link}": "https://x.sharepoint.com/sites/TestPortal/xx",
"{Name}": "Test1",
"{FilenameWithExtension}": "Test1.xlsx",
"{FullPath}": "Shared Documents/Test1.xlsx",
"{IsCheckedOut}": false,
"{VersionNumber}": "2.0"

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

PURNA429 195 on at

Like (1)

Report

Hi @NewUser22 ,
You can achieve this using "Select" action. The output of select operation need to be extracted using apply to each. In your case , you have only one output value from Get File Properties, you can set variables directly inside for each like below.

Got the output like below :

If I answered your question, please mark this question as answered and if you liked my response, please give a thumbs up .
Thanks
Purna
Blog

Was this reply helpful? Yes No
NewUser22 69 on at

Like (0)

Report

Thanks for the prompt response. For the select action, I only see value --> list of items.
But i don't see Name and Link to item option for me to click. Any idea why?

Was this reply helpful? Yes No
PURNA429 195 on at

Like (0)

Report

Hi @NewUser22 ,

Can you share a screenshot of your flow.?

Thanks
Purna

Was this reply helpful? Yes No
NewUser22 69 on at

Like (0)

Report

Was this reply helpful? Yes No
PURNA429 195 on at

Like (0)

Report

Hi @NewUser22 ,

From your screenshot, you are using "Get Files Property" action instead "Get Files(properties only)" action (which mentioned in your actual question).

If I answered your question, please mark this question as answered and if you liked my response, please give a thumbs up

Thanks
Purna

Was this reply helpful? Yes No
NewUser22 69 on at

Like (0)

Report

Hi @PURNA429 ,

I am using Get Files(properties only) action, i just renamed it. Thanks!

Was this reply helpful? Yes No
Verified answer

NewUser22 69 on at

Like (0)

Report

Hi folks, managed to find out the right way and resolved the issue.
Refer to this:
https://powerusers.microsoft.com/t5/Building-Flows/Referencing-Get-Items-results-in-Apply-to-each/td-p/302466

Was this reply helpful? Yes No