Unanswered

How to remove upload file after file not csv

(0) Share

Report

Posted on by JACK_LAI_1117

267

I use "form" to upload file to my sharepoint list , and I want to limit "only csv file can upload " if user still upload some files not csv then system will show notify message and "delete the file auto"

In "Onaddfile" I use this formula ....so it can show notify message , but after one hour later I still can not find any method to remove the file "auto" ........so how should I use formula in "onaddfile" function ???

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

WarrenBelz 153,042 Most Valuable Professional on at

Like (1)

Report
Hi @JACK_LAI_1117 ,

Put this on the OnAddFile

If( Right( Last(Self.Attachments).Name, 3 ) <> "csv", Notify( "Only CSV Files Allowed", Error ); Reset(Self) )

The file will be deleted immediately and the user will get the message.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
JACK_LAI_1117 267 on at

Like (0)

Report

@WarrenBelz
Thank you for your replay .
But if user upload first file is csv but second file is docx , then will clear all uploaded files , so user need to re-upload files .
So , could I only remove the file that not csv format !!!

Was this reply helpful? Yes No
JACK_LAI_1117 267 on at

Like (0)

Report

HI ALL,
I found other method to do it !!!
in "onaddfile" formula is
If(
Last(
Split(
Last(
Self.Attachments).Name,
".")
)
.Result <> "csv",
Notify(
"File must be csv format !!!!"
);
)

And in the submit button , the formula like this .....so even user upload wrong format file ,they still not upload file to my sharepoint list , and they need manual remove the wrong format file .

ForAll(
DataCardValue2.Attachments,
If(
Last(
Split(
Name,
"."
)
).Result <> "csv",
Notify("Some files are not csv format , please check it ",NotificationType.Error),
Notify("BBB")
)
)

the result page like this

Was this reply helpful? Yes No
WarrenBelz 153,042 Most Valuable Professional on at

Like (1)

Report

@JACK_LAI_1117 ,

Surely a user would only do that once before learning that the file has to be CSV. My users certainly would learn very quickly (hence the solution I provided)

Was this reply helpful? Yes No
JACK_LAI_1117 267 on at

Like (0)

Report

@WarrenBelz

Got it , I will "training " our user to know it.

Was this reply helpful? Yes No