QTT - Power Apps upload a file to SharePoint and set the metadata

In this Quick Thursday Tip (QTT) you will learn how to upload any file to SharePoint and set the file metadata at the same time. Pretty awesome stuff!

[CodewithLalit]

You are genius...not only you know great and share the same...but your approach and explanation clears a lot of unanswered questions and introduces us to many more concepts..Thanks Again...you are helping the community BBBIIIGGG TTTIIIIMMMEE

[tenisviejos]

Thanks for the quick tip, once you are in flow (and learn to love all of its nuances) the sky is the limit!

[derekgray]

Aww man this is awesome, just what I've been looking for my our new App for Document Management and it works perfectly....document upload and adding two additional pieces of metadata, the document title and DocID which links it to its parent list item. The only issue I have is how to launch a view of the related document without using a variable (varFileLink) so that when viewing each different document list item, users can open the document in another browser session to either view or download a copy.
By the way, Chewy rocks!

[julien]

Great thanks for sharing. I would suggest later displaying "MULTIPLE" SharePoint Attachments in a PDF file based on the record attachment/s. Thank you!

[NKBobcat]

Thanks again Shane! Christmas decorations look great!

[callbainis]

Awesome video! You saved my powerapps life. I do have a question on how to make it work with a multiselect choice column. Any ideas?

[BethPatrick]

Amazing! Thanks so much. It’s all working for me, until I add dates as an update to the properties. 😢

[hoges]

Hey Shane, can you please do another one of these but using the Powerapps V2 connector? Also, add some Date metadata to document library too, kthx :)

[gstlouisable]

at 5 minutes in I do not get the "see more" to get the meta properties. What is the reason you have the "Respond to a PowerApp or flow"? I've tested adding hard coded static to one of the meta properties in Update file properties and it work. I just can't get it dynamically the way you were able to grab it from "see more". any idea?

[mmm-mekk]

Shane thank you very much, but all fields have to be filled, is there a way in which can we make this optional so that it also works when we just filled in 4 out of 5 fields for example

[PieterJansen-hq]

Shane thank you very much, but I think I'm getting crazy, no matter what I do it keep telling me "invalid arguments, 9 expected, 8 received". But my flow is just the same as yours (I have a bit more metadata fields...):

Set(varShowLoading;true);;

Find(", ";varFullFile)+1;Len(varFullFile)-Find(", ";varFullFile)-1));;

varFN;
Reset(AttachmentControl);;

[mr.arthur]

Hi Shane, good vids!! But how can I create a folder and set the metadata?

[DecentNamesAllGone]

Videos are awesome Shane, used loads of these over the years!
Is there a way to check for duplicate filenames before uploading, this works a treat but if there is already a file with the same name, it just overwrites it with no warning?

[ivylad]

Hi Shane, this is brilliant, but how can I make sure a file is attached?

[medug]

Anyone could help with choice field ? Dropdown.SelectedText not working. It returns error ''Invalid argument type (record). Expecting a text value instead "

[phyoga]

Hi Shane, this is awesome! I've recently helped migrate my company's SharePoint 2010 to Online and we have issues with metadata being wrong that we're tidying up and this will be hugely helpful for the future. Question: is there a way of doing this same thing when a file is moved from a Teams document library / channel folder to another SharePoint document library / document set? (Total PowerApps / Automate noob I'm afraid). Thank you!

[kyon]

Great Thanks. I have a question.
I want to select Multiple file 'on explorer'
Do you know this way?

[bekkahcrisp]

Quick question --- I can upload a document just fine to the library but when I go to "update file properties" and add in the dynamic ItemId I get the error "fix invailid expressions for the input parametes of operation 'update file properties' --- any ideas on why this may not be working? Driving me bonkers over here :)

[christophkeunecke]

Good day Shane, thank you so much for your great videos! You have helped me many times with this. I have a question about your "Power Automate Flow". I can't get the "Flow" to send a multiple selection of metadata from a "dropdown menu" to the SharePoint library. How do I specify it correctly in the "Update file properties"? I have tried many variations, but unfortunately did not get the desired result.

Hopeful greetings from Germany.

[william]

Hi Shane, great video, thank you so much! I wanted to ask is there a way we can leave some of the added "metadata or single line of text" columns empty? As I set couple metadata and tried to upload them to the SharePoint Document Library, and it worked. However, if I leave any of the "metadata" empty (meaning no value in it), PowerApps doesn't run, because all "metadata" must be filled, whether it's a number, date, choice, single-line column etc.

So, my question is, could you please advise what would be the workaround here? I was thinking to set "default" values of "metadata" to "Blank()" but it didn't work out.