Unanswered

Will Flow Fail if File Name Changes?

(0) Share

Report

Posted on by Ncf5031

Hi all,

I have built a flow using the SharePoint connector 'Get File Content Using Path'. It goes to six locations and pulls the file content (which are .html files) for the specified files. The roadblock I am running into is, if our operations change, the name of the file could also change. The other challenge is there are other files in the same folder that are also .html files. I know for sure the file will be titled in one of two ways which won't change, but I can't work out how to pick the file I need based off the two name possibilities.

Basically the file names could be either "xxxxx A" and "xxxxx B" (which is currently how the flow is configured and works) OR if our operations change there will only be one file in the folder that I want titled "Operations".

Attached is a picture of the flow for reference.

Categories:

Building flows

All responses (3)

Answers (0)

Sort by

abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ncf5031

What action step are you using here? Can't recognize at all from the screenshot you provided.

Thanks
Ncf5031 4 on at

Like
a
(1)

Report
Copy link

Link copied!

@abm
This is using the 'Get File Content Using Path' step at the beginning. I'm just doing this six times to get the content from each file that I need. Then each of those outputs goes through a compose step, then finally put into an e-mail body.
abm abm 33,004 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ncf5031

Try to use Get Files Properties action step and use the filter query as below

substringof('Portal',FileLeafRef)

This will return all the files in that directory which contains Portal

If you want to get particular one file, then use the below query

FileLeafRef eq 'File1.docx'

More than file files then

FileLeafRef eq 'File1.docx' or FileLeafRef eq 'File2.docx'