Answered

can i automatically overwrite my old file attachment

(0) Share

Report

Posted on by moniing

Hi, I am just new with powerapps and I am trying to create a ticketing application where the users can also attach files.

I am having issue with the attachment because my client want to automatically overwrite the old file with the same file name. but in powerapps whenever i upload a new file with the same filename as the old one, it only retains the old one and not the new one.

Is there a way that I can automatically replace the old file?

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @moniing ,

Could you please share more details about your scenario? Which data source are you using? Is there an Attachments Control within your App?

Best regards,
moniing 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I am using SharePoint as my data source. Yes, there is an Attachment control, and I am using forms as well.
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @moniing ,

With Froms and Attachments control as the scenario, the default behavior is list existing files in the Attachments control, there is no way to automatically delete an individual file using functions. That means, users are only allowed to delete a specific file from in the Attachments Control by manually pressing the Cross buttons.

As an alternative, you can update a collection when select an item from Gallery:

Select(Parent);ClearCollect(colAA,ThisItem.Attachments);EditForm(Form3)

then for the Attachments Control, check file names in OnAddFile property, so the App will notify there is file with same name already and need to delete first.

If(Last(DataCardValue17.Attachments).Name in colAA.DisplayName, Notify("Duplicate file found, please remove the original one first", NotificationType.Warning))

Hope this helps.

Best regards,
moniing 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much for the help!

One last thing, because I have a submit button, is it possible for me to disable the button if i get the warning?
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @moniing ,

You can disable the submit button based on the quantity of files within the Attachments Control:

If(CountRows(Distinct(DataCardValue17.Attachments,Name)) < CountRows(DataCardValue17.Attachments), DisplayMode.Disabled, DisplayMode.Edit)

So, if the number of distinct files is less than the number of all files, the button is disabled.

Best regard,
moniing 8 on at

Like
a
(0)

Report
Copy link

Link copied!

I will try this solution, thank you very much!