PowerApps | Upload Document with Metadata the Easy Way

After watching how other people upload metadata with documents in a SharePoint Library I had to come up with a video with a much simpler method. First thought for a developer is to KEEP IT SIMPLE.

In this example I show how to upload an document to SharePoint with very little JSON and only a 3 step PowerAutomate.

The reason I chose to design the PowerApp this way, is if there are changes to the document Metadata in the future. You will only have to update your PowerApps. Using the JSON method you will need to update your Power Automate Flow and PowerApp to match the new columns.

PowerAutomate button: UploadafiletoSharePointfromPowerApps.Run(Last(DataCardValue10.Attachments).Name,Mid(JSON(UploadImage.Image,JSONFormat.IncludeBinaryData), Find(",", JSON(UploadImage.Image,JSONFormat.IncludeBinaryData))+1, Len(JSON(UploadImage.Image,JSONFormat.IncludeBinaryData)) - Find(",", JSON(UploadImage.Image,JSONFormat.IncludeBinaryData)) -1));
UpdateContext({varMyTimer:true});

OnTimerEnd: Refresh(Documents);UpdateContext({varMyTimer:false});UpdateContext({varMyPopOut:true});

SaveForm Button:
SubmitForm(frmDoc);UpdateContext({varPopup:false})

Gallery Items:
Filter(Documents,Title=Last(DataCardValue10.Attachments).Name)

[andrewhess]

This was a long one but there was a lot of information! I'll try to make shorter quick videos!

[AmyPhillipsCharmCity]

Just want to let you know that this solved an issue I had spent a week looking for. thank you so much!

This is marvelous. I just want to ask anyone here, just to understand... unless the user completes the popout, the file would remain untagged?

[jeffhenning]

Good video! I was wondering this myself. The drawback is that this brings back the ability for the user to upload the document and leave the metadata blank (by just closing the app after the file uploads). The Shane/Reza method let’s me make sure all metadata is filled out before uploading the file and passing in the metadata, which my process insists on.

As an alternative, using your method, the Automate script could upload the file and then wait, for say an hour, and then refresh the record (or start another Flow) and delete the file/record if that record’s metadata hasn’t showed up yet.

You’ve definitely given me something to think about. Thanks!

[imranali]

Hi Andrew, very well explained and great video, just one question, there is a video link in your description; its been deleted, was there an updated video of that video? Thank you!! 👍👍👍

[sweatshoes]

This worked perfectly! Thank you! One quick question though. What's the bets way to get this intake form into the user's hands? I mean, can we launch this form directly from the Library? Or can I launch it on a Button click from the SharePoint page?

[yehunlavolontededieu]

Hey Andrew i thank you so much again for this video that solved my all requirements in my previous project, You truly a PP legend. Now for another project I have a requirement for a user to be able to upload/create a folder in SP from PowerApps not only single docs. Q: Can I upload a folder with docs instead of single doc? ? Literally we wanted to mimic SP library feature in PowerApps upload+display docs+folders . So users don't need to interact with the backend SP library

[DistortionUltra]

This is great and all, but is there a way to have it do this, but instead of from a powerapp, just trigger on when someone drags and drops a file in the sharepoint libary? We do not have a folder setup, but would like it so that when I drag a file into a specific view, it auto applies the metadata colums in that view to the file.

[callbainis]

awesome video! Do you know how to update a muti select combo field that is set to accept multiple users from power automate to a document library? If so could you reply with the steps or make a short video?

[adilaishak]

Hi Andrew, needs your advice on project I’m working on. I exported a collection to CSV format and have 3 metadata columns in the document library but I only wanted to update just one metadata column with value from the collection/text column. Nothing is working for me at the moment.

[mr.arthur]

H Andrew, thanks. Do you know how I can set metadata to a folder with power apps

[ScottHemsley]

Is it possible to to the Upload Attachment and the save Form(Metadata) in the one click button?

[RajivSTube]

this video is too long for set metadata properties by using gallery timer and so

[yehunlavolontededieu]

Thank you so much, you saved me. Only this solution worked for me as my metadata set up in Termstore. @MSFT There has to be somehow a direct way to upload doc and add metadata, All these workaround isn't fair MSFT...If you didn't come up with this solution my project would fail. thanks a lot