Unanswered

How to check if a file exists in a SharePoint library by file name?

(0) Share

Report

Posted on by Community Power Pla...

I am trying to get a true/false response on if a file exists in a SP library given the file Name. The files do not have Titles. Based on my research, I have seen suggestions to use the Get file content using path action. I am able to test that and I do get that to run successfully. However, I don't know where to go from here. I'd like to have a condition after to essentially check if the file was found. What would it be checking on?

Edit: Now thinking Get file content using path is not the best action because the Flow fails on a bad path which I don't want to happen

Categories:

General topics

I have the same question (0)

All responses (14)

Answers (1)

Verified answer

RezaDorrani 12,143 on at

Like (29)

Report

Hi @Anonymous

Use get files properties only
do query on file name and then check the length using expression

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (1)

Report

Hi @Anonymous ,

Have you take a try with @RezaDorrani 's workaround, you could take a try to achieve your needs.

Have your problem be solved? If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best regards,
Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
srose 94 on at

Like (1)

Report

But what do you do once you check the condition? How does that translate back to powerapps to complete the check?

Was this reply helpful? Yes No
BranislavK 6 on at

Like (0)

Report

Hi @RezaDorrani

I have been trying to duplicate the solution you described. I got error:
The expression "FileLeafRef eq INS-TEST----.pdf" is not valid. Creating query failed.
clientRequestId: 35c0a1f9-d680-46e2-bdd2----
serviceRequestId: 35c0a1f9-d680-46e2-bdd2---

Can you please advise what might be the issue?

Thank you in advance.

Was this reply helpful? Yes No
BranislavK 6 on at

Like (1)

Report

Hi @RezaDorrani
I see the issue I had not using single quotes for the file reference, after it was fixed, it has been working well. Sorry for the unnecessary question not noticing the typo issue at first.
Thank you.

Was this reply helpful? Yes No
rgentile 89 on at

Like (0)

Report

Thanks Reza, your solution helped me solve a problem.

Was this reply helpful? Yes No
AndresBMR96 3 on at

Like (0)

Report
This solution is superb! One thing you could do if you want to compare various files rather than just one file change
FileLeafReq eq 'contratc.docx'
to:
FileLeafReq eq '[FILE NAME]'
Where [FILE NAME] is a string variable of the "display name" of the file )which you can get from a "get. attachments" function.

Was this reply helpful? Yes No
rsadhula 4 on at

Like (0)

Report
Hi @RezaDorrani ,
FileLeafReq eq 'contratc.docx'
Above filter doesn't work if we have more than 5000 items in library, Do we have any alternative for this ?

Was this reply helpful? Yes No
ques0buffet 105 on at

Like (0)

Report
I'm using the odata filtering on a library with 20k+ items without issue.

FileLeafRef eq 'filename.pdf'

Note the FileLeafRef name.

Was this reply helpful? Yes No
NPrice99 1,302 on at

Like (1)

Report

Hi @RezaDorrani

I used this one - the file existed but the response from length(body('Get_files_(properties_only)')?['value']) was zero. THis one I think is a better way - How to check if SharePoint item already exists in Power Automate (tomriha.com)

Regards

Nigel

Was this reply helpful? Yes No