Check if existing document name without saving

(0) Share

Report

Posted on by Misa

246

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.

Categories:

Connecting to Data

All responses (2)

Answers (0)

Misa 246 on at

Like (0)

Report

Re: Check if existing document name without saving

@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?
GarethPrisk 2,826 on at

Like (0)

Report
Re: Check if existing document name without saving

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.