Look Up if document name appears in Sharepoint Document Library before Upload

(0) Share

Report

Posted on by EddWr1

Hi,

I am creating a Power App where users can upload documents to a Sharepoint Document Library. This works fine, however, should the document they are trying to upload already exist (e.g. the filename is exactly the same as a document already in the Doc Library on SP), the Upload goes ahead but does not trigger the Power Automate flow I have which triggers when a new document is uploaded (as the file name already exists in the Doc Library).

What I want to do is, before Upload is clicked, the Sharepoint Doc Library is "searched" to see if the item being uploaded's file name already exists - if YES, append some characters to the beginning of the filename, if NO, allow the Upload to the SP doc library to go ahead.

All advice welcome,

Thanks

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @EddWr1 ,

I assume There is a text input control(TextInput1) to set the file name in the canvas app. You could use this code to upload the file:

If( IsBlank(LookUp(YourSPLibrary,'File name with extension'=TextInput1.Text)), Notify("The file already exists"), FlowName.Run() )

Best Regards,

Bof