Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Retrieve File from Sharepoint Library

(0) ShareShare
ReportReport
Posted on by

I am hoping I can get some assistance with automating our printing process. 

 

I have my flow set up to link Forms to Sharepoint lists to collect responses to a Form for data on requests for printed documents. The first three questions on the Forms are related to document title, language and print size. The first five characters of the first question and the first two characters in the second and third question correlate with the actual file in the Sharepoint library.  I tried to use the following expressions to get it to automatically search and retrieve the files using those criteria. 

 

concat(substring(body('Create_item')['Title'],0,5),substring(body('Get_response_details')?['r97036346afd04962af0370d3e8f8b092'],0,2),substring(body('Create_item')?['lu2r'],0,2)

 

However, when I try to hit ok on my text editor it is telling me it is not a valid expression. Is there something wrong with the expression that I am not seeing or is there a simpler way to do this? Pictures of the Flow, Form Data and final file name are included. 

image.pngimage.pngimage.pngimage.pngimage.png

  • v-bacao-msft Profile Picture
    on at
    Re: Retrieve File from Sharepoint Library

    Hi @Anonymous,

     

    Do you mean that the value of the formula output you configured is the corresponding File Identifier?

    I feel that this formula outputs only the file name that does not contain the extension. It is recommended to use Get file metadata using path/Get file content using path:

    33.PNG

    Add the folder where the file is located in front, and then use the formula to get the file name, but the formula output must be the file name with extension. So it is recommended to add a file type in Forms.

    Note that the formula is generally required to be written in Expression and then populated in the field.

    Please take a try.

     

    Best Regards,

    Barry

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1