cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Misa
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
GarethPrisk
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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

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

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (48,007)