cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kudo Commander
Kudo Commander

Check if existing document name without saving

Hello.

 

I am using a custom Sharepoint form where the user will be uploading documents using the Attachment datacard.  What i would like to happen is that when the user attaches the document, Powerapps would check to see if the attachment name already exists in another library.  If the name already exists, the user would be given a warning.

 

I tried using variations of the following formula without success.  

 

If(First(DataCardValue34.Attachments).Name in IC.Name, Notify("Name already exists in our database. Please choose a unique name for your IC document.", Error),Set(IsAttached, true))

 

I also tried creating a label and having the label equal the name of the document being attached.  Taking that and comparing against the Name column in the IC library.  Here is an example of one of the formulas that i used.

 

If(!IsBlank(LookUp(IC, Name = Label5.Text)), Notify("Name already exists in our database. Please choose a unique name for your IC document.", Error),Set(IsAttached, true))
 

I am at a loss and not sure where to go from here.  Thank you for your help in advance.

2 REPLIES 2
Super User II
Super User II

Can you confirm that you're getting the attachment name in your formula?

First(DataCardValue34.Attachments).Name

 

There's nothing syntactically incorrect in your formulas and the approaches should be valid. My guess is that it's not actually producing a value to LookUp/check - so I would confirm that first. If necessary, you can capture it in a local variable at run-time, to make sure.

UpdateContext({locFileName: First(DataCardValue34.Attachments).Name});
If(locFileName in IC.Name, Notify("Name already exists in our database. Please choose a unique name for your IC document.", Error),Set(IsAttached, true))

Then you can review the context variable to ensure it was populated before doing the check/lookup.

 @GarethPrisk 

 

Hi.

Yes.  When i pull First(DataCardValue34.Attachments).Name into a label, the name of the attachment comes through.

 

One question, would the above formula matter is i am using it in the OnAddFile instead of a button?  

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (53,039)