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
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!
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
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?
Great thanks for sharing. I would suggest later displaying "MULTIPLE" SharePoint Attachments in a PDF file based on the record attachment/s. Thank you!
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.
Christoph Multiselect is storing the data as a table. You need the data to be a table also. I know this sounds weird but watch this video th-cam.com/video/gsk14D-CYRE/w-d-xo.html on Complex Columns in SharePoint. Hopefully once you understand the data structure you will have a better idea on how to update it in flow. Another trick. Go to flow and update the column in flow, then click ... > Peek Code. You will see the structure your manual selections made. This is what you need to mimic. This might be my next video. This is a fun question. :)
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 :)
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.
He Shane, I was just struggeling today with the same actions in flow, but then a level deeper. In my case we have a otap street and therefore in the flow I retreive the SharePointSite from dynamics settings to use as dynamic input properties. I would like to ask you if you know how to pass my property/value pairs in this set-up? Hope you understand what I mean.
Oke, you select the sharepoint site and library, so the connector wil return the columns in that library. I like to use the custom option and use a variable which holds my sharepoint url and library name. Now the connector is not able to retrieve the columns of my library because this is not yet set till the flow actually runs. I wonder if you knew how to set the value for those columns in this case.
I'm new to power apps and your videos are super helpful! Thank you! I have a question - I have a form now that loads attachments with metadata to my document library. I would like also when they click add attachment, that they can paste a link in there and add metadata. It works out of the box in SharePoint but via power apps my link no longer works. How can I achieve this (if possible)? Thanks!
@@ShanesCows, I have done this using the PowerApp V2 trigger. I have an input of File Content and a text for link to document. In flow with Create file for file name and File content I have an if statement that if the file content is empty use the link else use the file content. What I haven't been able to figure out is how to make the link actually work in the Sharepoint list. I get an error message saying the download was blocked. But if I copy the link and put it in the browser it works. But at least now it doesn't give me an error in flow. :) and I just have another field with the link. I'm still trying to make it work.
I have never set metadata on a folder from Power Apps or Automate :( You can create a folder by just adding it to the path, I show that in this video th-cam.com/video/2gE0e_AsdMw/w-d-xo.html but I haven't done folder metadata. :(
Why use the v2 connector? I still always use the v1 connector. 😎 They haven't given me a reason to switch. 😎 But noted, you are right I should probably do a v2. :)
@@carlw Hey Carl, if you get a chance could you look at it? Work has driven me to other thigns over the last week, but its time to get back at it. Thanks
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!
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?
Anyone could help with choice field ? Dropdown.SelectedText not working. It returns error ''Invalid argument type (record). Expecting a text value instead "
DId you see this video on updating complex sharepoint columns? th-cam.com/video/b4Fb57UsJLI/w-d-xo.html For a dropdown to a choice. Dropdown - Items = Choices(List.ColumnName) Update = Dropdown.Selected
In the flow in the Update file properties, don't use a trigger for the date as you did for other fields. Instead, insert a new step above and pick Initialize Variable. For the name, just type varWhaterverYouWantToCallIt, then for the type select string. In the value this is where you put your date trigger. Then back in your Update file properties date field, insert the varWhateverYouWantToCallIt. I've done this and it works. I got this piece from Reza Dorrani, but Shane Young you are still the MAN and I used the rest from you!!! I've learned so much.
Hi Shane, is there any way to get the Duration property value of a video file and map it to a custom metadata column (i.e duration) in SharePoint. I have a video library in SP where I would like to display duration to the user in a metadata column when a file is uploaded. I can see the value in details pane but not able to access it Thanks in advance
I am guessing you are passing strings instead of actual dates. Work on the flow to figure out what it wants for the column then send it what it wants or convert it to what it wants. You got this. 😎
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);; Set(varFullFile;JSON(Image1.Image; JSONFormat.IncludeBinaryData));; Set(varFileBase64;Mid(varFullFile; Find(",";varFullFile)+1;Len(varFullFile)-Find(",";varFullFile)-1));; Set(varFn;Last(AttachmentControl.Attachments).Name);; Set(varFileLink;jja.Run(varFileBase64; varFN; Ondertekenaar.Selected.DisplayName;Documentsoort.Selected.Value;Bedrijf.Selected.Result;Hoofdproces.Selected.Result;Ondertekenaar2.Selected.DisplayName;Proces.Selected.Value;Procedure.Selected.Value).sharepointfilelink);; Reset(AttachmentControl);;
Pieter you "Asked in Power Apps" 9 times on Accident. :( Easiest thing is to rebuild the flow but if you poke around enough you might be able to figure out your extra Ask.
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
Thanks. Very kind of you to say. 🤩
Thanks for the quick tip, once you are in flow (and learn to love all of its nuances) the sky is the limit!
Absolutely!
Thanks again Shane! Christmas decorations look great!
Thanks Bob. Merry Christmas to you! Though we got a lot more videos between now and then. 🎄
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!
Launch(FileUrl) would open it in a new tab. You could create a document library browser like this video th-cam.com/video/u-b8w9ea1kk/w-d-xo.html
Nice enhancement Shane!
Thanks 😎
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
You would need to make the flow adaptable so it knows how to deal with it. Coalesce will be helpful.
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?
Microsoft changed the connector. :( This video explains how to use the new one th-cam.com/video/vpjf5mD-COs/w-d-xo.html
Great Thanks. I have a question.
I want to select Multiple file 'on explorer'
Do you know this way?
Yes, but I don’t have a video. Need to do that one. 😑
Great thanks for sharing. I would suggest later displaying "MULTIPLE" SharePoint Attachments in a PDF file based on the record attachment/s. Thank you!
That's a great idea!
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.
I was having the exact same issue this morning. I got it to work with: Dropdown2.SelectedText.Value
@@briananonymity3578 Thanks, I'll test it tomorrow. But I think I got an error message. Thank you.
@@christophkeunecke3644 , were you able to get it to work?
Christoph Multiselect is storing the data as a table. You need the data to be a table also. I know this sounds weird but watch this video th-cam.com/video/gsk14D-CYRE/w-d-xo.html on Complex Columns in SharePoint. Hopefully once you understand the data structure you will have a better idea on how to update it in flow.
Another trick. Go to flow and update the column in flow, then click ... > Peek Code. You will see the structure your manual selections made. This is what you need to mimic.
This might be my next video. This is a fun question. :)
@@ShanesCows - Thanks Shane, I will try to implement it today. Thank you.
Boom! Thanks Shane!
Happy to help. Have a great day. 🐶
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 :)
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.
I was able to do this just now by setting the text box attribute Default fx = "" (blank). Worked perfectly
He Shane, I was just struggeling today with the same actions in flow, but then a level deeper. In my case we have a otap street and therefore in the flow I retreive the SharePointSite from dynamics settings to use as dynamic input properties. I would like to ask you if you know how to pass my property/value pairs in this set-up? Hope you understand what I mean.
In the Update file properties step I mean.
Hey Paul, I don't follow. :( Sorry. Maybe leave another comment and I can try again.
Oke, you select the sharepoint site and library, so the connector wil return the columns in that library. I like to use the custom option and use a variable which holds my sharepoint url and library name. Now the connector is not able to retrieve the columns of my library because this is not yet set till the flow actually runs. I wonder if you knew how to set the value for those columns in this case.
I'm new to power apps and your videos are super helpful! Thank you!
I have a question - I have a form now that loads attachments with metadata to my document library. I would like also when they click add attachment, that they can paste a link in there and add metadata. It works out of the box in SharePoint but via power apps my link no longer works. How can I achieve this (if possible)? Thanks!
Yikes. I am sure it is possible but I haven’t been down that road at all. 😑
@@ShanesCows, I have done this using the PowerApp V2 trigger. I have an input of File Content and a text for link to document. In flow with Create file for file name and File content I have an if statement that if the file content is empty use the link else use the file content. What I haven't been able to figure out is how to make the link actually work in the Sharepoint list. I get an error message saying the download was blocked. But if I copy the link and put it in the browser it works. But at least now it doesn't give me an error in flow. :) and I just have another field with the link. I'm still trying to make it work.
Hi Shane, good vids!! But how can I create a folder and set the metadata?
I have never set metadata on a folder from Power Apps or Automate :( You can create a folder by just adding it to the path, I show that in this video th-cam.com/video/2gE0e_AsdMw/w-d-xo.html but I haven't done folder metadata. :(
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?
Hi Shane, this is brilliant, but how can I make sure a file is attached?
If IsEmpty(AttachmentControl.Attachments) then you know they have not attached anything.
@@ShanesCows many thanks Shane. Appreciate all you do and share 👍
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 :)
Why use the v2 connector? I still always use the v1 connector. 😎 They haven't given me a reason to switch. 😎 But noted, you are right I should probably do a v2. :)
@@ShanesCows A good reason is that the V2 flow allows Run only users and V1 doesn't 🧐
Great thanks. Does this work for lookup, choice and managed metadata fields too?
It should. You will need a bit more elbow grease over in flow but should work. I haven't tried though.
@@ShanesCows Tx...... I hope 🙂
Did anyone ever make it work on a lookup column? It is giving me nightmares at the moment.
@@vxchemical I think so. I'm not at the computer but do tlrecall employing the "Choices" expression pointing it to the list and field.
@@carlw Hey Carl, if you get a chance could you look at it? Work has driven me to other thigns over the last week, but its time to get back at it. Thanks
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!
Power Automate flow. You would have to create a flow for choosing the file to move, moving the file, and the setting the metadata
@@ShanesCows Brilliant. thank you so much!!
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?
th-cam.com/video/Ap3_Ea9H8b0/w-d-xo.html I made a video on avoiding duplicates that should help. :)
Great video Shane, thanks again 😁!!!
My pleasure!
Love this one, thanks Shane.
🐶 you are welcome
Thanks Shane for the tips!
You bet!
Anyone could help with choice field ? Dropdown.SelectedText not working. It returns error ''Invalid argument type (record). Expecting a text value instead "
DId you see this video on updating complex sharepoint columns? th-cam.com/video/b4Fb57UsJLI/w-d-xo.html For a dropdown to a choice.
Dropdown - Items = Choices(List.ColumnName)
Update = Dropdown.Selected
Hi.... I am not able to save a date only column as metadata using Power Automate from PowerApp while uploading file....can you help?
It shouldn’t be any different?
@@ShanesCows tried with a lot of date formats but everytime giving error
@@ShanesCows hey Shane! I am seeing this same issue. I can get choice and text columns to update correctly but dates are being weird. Please help!
In the flow in the Update file properties, don't use a trigger for the date as you did for other fields. Instead, insert a new step above and pick Initialize Variable. For the name, just type varWhaterverYouWantToCallIt, then for the type select string. In the value this is where you put your date trigger. Then back in your Update file properties date field, insert the varWhateverYouWantToCallIt. I've done this and it works. I got this piece from Reza Dorrani, but Shane Young you are still the MAN and I used the rest from you!!! I've learned so much.
Does this still work nowadays?
Yes, but it changed a bit so I made a new video with the v2 connectors. th-cam.com/video/AHWvG2C9vQo/w-d-xo.html
You are the man!
Thanks 🙏
Hi Shane, is there any way to get the Duration property value of a video file and map it to a custom metadata column (i.e duration) in SharePoint. I have a video library in SP where I would like to display duration to the user in a metadata column when a file is uploaded. I can see the value in details pane but not able to access it Thanks in advance
Are you using MS Stream at all?
It works great except for a multiselect choice column. How do we get that type of column meta data pushed to the sharepoint library?
When I try it with this method, it always copied just the last choice in my multichoice.
@@jimmynewman5158 Did you ever figure out how to get it working with a multiselect choice column?
Brillant. There is a way to add multiple files at same time.? And how do you add the loading icon ?
The loading icon is in this video th-cam.com/video/UWy5I_MuIgU/w-d-xo.html
I dont have an ask power apps or a see more?
Microsoft changed things this video explains the new trigger th-cam.com/video/vpjf5mD-COs/w-d-xo.html
Thanks Shane
Happy to help
Amazing! Thanks so much. It’s all working for me, until I add dates as an update to the properties. 😢
I am guessing you are passing strings instead of actual dates. Work on the flow to figure out what it wants for the column then send it what it wants or convert it to what it wants. You got this. 😎
Is max upload size still limited to 10MB?
you can set it to +- 40MB? in Power Apps limit is 50MB but very slow in uploading
maxlimitsize
50 like Sundra said.
is it possible to upload csv from user and read it on Power app. I mean when I run the powerapp user can upload csv and read csv via powerapps
Try this video for an idea th-cam.com/video/QcWjAt7QVn4/w-d-xo.html
ur head is litterally blocking what we need to see?
New Video using the new trigger th-cam.com/video/AHWvG2C9vQo/w-d-xo.html
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);;
Set(varFullFile;JSON(Image1.Image; JSONFormat.IncludeBinaryData));;
Set(varFileBase64;Mid(varFullFile; Find(",";varFullFile)+1;Len(varFullFile)-Find(",";varFullFile)-1));;
Set(varFn;Last(AttachmentControl.Attachments).Name);;
Set(varFileLink;jja.Run(varFileBase64; varFN; Ondertekenaar.Selected.DisplayName;Documentsoort.Selected.Value;Bedrijf.Selected.Result;Hoofdproces.Selected.Result;Ondertekenaar2.Selected.DisplayName;Proces.Selected.Value;Procedure.Selected.Value).sharepointfilelink);;
Reset(AttachmentControl);;
Pieter you "Asked in Power Apps" 9 times on Accident. :( Easiest thing is to rebuild the flow but if you poke around enough you might be able to figure out your extra Ask.