upload dialogue with attachment control

[LisKr]

Hi everyone,

I'm currently building an upload dialogue inside my PowerApp. The goal is, that the user selects a file and uploads it to a SP library (done via a flow) and if the flow is completed, the app should notify the user. I got it to work with the image upload control.

But now I got the instruction, that the users not only need to upload images, but also other file types like pdf, videos etc. So I changed the image upload control to an attachment control like in formulas and swapped the name of the image control to the attachment control in my function. But it now throws an error saying "The column "file.contentBytes" in the data source expects type "blob" but you are providing type "table". I don't really get what type blob is or why it doesn't work with the attachments control, but does with the image control.  Also, I did stick to the video about uploading by Reza Dorrani (https://www.youtube.com/watch?v=QUwzvUXgj58) and even if I delete the function and re-add it exactly like he did, it is still the same.

I'll show you some screenshots:

That's what it is like with the old image control. ⬆️

An here it is using the attachment control. ⬆️

Even if I delete the if statement and the notify function, the error is still the same.

What am I doing wrong here? And what do I do, if I want more than one file to be uploaded? I saw a solution with a ForAll function, but I'm not sure how to connect that with notifying the user.

[LisKr]

What a shame that there's no good build-in feature for waiting for the flow.

The problem with the timer is, that sometimes the flow is completed after a few seconds, but the files are still not showing in the gallery after refreshing. In that case users have to wait another 10 seconds or so until it shows. So I'm not sure what to set the duration of the timer to, so that the users neither complain about long loading times (if I set the timer to 10 seconds) nor the files not showing up directly after uploading and refreshing (if I set it to i.e. 3 seconds)... It seems like every option just isn't very convenient, sadly.

[WarrenBelz]

@LisKr ,

I assume your posted query is now solved ?

[LisKr]

Yeah, I think so. Thanks for your help! I'll mark it as solved.

[WarrenBelz]

@LisKr ,

This is just a thought and I cannot test it, but try

Clear(colAttach);
ForAll(
   DetailsMachineUploadAttach.Attachment As FILE;
   Collect(
      colAttach;
      {
         Loaded:
         'MLIProductionInstructions-Machine:CreateFolder+uploadimage'.Run(
            InputDetailsMachineID.Text;
            {
               contentBytes: FILE.Value;
               name: FILE.Name
            }
         ).status
      }
   )
);;
If(
   CountRows(colAttach) = CountRows(DetailsMachineUploadAttach.Attachments);
   Notify(
      "Upload successful!";
      NotificationType.Success
   )
);;

[LisKr]

It tells me "the function "clear" has invalid arguments." and "invalid name. "colAttach" is not recognized". I never worked with collections before, so I don't know what's the problem.

I also tried ClearCollect() since google said, that's the function for creating a collection, but then it says "invalid number of arguments" and confuses me even more.

[WarrenBelz]

@LisKr ,

Add the first line last (or leave it out entirely to test)

[LisKr]

In both cases it says ForAll has invalid arguments. (Maybe because it doesn't know the collection?)

[WarrenBelz]

@LisKr ,
As I noted, I cannot test it presently so I might leave it there.

[WarrenBelz]

@LisKr ,

Now back to my PC - I was close - this works for me in testing

Clear(colAttach);
ForAll(
   DetailsMachineUploadAttach.Attachments As FILE;
   Collect(
      colAttach;
      Table(
         {
            Loaded:
            'MLIProductionInstructions-Machine:CreateFolder+uploadimage'.Run(
               InputDetailsMachineID.Text;
               {
                  contentBytes: FILE.Value;
                  name: FILE.Name
               }
            ).status
         }
      )
   )
);;
If(
   CountRows(colAttach) = CountRows(DetailsMachineUploadAttach.Attachments);
   Notify(
      "Upload successful!";
      NotificationType.Success
   )
);;

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.

MVP (Business Applications)   Visit my blog Practical Power Apps

[LisKr]

Sadly it still gives me errors. "Function Clear has invalid arguments" and "invalid name. ColAttach isn't recognized".

Just for understanding, don't we have to create that collection first before clearing it? Or do I understand that wrong?