Solved: Re: Uploading button

Tamras · ‎06-12-2019

Edit -- i think I just figured this out and I can't delete this post. I just inserted a new 'attachment' field...but I read a post somewhere indicating PowerApps does not support more than one attachment fields so unsure if this is the right way to do it. I'll continue testing.

------

Is it possible to add a button in PowerApps that would upload files to SP Document library? Not attachments. I basically need two attachment controls -- one control would be to attach all supporting documents while the other to upload docs requiring review and approval. I want the latter to be stored in a document library while the supporting docs can remain as attachments on a list item. Search results mentioned about uploading the attachments to a document library using Flow but I don't need all attachments to be uploading -- so I'm hoping its possible by adding an 'upload' button. Basically, when user clicks the upload button, user selects the document and it will be uploaded in library. I just need to figure out what type of control I could use for user to select the document from local drive.

Tamras · ‎06-17-2019

Thank you both. I finally got this to work after many attempts.

@RandyHayes - the link provided helped but it didn't quite work, it was missing a step or for some reason it was giving an error message regarding headerSchema. It worked after removing the "headerSchema" settings from definition.json file, except can't edit the flow again, it was giving a Cannot read property 'dynamicallyAddedInfo' of undefined error. Bottom line, I ended up with the following "triggers" settings:

"triggers":{"manual":{"type":"Request","kind":"PowerApp","inputs":{"schema":{"type":"object","required":[],"properties":{"file":{"type":"object", "title":"File Content","x-ms-content-hint":"FILE","properties":{"name":{"type":"string"},"contentBytes":{"type":"string","format":"byte"}}}}}}}}

It doesn't seem to matter if I create a Manually Triggered or PowerApps button, I still ended up modifying the definition.json "triggers" settings.

With Manually Triggered flow, I had to change 3 items

triggers > manual > kind: PowerApps (from triggers > manual > kind: Button)
remove "headerSchema" setting - in order to import.
remove "x-ms-dynamically-added" setting in order to edit the flow.

With PowerApps button flow, I only needed to add some properties

Original settings - was returning formula syntax Run() in PowerApps

"triggers":{"manual":{"type":"Request","kind":"PowerApp","inputs":{"schema":{"type":"object","required":[],"properties":{}}}}}

Inserted the following in "properties":{} - returned formula syntax Run({file:Record}) in PowerApps

"file":{"type":"object", "title":"File Content","x-ms-content-hint":"FILE","properties":{"name":{"type":"string"},"contentBytes":{"type":"string","format":"byte"}}}

**Not sure if the above can be shortened further but its working so far and I can also edit the flow.

Lastly, the formula on button's OnSelect:

UploadToLib2.Run({file:{name:AddMediaButton3.FileName, contentBytes:AddMediaButton3.Media}})

The PDF file successfully uploaded to SharePoint.

Flow:

Note: I don't have Flow Studio, I just manually modified the json file in NotePad++

View solution in original post

Pstork1 · ‎06-12-2019

Flow is still your best bet. You can kick off the flow using a PowerApps button and pass the document data to flow as a parameter. Flow can then easily save the document to a SharePoint document library.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

RandyHayes · ‎06-12-2019

@Tamras

Yes, you can definitely use the Attachment control to gather local files.

In your case, I would consider pulling the second list (the supporting documents) out of your EditForm. Yes, you can actually select the Attachment control in the Form and cut and paste it outside of the Form. Then you have a little more flexibility on getting local files into that control.

However, from there, Flow is the way to go.

Create a Flow that accepts a FileName and the ContentBytes. In the Flow use the Create File action to specify your Document Library, the folder, the File Name (as passed from PowerApps) and the File Content (as passed from PowerApps).

You could adapt that to do multiple files as well if needed.

I hope that is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes
Really want to show your appreciation? Buy Me A Cup Of Coffee!

RandyHayes · ‎06-12-2019

@Tamras

Actually, just looked at a couple things here. Not sure if this is completely accurate at this point as I need to investigate more...

The main reason that I used to pull the Attachment control out of a Form was twofold:

1) The Attachment control used to be on the Insert Controls list...it was removed some time ago.

2) I liked that control because it would open a File Dialog with "*.* All Files" as the file type. Using an Add Picture control was an option, but it always opened the File Dialog with "Picture" as the file type...very annoying if you are dealing with a bunch of Doc or PDF files.

So, if I pulled the Attachment control out of the form and stood it on its own, it would give me the support to get the File Dialog that I wanted.

To cut to the chase - I just looked at a sample App that I put together that used this perfectly. In that app I had also put the Add Picture control for contrast in testing. I just clicked on it and it brought up a Dialog with "*.* All Files". What??? Went into another app and threw an Add Pictures Control and same thing!!

So, either there is a new bug with the Add Picture control, or they changed it to allow all files to be the default. But, technically at this point...I would ditch the attachment control all together in favor of the Add Picture control.

Just thought I might add that to your thoughts.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes
Really want to show your appreciation? Buy Me A Cup Of Coffee!

Tamras · ‎06-12-2019

@RandyHayes The Add Picture control only allows 1 picture or file? I need something that would allow users to add multiple files. But I like the idea for another app I need to create after this one. Thanks.

RandyHayes · ‎06-12-2019

@Tamras

Well, I should have expanded on my explanation a bit...

I use the Attachment control to build a collection of files. Again, primarily using the control only because of the "*.* All Files" dialog.

So, now, if this holds true that it will stay that way, I can discard the attachment control and use the add picture control - this, like the attachment control, simply dumps info into a collection which is the real place where I deal with multiple files.

Hmmm, I think I might have explained that properly!?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes
Really want to show your appreciation? Buy Me A Cup Of Coffee!

v-yuxima-msft · ‎06-13-2019

Hi @Tamras

Do you solve your issue with @RandyHayes 's and @Pstork1 's suggestion? if yes, please accept it as solution.

Best Regards.

Yumia

Tamras · ‎06-13-2019

@v-yuxima-msft I will once I get it working. I'm still trying to get add picture to work as for selecting the file to download then I will add Flow.

@RandyHayes I am not getting this right. I did an add picture media in PowerApps. But after I selected the file to be uploaded, the display changed to "Change Picture" -- is there a way to change it to the picture's URL? Or did you mean to add a column in SP List with "hyperlink/picture" type? I'm trying this now...

RandyHayes · ‎06-14-2019

@Tamras

Yes, you can change the text of the Add Picture control by chaning its ChangePictureText property.

When you say the URL, are you meaning the URL from where you got it, or the internal URL? Useful properties of the control are FileName and Media. If you use the Media property in text somewhere, that will display the internal resource URL.

I hope that is what you were looking for.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes
Really want to show your appreciation? Buy Me A Cup Of Coffee!

Tamras · ‎06-14-2019

@RandyHayes Thank you. I really like the Add Picture control to select a file once I learned more about it. Although, it defaults to Image Files I just added a hint for users to change it to All Files. Now I just need to set up my flow and trigger it using an Upload button I added in PowerApps.