⬆️Upload to a SharePoint Library with Metadata
Вставка
- Опубліковано 15 вер 2024
- In todays video we will create a SharePoint Library with multiple metadata columns and learn how to use the Attachment Component in Power Apps and upload a file to the library we just created. Since there is no way at the moment to upload a file directly from Power Apps into SharePoint without using an Edit Form, we are going to use some help from a simple but very helpful little Power Automate Flow.
If you want to learn more about Power Apps in cooperation with SharePoint, you are welcome to follow the channel and subscribe to the playlist here: / @enea
Feel Free to follow me on other social media platforms as well:
linktr.ee/Enea...
Buy me a pizza 🍕- bmc.link/eneal...
Thank you for using the multi select combo box in your example. I have been up all night trying to figure out how to do it.
Thanks! Subscribe to the channel if you like, more is to come! :)
Hi Thank for sharing this tutorial, please share second part of the video to patch the attachment data to a share point list
i appreciate your video, it was a good video. but i wanna ask about the last flow that your explaining there is an file.name in the create file section, how do we do that? and I got an issue when I insert the code for the flow in the powerapps
hoping you will answer my question, best regards
Hi, the data that goes in the file name section comes from the Power App. You can see it in minute 24:33.
@@Enea Do you use a specific expression to obtain the file name?
@@JNineification Hi, no I am creating it with the the requestID and requestor name coming from Power Apps
Hi there! Is it possible create metadata columns to a specific folder? I tried to create them, but the columns are visible in the complete library. Thanks!
Hi Maria, I am afraid not. What you could do (I think) is to create different views for each folder and show and hide them.
I am wondering if you can explain a little more how you got the file name with the extension? I tried creating a file name but I don't seem to have an option for file name in the fields.
Did you get the answer? I really need answer to this question. Please help if you have the answer now.
@@mehboobakram5170 When you are passing the parameter for file name in flow function, use this one "First(YourAttachmentDataCard.Attachments).Name". It will upload file with extension under column "Name" of your Document library. It works for me. Hopefully it helps.
Did you ever figure it out? I cant seem to get the excel to populate in the doc library. Only a blank file.
The code required on mine does not have the {file: } wrapper.
Here is what worked for me with inputs of type (file) and (text):
DEVapReloadFile.Run(
{contentBytes: First(FileInputBox.Attachments).Value, name: First(FileInputBox.Attachments).Name},
First(FileInputBox.Attachments).Name)
Ok, as long as it works, go with that :)
Hallo, sehr gut, du hast das Video bzw. Beschreibung auch in Deutsch ? Danke und Gruß
Danke! Nein, leider nicht, Englisch nur
Hello, thank you so much.
I am wondering if there is any way to view directly p7m files without downloading on the client PC
Hi, happy to help! I am not familiar with such files, the video is about uploading documents with metadata in a SharePoint Library. I am not demonstrating how to view files in the app. That might be a topic for another video :)
Outstanding video. But for me "Combobox1.Selected. Mail" is giving blank. Due to which the flow is also getting failed. Do u or anyone have any workaround ? Someone please help. Need to send the people picker value (combobox) to SharePoint metadata
Put this: combobox1.Selected in a test gallery or table just to see what data you have in there. If Mail column is blank then you need to check your data source
how we can do the same from power pages? on click of submit button we should have to send metadata along with file using ajax call it should trigger flow and save metadata and file in sharepoint library
Sorry I am not a Power Pages expert
@@Enea np..its done :) ...only file content not coming I am checking
You lost me after 24 minute, my CreateFileFlow works manually tested but, in you demonstration the powerapps Upload button fx did not like the semicolon between contentBytes parameter and the name parameter (i.e. it did not seem to like the number of parameters). I rechecked the syntax but no success. Then you started resolving a problem that was not clearly explained. So whilst I got 90% of the way, I don't know what else to do to get the attachment selected into the flow.
Life saver. Thanks so much . Q. Could you create folder before creating the file in power automate and push the files within the folder that's created? My project requirement is users should be be bale to create folders and store files. Means I need to push from powerapps not only individual docs but also folder and store the file/files. thanks for your support
I think you are the second asking this, so I am thinking of making another video where I showcase this. Will try this weekend!
@@Enea Thank you. Also if you add metadata to it.
How to check from the app, when user submits upload button, the operation is successfull... There is no indication to the user whether it has failed , succeeded, running..
Sorry I am new to SharePoint...
Use the notify function
can we increase no of attachments?
Yes the attachment control has a property called no of attachments
Thanks, good Vid. But how can I set the metadata to a folder in a document library with power apps?
Folders are also lists, the process would be the same in theory but I can check and maybe make a second version of this video.
@@Enea I agree, it should be the same, but it does not work the in your vid. You can use the custom option, but how can I get my variable from power apps in theren. Using in flow, power apps v2.
Great video...I've a question: it's possbile create a from like this with multi library?
Of course it is, the logic is more complex but it is possible
@@Enea Do You have a tutorial about?
Unfortunately not, but its a good idea. Might do a my next video on that use case 👍🏻
@@Enea
you will have my eternal gratitude:-D
I am facing issues in the button function. While using "name " it's showing error
Did you ever figure it out? I'm having the same issue.