UPLOAD files from Power Apps to SharePoint Document Library ➕ Set Properties
HTML-код
- Опубликовано: 28 май 2024
- In this Power Apps tutorial, we will deep dive into uploading files to SharePoint Document Libraries from Power Apps by using the new Power Automate V2 trigger (File input type) and set file properties in a one go with JSON magic.
The video is a step-by-step guide starting from building a SharePoint document library, to creating the user interface in Power Apps for file upload using attachments control, uploading single and multiple files using Power Apps V2 trigger in Power Automate flow and a lot more.
Key Learning Points:
✔️ Leveraging the attachment control for file uploads
✔️ Call Power Automate flow from Power Apps to Upload Files of any type (Images, documents)
✔️ Pass file properties from PowerApps to flow and leverage JSON for dynamic property mapping
✔️ Save files in SharePoint Document Library
#PowerApps #SharePoint #PowerAutomate #PowerPlatform
⬇️ Download Apps shown in video ➡️ link in Community Tab for Channel Members (Silver Club 🥈 or higher)
00:00 Introduction on uploading files to SharePoint from Power Apps
00:20 SharePoint Documents Library
00:53 How to Upload file to SharePoint Library from Power Apps
04:25 Power Apps v2 trigger in Power Automate flow
07:09 Trigger flow from Power App to Upload file to SharePoint
11:50 Set file properties in SharePoint for existing files
13:22 Upload and tag file from Power Apps to SharePoint Library
18:21 How to upload & tag multiple files from PowerApps
19:52 Full document library experience in PowerApps - Наука
Great one Reza Thank you ❤
Thanks so much
Great insight on leveraging the 'Update File Properties' for dynamic mapping - your tip is truly excellent and adds significant value to the process! Thank you !
Glad it was helpful! Thanks so much for watching
Thanks - Your update of document properties is brilliant. No need to update the file column by column. GREAT TIP
Thanks Cedric!
This technique also allows us to call the same flow from any app to upload files to any SP library - all we have to do is pass site url, lib name, folder path and properties
The Dynamic Mapping is a game changer. I have written a complete .NET Web Service to allow multiple external service upload files to different SPO Sites with different Content types (aka properties). Because of the dynamic-ness of the requirement, I went the full code option. But now I can see that it's fully possible in Cloud Flows, and I assume Logic Apps too, this could open up lots of opportunities.
Really you are master of Power Apps and almost all the things you can do here. I learnt a lot from your experiences and keep learnings. Your vital and crucial contribution to my modern journey. :)
Glad to hear that
Finally got round to watch this week's video. I know this will come in handy so uploading the solution into my Reza's Environment. Great techniques and tricks you've demonstrated. Thanks for sharing.
Awesome! Thanks so much
I want to thank you for your hard work, creativity, and dedication to fostering learning opportunities. Your video serves as a beacon of inspiration for learners everywhere, and I have no doubt that it will continue to make a positive impact for years to come. Thank You😊
You are most welcome!
Wonderful tutorial. Just like all your videos.
Thanks Darren
how are there only 500 thumbs up for this video!! What a slick move using the form properties in powerautomate!!
Sorry I missed this one when you first released it.
Thank You
Excellent. Looking forward to redoing my uploads in a more up to date fashion. Haven't played with Powerapps or SP for over a year.
Oh wow a year now! Comeback Carl :)
@@RezaDorrani 😃 Hope to this or next month
This is great and I like how clearly you explain things. I can see the value in this for times when I have a bunch of files to upload and I want them to all have the same properties, but I can’t think of any other use cases, though I’m sure there are plenty and am wondering if you could mention a couple to get me thinking more. Thanks!
Thanks for the compliments Glenn.
1 option can be a scenario where we can build a reusable flow to upload files which can be called from any Power App. All we have to do it pass the site url, doc lib name, folder path and file properties to flow.
Very smart method. Thank you. I was looking for how to upload files.
You are most welcome
Your videos are really helpful and i am gaining a lot from your videos
Glad you like them!
Just wow ! another great vid. Thanks !!
Most welcome
Great video, thank you Reza!
Welcome Saulo
Thank you Reza, your excellent video will increase my Power Apps skill very fast. Thanks again.
Glad to hear that
@@RezaDorrani I've followed your video to build the upload functions. Could you elaborate a bit more on the 'FormInvoice.Updates' aspect? Thanks.
@@jasonhuo2020 Its as shown in video. Form control has an updates property that includes all the data. We simply pass that to flow by converting it to JSON.
@@RezaDorrani Thank you Reza!
As always, Thanks a lot.👌👌🤗🤗
Most welcome
excellent video Reza, regards.
Welcome
Thank you for this video. For the document library experience do you have a workaround the 2000 items delegation limit? My library is composed of more than 5000 items therefore all files and folders are not showing and all the SharePoint Library properties are non delegables except the ID. Moreover in your last video I saw a table control with toggle control. How did you do that? Thanks!
The document library experience demonstrated in video is fully delegable. Its based on one of my old videos.
Channel members can download and try the app (check video description for details)
This is really timely,
Thanks @Reza
Most welcome
Reza, thank you very much. I am slowly getting into powerapps to create efficiency on some of tasks we do at work and your videos have been amazing. I do have a question. Is there a way to create a folder in the document library for the uploaded files? Instead of all the files being placed in the root of the document library instead it will create a folder for the entry and place attachments inside. Is this done in the power automate?
Folders would need to be done via power automate.
Thank you Reza 😊😊
Most welcome
@@RezaDorrani The task has been completed thank you so much for your help on this video
Hi Rera, thanks a lot ;) How do you manage delegation when you look items on subfolders ? Maybe i am wrong but the folderpath is not a property delegable to sharepoint. This can be problematic for performance and large document libreray (with exceeds 2k doc).
ruclips.net/video/TmRFAP7xTwk/видео.html
Hey, thank you for sharing this.
If you don't mind me asking , I typically use a Refresh() on the data connected to the gallery. Is using a Reload type action more efficient?
Refresh - refreshes the connection and reloads all the data
Reload technique shown in video - only loads the updates (caching)
Awesome one. Thank you Reza.
For the reset variable you set to reload the gallery, can the formula be in the onvisible of the screen.
Yes it could
Great guide! Thank you very much. In addition to filter the items in the gallery with all the documents, can you help me add a sort by last modified date aswell?
I have done videos on sorting and filtering for lists. Similar logic will apply here.
Thank you, very helpful. Is there a way to pass the folder path when uploading to save a file to a subfolder in the library? thanks
Yes, I think that's what I do in the last part of the demo. I have shared the entire solution with members (check description for details)
Nice video Reza 😊 why don't use a timer control to reload the gallery after the upload ? 🤔
Because I am not a fan of timer control :)
Thanks Reza love your video worked like a charm. I have an extra step Im hoping you can help me with. I have on my form a drop down looking up existing folders in my document library and a text box that shows the full path of the folder. How would I save the attachments into the selected folder. I'm struggling to make this work. Many thanks. You are the god of powerapps/automate!
Most welcome!
I am not sure how to do that extra step as I would have to try it out myself :)
Video description has link to download the solution (members only - check description of video) in which I shared how to make dynamic file paths.
Thanks for the video, very useful content! Question- Is it possible to create multiple order list with attachments using Sharepoint & Powerapps bypassing PowerAutomate?
I am not sure about the possibilities. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
This is great Reza! thank you so much for sharing, quick question... Is there a reason why the reload should be using a button? would you be able to use it inside the upload file button?
You could use it anywhere but there is a timing angle to it (as sometimes flow completes, but the file is still uploading for some reason)
@@RezaDorrani thank you Reza, I am using your approach for "named formulas" and now the gallery refreshes by itself. Thank you for all your contributions!
Great! Question: Is there a way to ensure file integrity before upload to sharepoint, or check file integrity once is in sharepoint with flow? Ensure that the file is not broken, if the file size = 0, send a notification
I dont think we have those options
Another amazing video Reza thank you 👍👍, quick question if I have a version 1 document, and I want to add a version 2 document the flow just updates version 1 and not create version 2 any idea why?
File with same name will be overwritten. Not sure if it handles versioning. May be best to rename files so they have unique names.
@@RezaDorrani Yes thank you i went with something like this :
UpdateContext({spineer2: true});
// Check if the file already exists
If(
!IsBlank(
LookUp(
TESTInvoices, // Replace TESTInvoices with the name of your SharePoint document library
FileName = DataCardValue6.Value
)
),
// If the file already exists, show an error message
Notify("File name already exists", NotificationType.Error),
// If the file doesn't exist, upload it
FinUploadDocument.Run(
JSON(
Form1.Updates,
JSONFormat.IncludeBinaryData
),
{
file: {
name: First(attach_1.Attachments).Name,
contentBytes: First(attach_1.Attachments).Value
}
}
);
Reset(attach_1);
ResetForm(Form1)
);
UpdateContext({spineer2: false});
Hi Reza
Thank you for this great demonstration. I would like to know what the steps are if you would plug the data into the different columns (at 15:37, instead of doing it dynamically like this? Reason I ask, is because i do not get the option for File properties to add to the json function.
You would need to parse json and manually map.
The file option is available for all to use. Not sure why its not working for you.
@@RezaDorrani I'm in the same boat. The "File Properties" dynamic content does not show up for the json expression. Not sure if this is a wider-spread issue.
@@isaiahmore Video description has link to download entire solution (members only- check description for details)
It seems like such an over site that there is no document upload control. Do you think there is a reason for that? Do you think they might create on in the future?
Thanks for the video. You always do such a great job
I’m not sure what the reason is or if it is a planned feature in the roadmap
Great, helpfull , Thanks
Glad it was helpful!
This is gold Reza! How about creating a Link file (.url) instead of uploading an attachment. What would the flow and the onSelect logic look like?
Thanks!
I have not done any work with url type column hence not sure.
No worries, thanks for the swift response@@RezaDorrani
Hi Reza, thanks for the video. I have followed the video to the point where you get to editing properties as I don't need that part for now. When I attach multiple files only the first file is being uploaded into Sharepoint. Do you happen to know why this might be happening?
I have not come across this issue and hence not sure what is the cause for your issue.
Video description has link to download entire solution (members only - check description for details)
I would also recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Appreciate the reply.
Hi Reza, Thank you for this video! Very clear steps. I have joined recently and would appreciate some help on how to download the example.
Link to download is in community tab of channel. You will need to check the posts there.
I just joined with a silver membership as you mentioned in the chat that you can upload to a specific folder. I need my users to only see their folder in the library and I set the folder name to the ID of the form in another list. That is done with a simple create folder flow. When I add a parameter in the flow for the folder name, it changes the flow type from record to text and it fails. Is there a way for me to dynamically pick the folder name in this flow? I tried adding a get item to get the ID of the list record, which is also the folder name. Any advise would be greatly appreciated.
If you have security set on folders, then they can see their folders. You are not picking folder name dynamically in flow. You would be doing that in your app and passing folder context to flow.
@@RezaDorrani Unfortunately, multiple users need access to all folders as multiple users upload files through different processes. I filter on the Folder. I tried to set a parameter for the folder path and just decided to go back to having them Launch to the library to upload files. They have a gallery to view them. Thanks anyway! Love your work!
Thank you so much for your video, I really learn a lot. 🥰 However, I'm wondering that whether we can upload & view the uploaded attachment both via attachment control and the uploaded attachment is saved in document library. Looking forward to your reply and if you make a video or introduction for that will be perfect! Thank you!
I did not understand the question.
Hi Reza, awesome as usual, I just have one question, can we upload files to the FTP site, and share the uploaded document as a link as QR code
I have done no work with FTP connector hence not sure
I just love the way you explain. Being a beginner, I've learned a lot from you. I would like to ask if you have made a sample project for beginners. It would be appreciated if I could get the link, as I tried to find it but couldn't. Thanks again❤️
Thanks Uzair.
I am currently running a LIVE training program and one of the upcoming training programs will include step by step builds of scenarios.
Training is offered via channel memberships.
@@RezaDorrani Can I get the information how to enroll in that course which is being ran live?
@@uzairfarooq4622 On web browser (on desktop), open my channel and click on JOIN button.
ruclips.net/video/F-QmdLLF7CE/видео.html
Thanks for Sharing Reza. 💥 tbh - I prefer to use Patch and use the attachment control as you demonstrated. Not looked at adopting this for the new OneDrive "tag" feature yet though. 👍
Thanks Spen!
Patch function to upload file to a doc library? Is that possible?
@@RezaDorrani Ahh.. seems I really must try to do 1 thing at a time.. LOL.
Hey Reza, I am using your method successfully, which is great, thanks for sharing!
Question for you: Is there any way to generate a unique ID for each uploaded file? I am renaming these files based on information from properties, but when multiple are uploaded at once they'll be named the same way, I am trying to add an each in the file name that will differentiate them from one another...
You can always append a timestamp or a guid to document name using expressions in power automate
@@RezaDorrani yessss thanks
Hi Reza,
thanks for the video. One quick question- If i upload multiple files, the flow would run multiple times. The issue is that in my flow I modify the uploaded files and send out the results to the end user via email. And so, if I for example upload 3 files using this method, they would receive 3 emails (as flow ran 3 times). Am I missing something, or is this how the solution works, is there a workaround? many thanks!
The solution is designed to trigger multiple flows. I did not have an email process in my flow to send notification.
Greate content! But i have been stuck with file property in button OnSelect value. With flow. Errormessage is "'triggerBody()['file']['name']' cannot be evaluated because property 'file' doesn't exist,". Done flow again and again without success. Is this related somehow to attachment control OnAddFile or Items. Selected file does not upload it when there is nothing on those fields?
Thanks!
I have not come across this issue and hence not sure what the cause for it could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
hello sir, have you purchased the power platformlicense as an individual ? bcoz, am unable to see automate in my account.
I have purchased E3 license which includes Power Automate
Great video as always Reza, and I really want to use it, but for the button actions Power App keeps telling me I am missing the contentBytes column. I have the 'file', 'contentBytes', 'name' parameters exactly as your example, but it refuses to recognize contentBytes. I have reordered contentBtyes and name and I have deleted my attachment control and add back in a new one, but nothing helps. Is there an environment configuration I need to address? Thanks in advance for any help.
I have not faced any of the above issues hence not sure.
Video description has link to download entire solution (members only - check description for details)
@@RezaDorrani Rewriting the flow from scratch solved the problem. Now I have another - my form contains request data that I will save in a Request Template doc, and my attachment control contains files to supporting the request. If I use ForAll, it fails because it tries to create the request document for every document in the attachment control. Is there a way to pass multiple files from the attachment control, and still only create one Request file?
@@glennmurphy2546 Not sure about the scenario you mentioned
Thank you Reza. One question.
Is there a way to upload more than 10MB file to SharePoint using PowerApps?
You can increase the attachment size but performance will be impacted. Power Apps is not designed to upload large files.
Thank You for this amazig video. May I find somewhere a way to change the path of a selected document ( from one folder to another ?)
I did another video long time ago on doc library explorer where I passed dynamic path to flow. Same concept I used in demo app shown in end of video.
That app is available for download (members only - check description for details)
Reza I have a need to allow users to put these files into the same library with metatags. To avoid file naming issues, I would like to rename the files on upload, so that the file ID is added to the name to make them unique. Do you have a recommendation for the most efficient way to carry this out. I have tried a few methods that I found online, but so far, I haven't had any success.
In the flow, you have the option to append guid or number combo to the file name.
The ID technique would first require file to be created, I would not recommend that.
Thank as always for such amazing resources like no "other". By chance did you or will you be providing more details on the "Document Library Experience"? (19:54 on video)
Most welcome!
Video description has link to download entire solution (members only - check description for details)
I have no plans for a follow up video on that topic
Hi Reza, What would be the recommended approach to follow, if I want to enable users to access sharepoint document folders only which they have access to. I understand that we can manage individual entity folder permissions, but that would mean breaking the parent inheritance right.
Also, there can be 20 entity folders, that would mean different permission maintenance for each folder.
There is no option other than setting folder permissions for true security
@@RezaDorrani Can these folder permissions be associated with AAD groups in some way?
@@freakinfocus I believe Yes as you can put AD groups in SharePoint groups
How would this flow change, if I want to have multiple directories inside the SharePoint Library and upload to specific folders within them?
I do not have a video reference on this scenario and would have to try it out to know the steps.
I did share a version of the app that allows loading to specific folders. Link in video description (members only - check description for details)
Hey Reza, what happens when you upload a file to the doc library that has the same name as one that already exists❓ I haven’t tested that out before. For one I don’t know how powerapps would deal with that and if it could. If it could then what would happen❓
Try and see what happens. Even I don’t know.
Reza, will you show us how to create the document library that resembles Sharepoint?
I have shared the entire code base with members. Check video description for details.
I'm able to upload the files to my SP list. However, when I change the flow to include the JSON Form properties I receive a bad gateway error message from the API. The files are uploaded, but the flow can't reach them to add the properties. Any suggestions on how to adjust this?
Video description has link to download entire solution (members only - check description for details)
I have not come experienced this and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Excellent Video as always. How can I get access to the app. I've already subscribed to your channel, checked in community tab. Not sure, which tier i belong to. Please advise.
Link is only available for silver club and above.
support.google.com/youtube/answer/6304294?hl=en&co=GENIE.Platform%3DDesktop
I see that each files are uploaded through a separate flow. Is it possible to delay each flow to make sure they don't run at the same time?
Whats the problem if they do run at the same time?
Hello Reza, I wanted to extend my gratitude for creating this insightful video. Your content consistently provides valuable learning opportunities, and I have gained considerable knowledge from watching your videos. I do have a question regarding a specific moment at 19:52 in this video. Could you kindly direct me to any related content on that topic, or did I overlook it in this video?
Thank You so much!
ruclips.net/video/TmRFAP7xTwk/видео.html
@@RezaDorranithank you for sharing this informative video. I've thoroughly watched. The only aspect I'm unsure about is how to create a folder or a file in the specific location where the end user is situated. Could you kindly provide guidance on this matter? Your assistance would be greatly appreciated.
@@CesarHernandez-fq6ds I would recommend to become a channel member and get the entire code base.
Hi Reza. Is there a way I can restrict users from directly access the files on sharepoint site and let them upload, delete files from powerapp only?
No, as Power Apps respects SharePoint security
Perhaps this is all included in this video, but I am struggling to make a connection. I have built a PowerApp to intake projects for a program of work. Each project is a single list item in a SharePoint List. When a project is created and data fields in the app are filled and patched to the SharePoint program of work, there are occasionally supporting documents to upload. I am hoping to connect documents related to a single project (one list item) to a folder for that project within a document library.
I am able to create a new folder in the appropriate location when a new project is created.
I am also able to upload a file to the document library from the project-specific screen in PowerApps.
However, when I upload a document from the project screen in PowerApps (using the method from this video), I would the document to upload to the project-specific folder within the document library.
Please advise-
Video description has details on link to download entire solution.
Your scenario should be possible.
@@RezaDorrani Wow, that was fast! Thank you and I just downloaded the solution. Your videos are far and away the best in the business and I refer to your guidance often. Thank you and I will try working through the solution. V/r
hi reza! is this also working for video files? if not, do you have another video for doing this?? thank you!!
Should work for any file type. Large file sizes wont perform.
Hi, you say all power app need is a response back from flow. Why? You do not use the text file uploeded in your power app. Must i end a flow always with respond to Power app?
If flow sends a response then power apps will wait for flow to complete and only then execute the next action.
You do not have to always end a flow with that. It depends on your scenario.
Hi Reza,
Is there a way we can get the properties of a file, and stop users from uploading them if the created does not match with modified dates, or modified date is blank?
Why would you want to do that?
Modified date cannot be blank
@@RezaDorraniSorry what I meant was the metadata of a file. I used Power Automate to get metadata of a file, but it only returns last modified date. I wish there was a way to get file created date. This way I can identify which files were modified after creation.
@@Y0urN3m3sis Get file properties action should give you created and modified both.
@@RezaDorrani Thanks for this, you are right. It gave me the Created and Modified dates. But the business requirement is different. At the point users upload the files (PDF) as attachments to SharePoint list, I need to identify from file's internal document properties if the files were modified after creation. I did some internet search on it, and it seems there's no workable solution to this.
@@Y0urN3m3sis Im not sure about whats the solution for that
Hi Reza….Highly Appreciate your effort and content. Just I am stuck with how to validate new form when we are submitting data from power automate flow
Thanks!
Form validation when submitting data from flow? Forms are filled in apps.
@@RezaDorrani Yes as in this video you have shown the implementation of attaching the file to document library along with setting its properties as well. How I can implement validation check on these properties
@@devanshijain525 Check form.valid property or simply disable submit button until validations are met. You would need to write that logic.
Hi Reza. Question: you added File Properties as the second parameter in the Flow. But then it surfaced in Power Apps as the first parameter. What's going on there?
I dont know :) but it does not make a big difference as I can see what property to set
@@RezaDorrani if there were multiple 'text' properties, it could be hard to know which one was which, if the order defined in the flow is not the order of the parameters when calling the flow.
@@lencardinal1584 I dont remember if it puts out the name of the param as well.
beautiful Reza
Thank You
Hello Reza, thank you for publishing this video. I have been waiting for this video for a long time, but I have a problem: I followed all your instructions in the video, but I could not download the file in SharePoint. What is the problem? I ask you to help me solve this problem. Thank you
Video description has link to download entire solution (check description of video for details)
I have not faced any issues with this so not sure.
Thank you very much, it works for me now. The error was that attachment does not support the list. This was my mistake. But I have another problem. When I add the JSON equation to the button, I get an error sign@@RezaDorrani
@@user-hk5ci3ij5p My response would be the same. I have not faced any issues so not sure.
Hi Reza, Thanks for this video.
But i am facing an error in the formula bar
UploadDocToSharePoint.Run({file:{name: First(attach.Attachments).Name,contentByte: First(attach.Attachments).Value}})
It says .Run has an invalid Arguments.
Could you please me on this??
Video description has link to download entire solution (members only - check description for details)
I have not come across this issue and hence not sure what is the cause for your issue.
you missed the s in contentByte(s)
Hi Reza, Its working now. I need one more help. After uploading the excel file to SP Library and onedrive. I have called all the files names in drop down list. Now when ever i select any file name in drop down, power apps will show all columns in datatable or gallery. Like a dynamic fuction to see the columns data when i select file name in drop down.
@@tarungupta6716 Not something I have tried so not sure.
I will recommend checking or posting your query on forums in case someone has experienced something similar powerusers.microsoft.com
Did this a few month ago. But not by submitting the properties as json. Your way is much more elegant...
That properties trick is not well known. Im glad to hear this video is being appreciated for that.
Great video Reza,
But I need a video in which a user uploads (multiple photos from using phone or by attaching) and also view those images below which he has uploaded or attached and then Submit the form to save those attachments.
The file upload allows image uploads and user can attach multiple.
I have done videos on showing preview of files in attachments control.
Submit form can only upload attachments to a list item not to doc library so a flow would be needed.
@@RezaDorrani got your point can you refer any video of yours? Or a playlist name?
@@mustafahussainmohsin320 I only have 15 playlists or so. Please check playlists on my channel.
I want to add text in tablu format under start and wait for an approval window. Is it possible? Ex. I have added a message (custom text for user input)column in share, i want that date into tablu format
Table format?
@@RezaDorrani yes.
@@gkvgulshan Approvals supports markdown syntax. Check approvals documentation for details.
@@RezaDorrani Thanks for your kind support.
Is there a way to patch an attachment(s) to a row in a SharePoint list rather than a document library?
Patch function does not support file uploads.
@@RezaDorrani Thank you Reza! I am trying to find a way to attach the file directly to the SharePoint list row in the attachment column so it can be called back via collection onselect of that individuals record. Whenever we think it will be easy :D
You will need to use flow for that as well
I wonder if any of you could help me please? I am getting an error when I try to do this. I am getting the file to upload without a problem but when I try to upload the metadata too, I am getting an error 502 “bad gateway” - “the server did not receive a response from an upstream server”.
Video description has link to download solution (members only - check description for details)
As for your issue, I have not come across this and hence not sure what the cause could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Thank you Reza. I found the solution, for some reason, in the compose section of the power automate - the inputs had been set with the name of the sharepoint site set before the address?!? So, this is solved and thank you for the response and your work on this video. You also have a great community here. Lovely work!
Im trying to use this same format, but by default my App doesn't upload my pdf or images to share point as pdf or image - instead it uploads it as a file or base64 code file. Do you know why this is. From your video and following your steps i see it smoothly upload to sharepoint as pdf
Video description has link to download entire solution (members only - check description for details)
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani I just solved it - so I was changing the name of the file I upload to follow a naming convention - but I still have to add .pdf or .jpeg to it for it to upload correctly
@@fundivinedoes it work for word and excel file?
I’m trying to upload a 135 mb file, and getting a 413 “payload too large” error in the app (flow never triggers). How can I account for this?
Power Apps cannot handle large files. Attachment control can accommodate max 20 MB.
Actually, we see it handling up to 70 mb.
I’ve come up with a pretty slick workaround though.
@@dmvogan Great
how to add all the attachments from share point list to pdf file in power apps(not considering the id)
I do not have a video reference on this one and have not come across this scenario so not sure
When clicking upload, i get the following error:
"Uploadfilesharepoint.Run failed: {"error": {"code": "TriggerInputSchemaMismatch", "message": "The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Invalid type. Expected String but got Null.'."}}.
I have not come across this and hence not sure what is the cause for your issue.
Video description has link to download entire solution (members only - check description for details)
I would also recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar
Hello Dorrani,
Thank you for your videos, they have really helped me a lot.
I need your help with a project on SharePoint library. If possible please, can you kindly do a video on how to automatically display all libraries in a SharePoint site in PowerApps. Maybe with the use of gallery or any other means. Also how to create a library into a SharePoint site using PowerApps.
My rule for video requests is set. I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
@@RezaDorraniUnderstood. I really appreciate your reply.
But is my request technically possible?
@@GraceJoe-hi5zm Possible with assistance from power automate
Thanks a lot Dorrani. I really appreciate your response. I already thought I won't ge a response again. Thanks a lot.
I am already tryin to use Power Automate.
I was able to create a library with the help of "Send an HTTP request to SharePoint" but tring to use Power Automate to delete library became a problem. ETag problem to be precise. Power Automate said I need to provide the ETag of the Library before I can delete the Library.
I used the GET Method of the "Send an HTTP request to SharePoint" to check for the ETag of each Library present in my SharePoint site and I was able to delete the Libraries inputting the ETags manually.
But making it dynamic has become a problem. I tried using the "Initialize variable" and "Parse Json" to fetch the ETag from the GET Method of the "Send an HTTP request to SharePoint" so that I can dynamically use it in the DELETE Method of the "Send an HTTP request to SharePoint" but it wont just work. Output('Send an HTTP request to SharePoint')['Headers']['Etag'] is not working for the fetch expression.
I will be glad to get enlightened
@@GraceJoe-hi5zm I would have to try this to know about it. I will recommend checking or posting your query on forums in case someone has experienced something similar powerusers.microsoft.com
When I start typing the "attach. Attachments" why doesn't intellisense pick that up? It just errors out
No clue about it as I have not experienced this.
Will this method work while offline(Once online again it will upload)?
SharePoint offline is not supported in Power Apps
Do I need to use the older method of base 64 to upload pictures offline?@@RezaDorrani
@@RezaDorrani To accomplish this would I need to convert the image to base 64?
@@tylerdegrand3034 I am not aware of how to do it with SharePoint
where we found "issue tracker" 2:16?
I mentioned in video that you can use an SP list of your choice.
Issue tracker is list that I have.
I built the exact flow step by step, and I just kept getting errors whenever I added the form in order to update just 1 column in the library. I repeated the video for 2 hours and could not figure it out. I'm this is great idea, maybe this is just too far over my head.
Many have got this to work in one go :)
Video description has link to download entire solution (for channel members only, check description for details)
Great Tool, I followed along but my folders aren’t visible.
I have provided entire app for download (check video description for details)
It has step by step guidance
How to create new folder for uploaded attachments?
Flow has a create folder action.
how to add all the attachments to pdf file in power apps
Not sure about this
Hi, I want to create a workflow.
1.HR will send a approval for user ID and password.
2. Manager will approve the same.
3. IT dept. Will create a new user I'd and password.
4. User id and password automatically send to the user
Is it possible? Please advise.
Possible - Yes
But I have not tried this or have any references on it.
May be check on forums in case someone has done something similar
powerusers.microsoft.com
@@RezaDorrani it would be appropriatble if you make a tutorial on this, thanks in advance
@@gkvgulshan I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
What is wrong??? it seems like every video I load plays an ad and then stops, the video never plays. I've cleared my cache. I don't get it.
That sounds more like a RUclips problem. Not something I have ever come across.
USELESS
Ok
Hello, Thank you for the nice Tutorial! I have one problem: the JSON(Form.Updates, JSONFormat.IncludeBinaryData) for the Upload Button gives me an Error and says there is an unknown value for converting to JSON. One of the questions in my form is a people picker, which uses the office365 data. In the error message it lists all of the picked persons data and says its an unexpected type and expected would be „!“. Do you have any idea how I can fix this? I put „JSONFormat.IgnoreUnsupportedTypes“ in the content language of the form and Data card but it didnt help. Would be great if you could somehow help me out!
Mine also includes a people picker.
I have not come across this issue and hence not sure what the cause could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorraniany ideas on something I could try out? How can I change the output of the people picker datacard?
@@Nico-xp1vk no idea
Is there a way to make the file metadata or properties required from within the form. Say we wanted a minimum of 2 tags for a file, can we enforce that through the form? In SharePoint itself it doesn't allow for strictly enforcing metadata, so I was hoping we could enforce it through an input form like this.
You could make them required fields on the form