You’re offline. This is a read only version of the page.
Announcements
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.
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:
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
Share
Report
All responses (
Answers (
522
