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.

I have the same question (0)

All responses (3)

Answers (0)

abm abm 32,600 Most Valuable Professional on at

Like (0)

Report

Re: Will Flow Fail if File Name Changes?

Hi @Ncf5031

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

Thanks

Was this reply helpful? Yes No
Ncf5031 4 on at

Like (1)

Report

Re: Will Flow Fail if File Name Changes?

@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.

Was this reply helpful? Yes No
abm abm 32,600 Most Valuable Professional on at

Like (0)

Report

Re: Will Flow Fail if File Name Changes?

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'

Was this reply helpful? Yes No