Hi Reza! I would automatically look in your channel for things I'd need to learn/do. Again, I found what I needed. You've made the video so easy to understand and follow. Thank you so much for sharing your knowledge!
I'm a relative newbie to Power Apps. I had to watch the video three or four times to understand. Over the course of a few days, I created a Word document that went through the whole thing step by step. Thirty odd pages later, I almost understand it. I greatly appreciate the detail you've included in this, and will be trying this shortly.
@@RezaDorrani I really like your videos, and I think you've improved their quality as time has gone on. I'm an old analog guy, and I miss the Microsoft "Step-by-Step" series books.
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 !
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. :)
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
Great video! Thank you! I can't seem to get the "Description" property to update to show in the SharePoint Library. The title and date saves but not that one field. It is open text. Any ideas?
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.
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😊
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.
Great tutorial Reza - thankyou! I laready had a filter on my gallery so in order to refresh I used the Refresh() function to refresh the data source on the OnSelect of the icon. Apart form that - works great, THANKYOU!
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.
Hi Reza, Thanks for sharing your knowledge & this video, however I am getting an error at 8:50 mins. The place where you completed the formula for PowerTrigger to Upload the photos. The message is : Missing Column, your formula is missing a column 'contentBytes' with a type of 'Blob'. How can we overcome this error ? Also I observed in my setup for the Power Automate Flow, The ID for File Name (for this upload feature) was also generated alongwith File Content. No need to Copy& Paste in the expression as shared in 6:18mins. I am not sure if the Blob error has anything to do with my PowerApps settings. Please advise. Thanks.
Video description has link to download entire solution (members only - check description for details) I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani Thanks Reza for your prompt response. I would have readily downloaded the entire solution unfortunately I am worried it will not work on my PC due to this bug/error. I tried to reach out on Powerusers forum and it looks like some users also face similar challenges but no concrete solution. I am trying to create a flow wherein the PowerApps data including Attachments will be transferred to MS List via flow and trigger an approval process. Is there any other way of extracting the Attachments data (content) and link to the MS list e.g. Get File content, Apply to attachments etc. Can approvers put attachments during approval which will get reflected in the MS list ? Please advise. Again Thanks for your advice & wonderful work ! Hope you can help me resolve this issue.
@@RezaDorrani Thanks Reza. I have taken an alternate way of just sending the attachments to the approvers for approval and not loading the docs. in Sharepoint List. This though not the perfect solution still works for me. Appreciate your help and will continue to follow your videos !
@@RezaDorrani Are you able to access a document's version history from a Power Apps gallery? Never mind! I found it in one of your other videos -- ua-cam.com/video/X-hFMMKuPsM/v-deo.html Works great!
Hi Joe, I see you may have posted a link to this comment post. Probably that comment got deleted as I have setup to block comments with links on my channel. I wanted to let you know about it.
13:04 What if I want the user to be able to add the metadata immediately upon uploading the document? Without going back to the gallery, is there any way to pull the most recent id used (the document I just uploaded)?
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.
@@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.
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.
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.
Hi Rezza, I just looked that you have used dynamic behavior at 16:30 for the item property using the json formula. Since you have done this under the 'Update File Properties' action, I want to do this under 'Create Item' action where my list name will be dynamic. Now I don't know what to do with the item property there. PLZ HELP
It should be possible but not something I have tried or have a video reference for. I would suggest checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
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?
@@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.
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?
@@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!
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.
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
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
Awesome content Reza as always! I have a similar requirement but I want to add a toggle. If toggle is on, save the file on this SP folder, if toggle is off, save the file on the other SP folder. Sounds simple but not sure how to add it. Appreciate your guidance. Thank you! :)
Most welcome! Sounds like a great requirement, but something I would have to try out to know the steps. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
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 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).
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)
@@zhisonghuo 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.
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?
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?
@@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});
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?
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...
I want to have the file upload on the same page as the gallery so I have to give the button the additional functions that it 1. resets the attach window and 2. reloads or also resets the gallery but if I say for example: "UploadPrueflinge.Run({file:{name: First(attach.Attachments).Name;contentBytes: First(attach.Attachments).Value}}); Reset(attach)" PowerApps tells me that I am not allowed to use the semicolon before the reset, why and what do I have to change? Edit: Found a Solution just had to do multiple semicolons and refresh the whole data source UploadPrüflinge.Run({file:{name: First(attach.Attachments).Name;contentBytes: First(attach.Attachments).Value}});; Reset(attach);; Refresh(Prüflingslisten)
@@RezaDorrani I just got the reason explained, it is so if you use PowerApps with a German Microsoft account, then signs are changed in the PowerApps programming: , = ; ; = ;;
Hello @Reza, Thankyou for your valuable content, could you please let us know, when we store the multiple files for a record from powerapps form, how can we add the links to those files in the same record file link column for the record at data source? Thanks in advance.
This is not something I have tried or have a video reference for. I would suggest posting this as a topic suggestion whenever the next topic request voting option opens up on community tab of my channel.
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!
Hi Reza! you're the one bro! Could you please send me the link to the next step video: Full document library experience in PowerApps / i need to build an app with the tools shown in the end of this demo. appreciated a lot your help!
Very helpful Thank you so mush for sharing, If we want to do for many libraries and Apps, Can we use same Flow with Sharepoint site and library name as variable ? How ask site adress to PowerApps?
Thanks! Not sure if thats an option. I don’t have a video reference on it. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
I did a video on that long back. Performance will be a big concern, as passing data of multiple files to a single flow would require transit of a lot of data to flow.
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
Hey Reza, thanks for the trick on leveraging the 'Update File Properties' for dynamic mapping - If I am still interesting of catching a specific property collected through the form (for naming/placing in a specific folder), how can I achieve this while still using the dynamic mapping?
I would have to try it out to know how to achieve that. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
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)
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
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?
Hello Rezza, very well explained. Had query with what is the max recommended file size we can upload through power app. It will helpful if cover a vedio for uploading large file to SharePoint.
@@RezaDorrani thank you for replying. However I tried and was able to upload file size with 70MB. Not sure if there is any way we can handle large files.
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!
In your last example of connecting modern table to document library i see the sorting option is only available for few columns like Title, Created and so on. For file name with extension why is your sorting icon not showing?
@@RezaDorrani oh ok. Thank you. One observation made here is that sorting is now enabled on all columns but gives an error on File name with extension and Title column for a document library. Do you have any idea? Or any work around.
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. 👍
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❓
Thanks for the video, very useful content! Question- Is it possible to create multiple order list with attachments using Sharepoint & Powerapps bypassing PowerAutomate?
I want to upload multiple files without using ForAll in the Power app that I can execute in Power Automate. Because I have a lot of files and I want to upload them at the same time
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.
Hi Raza, thanks for the upload this is amazing. For some reason though, when I upload multiple attachments, the flow just uploads the same first attachment selected 5 times and not the seperate files selected. Any ideas?
Video description has link to download entire solution (members only - check description for details) I would suggest giving that a try. As for the issue mentioned, I have not experienced it and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi Reza, great Video as always. Your Videos are helping so much thanks for all the content! I have 1 question. I want to do it like this: Upload a file in PowerApps. Then the possibility to click on a button. If clicked a work flow will be triggered that checks if the uploaded file in PowerApps already exists in Sharepoint. If yes it will overwrite the old one. If it doesnt exist in Sharepoint the user should get an error message, that the uploaded file doesnt exist in SharePoint. You have an idea how to do so?
@@RezaDorrani Trying it with trying to get the name of the uploaded file and then look it up on SP. How exactly would you do it with the lookup function?
@@HakDyr61 I would have to try it out to share the exact steps. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
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.
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
Hi Reza, is there any reason you can think of as to why the Attachment control would not appear in the published app? I can see it in the Studio, Visible is set to True and Display mode is set to Edit but in the app it just doesn't appear. Everything else in the same container displays with no issues including the New Form for setting properties.
@@RezaDorrani I figured it out eventually, I had the width of the attachment control set to a formula based on the width of the form, and because the parent container (and therefore the form) was only visible on a certain condition PowerApps didn't make the attachment control visible until the form had been edited. I changed the Attachment control to calculate width a different way and it now works. Thank you for the great tutorial.
Hi Reza, The code for OnSelect for the Upload Button for ALL ATTACHMENTS only works on the Old Edit Form. I tried the code on New Form on Modern Control - but it did not work. It gave me an error while uploading the file. Also, if you have to go back to the Home Screen after upload on Canvas App - Back() on DisplayMode property doesn't work... what would be the back command to go back to Home Screen on Canvas app please?
Video description has link to download entire solution (silver and gold members only) I have not faced the mentioned issue hence not sure of what steps to propose.
Reza, the first time I followed your video, it worked. Now, trying to build a new upload form, I keep getting a 502 (Bad Gateway) error. Unable to process template language expressions in action 'Create_file' inputs at line '0' and column '0': 'The template language expression 'triggerBody()['file']['name']' cannot be evaluated because property 'file' cannot be selected. Any ideas?
@@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
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 you Reza! I'm sure it's user error but I've followed every step in the tutorial and I'm still getting an error on the Upload OnSelect button UploadtoSharePointfromPA.Run({file:{name: First(attach.Attachments).Name,contentBytes: First(attach.Attachments).Value}}). The error says invalid argument type (Record.) Expecting a Text value instead. Any ideas?
Video description has link to download entire solution (members only - check description for details) I would suggest giving that a try. As for the issue mentioned, I have not experienced it and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@sistex3729 Video description has link to download entire solution (members only - check description for details) I would suggest giving that a try. As for the issue mentioned, I have not experienced it and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi this helped me a lot however if my colleagues do upload the app, it says they don't have permissions for the connection flow. How am I able to like all users an access to that?
@@RezaDorrani Already figured it out, just needs to give them access to the flow.Thanks Man, this helped me. Also can you make a video about Power Automate flow sending notification to users based on my UserID column and references to user profile that gets their email address then send an email notification when new task is assigned to them.
I am facing an issue when using the same formula. I am creating the file on OneDrive instead of Sharepoint. The error says that the result of First(attach.Attachments).Value is a String where as my Power Automate flow expects a blob type input.
Video description has link to download entire solution (members only - check description for details) I would suggest giving that a try. As for the issue mentioned, I have not experienced it and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
hi! this video is very useful and helped me find a workaround for filling a word template. Is this possible to be achieved with an item that was already created? I tried but it does not work
Is there any documentation on file size limit for powerapps. In recent update MS mentioned they have removed the 50mb attachment size limit. But have not mentioned what is the new limit. On testing it looks like files size upto 70mb gets uploaded. Do you have any idea on this? And how can we upload large files in sharepoint from powerapps
Reza, I'm trying to update properties where one library's column is a lookup from another SP List. Into PowerApp, I select data with combox box, but when I save attach file, I get error Unexpected value when converting to JSON format "XXXXX" (Expected type "!") Any idea ?
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Great one Reza Thank you ❤
Thanks so much
Hi Reza! I would automatically look in your channel for things I'd need to learn/do. Again, I found what I needed. You've made the video so easy to understand and follow. Thank you so much for sharing your knowledge!
So happy to hear the feedback.
And Thanks so much for appreciating the content.
I'm a relative newbie to Power Apps. I had to watch the video three or four times to understand. Over the course of a few days, I created a Word document that went through the whole thing step by step. Thirty odd pages later, I almost understand it. I greatly appreciate the detail you've included in this, and will be trying this shortly.
Awesome!!!
Im super happy to hear that you did not give up and got it to work
@@RezaDorrani I really like your videos, and I think you've improved their quality as time has gone on. I'm an old analog guy, and I miss the Microsoft "Step-by-Step" series books.
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
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
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
Great video! Thank you! I can't seem to get the "Description" property to update to show in the SharePoint Library. The title and date saves but not that one field. It is open text. Any ideas?
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.
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!
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.
Reza - as always, great content. You are truly the PowerApps (and SharePoint) Jedi Master! Thanks for publishing, sharing and educating!
Thanks so much Manny
Great tutorial Reza - thankyou! I laready had a filter on my gallery so in order to refresh I used the Refresh() function to refresh the data source on the OnSelect of the icon. Apart form that - works great, THANKYOU!
Most welcome
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
Wow this is brilliant, Thanks Raza ! you are fab !
Thanks for liking
Hi Reza, Thanks for sharing your knowledge & this video, however I am getting an error at 8:50 mins. The place where you completed the formula for PowerTrigger to Upload the photos. The message is : Missing Column, your formula is missing a column 'contentBytes' with a type of 'Blob'. How can we overcome this error ? Also I observed in my setup for the Power Automate Flow, The ID for File Name (for this upload feature) was also generated alongwith File Content. No need to Copy& Paste in the expression as shared in 6:18mins. I am not sure if the Blob error has anything to do with my PowerApps settings. Please advise. Thanks.
Video description has link to download entire solution (members only - check description for details)
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani Thanks Reza for your prompt response. I would have readily downloaded the entire solution unfortunately I am worried it will not work on my PC due to this bug/error. I tried to reach out on Powerusers forum and it looks like some users also face similar challenges but no concrete solution. I am trying to create a flow wherein the PowerApps data including Attachments will be transferred to MS List via flow and trigger an approval process. Is there any other way of extracting the Attachments data (content) and link to the MS list e.g. Get File content, Apply to attachments etc. Can approvers put attachments during approval which will get reflected in the MS list ? Please advise. Again Thanks for your advice & wonderful work ! Hope you can help me resolve this issue.
@@alfreddethe2567 I have not faced any issues with what is demonstrated in video.
And this video is the best reference I have.
@@RezaDorrani Thanks Reza. I have taken an alternate way of just sending the attachments to the approvers for approval and not loading the docs. in Sharepoint List. This though not the perfect solution still works for me. Appreciate your help and will continue to follow your videos !
This is fascinating and worked like a charm. Thanks, Reza!
Most welcome
@@RezaDorrani Are you able to access a document's version history from a Power Apps gallery?
Never mind! I found it in one of your other videos -- ua-cam.com/video/X-hFMMKuPsM/v-deo.html
Works great!
Hi Joe, I see you may have posted a link to this comment post. Probably that comment got deleted as I have setup to block comments with links on my channel. I wanted to let you know about it.
This solution works perfectly 9 mo later. Thank you very much for sharing this.
Glad it helped
13:04 What if I want the user to be able to add the metadata immediately upon uploading the document? Without going back to the gallery, is there any way to pull the most recent id used (the document I just uploaded)?
When flow creates the doc, it will have the ID info in dynamic content. You could use that.
@@RezaDorrani Cool! how?
@@joepark8872 Im only guiding here. I don’t have a specific video reference on it.
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)
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
It seems it is what exactly I looking for. Many thanks.
Most welcome!
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.
ua-cam.com/video/F-QmdLLF7CE/v-deo.html
Hi Rezza,
I just looked that you have used dynamic behavior at 16:30 for the item property using the json formula.
Since you have done this under the 'Update File Properties' action, I want to do this under 'Create Item' action where my list name will be dynamic. Now I don't know what to do with the item property there. PLZ HELP
It should be possible but not something I have tried or have a video reference for.
I would suggest checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
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 :)
Your videos are really helpful and i am gaining a lot from your videos
Glad you like them!
Thank you Reza for sharing your knowledge and ideas.
My pleasure!
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
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!
ua-cam.com/video/TmRFAP7xTwk/v-deo.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.
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!
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.
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! 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
Amazing stuff. Thank you so much!
Most welcome
Awesome content Reza as always! I have a similar requirement but I want to add a toggle. If toggle is on, save the file on this SP folder, if toggle is off, save the file on the other SP folder. Sounds simple but not sure how to add it. Appreciate your guidance. Thank you! :)
Most welcome!
Sounds like a great requirement, but something I would have to try out to know the steps. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Great! Really helpful 😍
Most welcome
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
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)
Wonderful tutorial. Just like all your videos.
Thanks Darren
Great Video Reza
Thanks
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).
ua-cam.com/video/TmRFAP7xTwk/v-deo.html
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)
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.
@@zhisonghuo 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!
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.
Very smart method. Thank you. I was looking for how to upload files.
You are most welcome
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});
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
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.
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.
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
I want to have the file upload on the same page as the gallery so I have to give the button the additional functions that it 1. resets the attach window and 2. reloads or also resets the gallery but if I say for example:
"UploadPrueflinge.Run({file:{name: First(attach.Attachments).Name;contentBytes: First(attach.Attachments).Value}}); Reset(attach)"
PowerApps tells me that I am not allowed to use the semicolon before the reset, why and what do I have to change?
Edit: Found a Solution just had to do multiple semicolons and refresh the whole data source
UploadPrüflinge.Run({file:{name: First(attach.Attachments).Name;contentBytes: First(attach.Attachments).Value}});;
Reset(attach);;
Refresh(Prüflingslisten)
Interesting scenario
@@RezaDorrani I just got the reason explained, it is so if you use PowerApps with a German Microsoft account, then signs are changed in the PowerApps programming:
, = ;
; = ;;
Hello @Reza, Thankyou for your valuable content, could you please let us know, when we store the multiple files for a record from powerapps form, how can we add the links to those files in the same record file link column for the record at data source? Thanks in advance.
This is not something I have tried or have a video reference for. I would suggest posting this as a topic suggestion whenever the next topic request voting option opens up on community tab of my channel.
Just wow ! another great vid. Thanks !!
Most welcome
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! you're the one bro! Could you please send me the link to the next step video: Full document library experience in PowerApps / i need to build an app with the tools shown in the end of this demo. appreciated a lot your help!
I don't think I did a next step video.
You can try downloading the entire solution shown in video (members only - check video description for details)
Very helpful Thank you so mush for sharing, If we want to do for many libraries and Apps, Can we use same Flow with Sharepoint site and library name as variable ? How ask site adress to PowerApps?
Thanks!
Not sure if thats an option. I don’t have a video reference on it.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, as always, great content. Is there any other way to replace the existing document in the library from PowerApps?
I'm not aware of other ways to do that
thanks for the guide on this, is there a way to upload multiple files without causing the flow to run once per file?
I did a video on that long back. Performance will be a big concern, as passing data of multiple files to a single flow would require transit of a lot of data to flow.
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
Hey Reza, thanks for the trick on leveraging the 'Update File Properties' for dynamic mapping - If I am still interesting of catching a specific property collected through the form (for naming/placing in a specific folder), how can I achieve this while still using the dynamic mapping?
I would have to try it out to know how to achieve that.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
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
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)
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.
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?
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)
This is really timely,
Thanks @Reza
Most welcome
excellent video Reza, regards.
Welcome
Great! How to upload the file in a specific folder if the path is stored in a variable. How to pass the parameter?
I do not have a video reference on that.
Can we filter on the library and show files from specific subfolders (ex: Mylibrary/subfolder/) without running into a delegation problem?
Possible! Thats the demo I show in end of video.
Hello Rezza, very well explained. Had query with what is the max recommended file size we can upload through power app. It will helpful if cover a vedio for uploading large file to SharePoint.
I believe not more than 20MB.
@@RezaDorrani thank you for replying. However I tried and was able to upload file size with 70MB. Not sure if there is any way we can handle large files.
@@sunilsahu831 It wont be a guarantee each time. Try it out on a mobile device with limited bandwidth.
@@RezaDorrani make sense.
Is it possible to upload an image/s to a sharepoint column using a patch function?
Image type column - then yes
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!
In your last example of connecting modern table to document library i see the sorting option is only available for few columns like Title, Created and so on. For file name with extension why is your sorting icon not showing?
Modern table control is in preview. It did not support sort all column types back when this video was made.
@@RezaDorrani oh ok. Thank you. One observation made here is that sorting is now enabled on all columns but gives an error on File name with extension and Title column for a document library. Do you have any idea? Or any work around.
@@joywindsouza817 Its probably because it runs into limits off delegation or something. Im not sure why.
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.
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.
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
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.
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.
I want to upload multiple files without using ForAll in the Power app that I can execute in Power Automate. Because I have a lot of files and I want to upload them at the same time
You could try sending an array of files over but there would be a performance impact in that case. I don't remember doing a video on this scenario
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
Hi Raza, thanks for the upload this is amazing. For some reason though, when I upload multiple attachments, the flow just uploads the same first attachment selected 5 times and not the seperate files selected. Any ideas?
Video description has link to download entire solution (members only - check description for details)
I would suggest giving that a try.
As for the issue mentioned, I have not experienced it and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi Reza, great Video as always. Your Videos are helping so much thanks for all the content! I have 1 question. I want to do it like this: Upload a file in PowerApps. Then the possibility to click on a button. If clicked a work flow will be triggered that checks if the uploaded file in PowerApps already exists in Sharepoint. If yes it will overwrite the old one. If it doesnt exist in Sharepoint the user should get an error message, that the uploaded file doesnt exist in SharePoint. You have an idea how to do so?
Not something I have tried but idea would be to use lookup function to check if file with same name already exists and accordingly take action.
@@RezaDorrani Trying it with trying to get the name of the uploaded file and then look it up on SP. How exactly would you do it with the lookup function?
@@HakDyr61 I would have to try it out to share the exact steps. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reze - great video. Do you have an easy way of adding document tagging to this via a button and drop down? Thabjs
I show in video how to do this. I'm not sure what other easy ways are there.
@@RezaDorrani do you have the download file for this? Thanks
@@paulmcnally4994 Yes, for members (details in description)
Hi Reza, this is super cool! Can you share the download link for the file again please? Thank you in advance!
I cannot share download links here on public chat. Please post a message on any download link post shared in membership tab of the channel.
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
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, is there any reason you can think of as to why the Attachment control would not appear in the published app? I can see it in the Studio, Visible is set to True and Display mode is set to Edit but in the app it just doesn't appear. Everything else in the same container displays with no issues including the New Form for setting properties.
I cannot think of any reasons as to why that would happen
@@RezaDorrani I figured it out eventually, I had the width of the attachment control set to a formula based on the width of the form, and because the parent container (and therefore the form) was only visible on a certain condition PowerApps didn't make the attachment control visible until the form had been edited. I changed the Attachment control to calculate width a different way and it now works. Thank you for the great tutorial.
Hi Reza,
The code for OnSelect for the Upload Button for ALL ATTACHMENTS only works on the Old Edit Form.
I tried the code on New Form on Modern Control - but it did not work. It gave me an error while uploading the file.
Also, if you have to go back to the Home Screen after upload on Canvas App - Back() on DisplayMode property doesn't work... what would be the back command to go back to Home Screen on Canvas app please?
Video description has link to download entire solution (silver and gold members only)
I have not faced the mentioned issue hence not sure of what steps to propose.
@@RezaDorrani Thanks Reza. Any comment on Back() not working on Canvas Apps?
I have not experienced any issues with Back function either.
@@RezaDorrani Thank you.
Thank you!
Welcome!
Reza, the first time I followed your video, it worked. Now, trying to build a new upload form, I keep getting a 502 (Bad Gateway) error.
Unable to process template language expressions in action 'Create_file' inputs at line '0' and column '0': 'The template language expression 'triggerBody()['file']['name']' cannot be evaluated because property 'file' cannot be selected.
Any ideas?
Im not sure if anything has changed since.
@ I’m stumped. I’ve tried deleting the flow and starting over with no luck. I’m not sure what I am missing.
I would suggest posting your issue on forums at powerusers.microsoft.com/
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.
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 you Reza! I'm sure it's user error but I've followed every step in the tutorial and I'm still getting an error on the Upload OnSelect button UploadtoSharePointfromPA.Run({file:{name: First(attach.Attachments).Name,contentBytes: First(attach.Attachments).Value}}). The error says invalid argument type (Record.) Expecting a Text value instead. Any ideas?
Video description has link to download entire solution (members only - check description for details)
I would suggest giving that a try.
As for the issue mentioned, I have not experienced it and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Were you able to resolve this?
@@sistex3729 Video description has link to download entire solution (members only - check description for details)
I would suggest giving that a try.
As for the issue mentioned, I have not experienced it and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi this helped me a lot however if my colleagues do upload the app, it says they don't have permissions for the connection flow. How am I able to like all users an access to that?
Have not had anyone report this issue. Not sure what is the issue is related to.
@@RezaDorrani Already figured it out, just needs to give them access to the flow.Thanks Man, this helped me. Also can you make a video about Power Automate flow sending notification to users based on my UserID column and references to user profile that gets their email address then send an email notification when new task is assigned to them.
@DjOyda-i9u Glad it worked. I have that video idea in my backlog, just that I have had too few requests so far.
I am facing an issue when using the same formula. I am creating the file on OneDrive instead of Sharepoint. The error says that the result of First(attach.Attachments).Value is a String where as my Power Automate flow expects a blob type input.
Video description has link to download entire solution (members only - check description for details)
I would suggest giving that a try.
As for the issue mentioned, I have not experienced it and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Great Job Reza. Is there anyway i can get the link to download this ?
Link is in community tab of my channel for members in gold or silver club
hi! this video is very useful and helped me find a workaround for filling a word template. Is this possible to be achieved with an item that was already created? I tried but it does not work
This video is on file upload. I did not understand the question
As always, Thanks a lot.👌👌🤗🤗
Most welcome
Is there any documentation on file size limit for powerapps. In recent update MS mentioned they have removed the 50mb attachment size limit. But have not mentioned what is the new limit. On testing it looks like files size upto 70mb gets uploaded. Do you have any idea on this? And how can we upload large files in sharepoint from powerapps
The documented info is the only limit Im aware of. I was not aware of doc being updated.
In the release notes of the powerapps version it is mentioned
@@joywindsouza817 Ok. I did not read that.
Great video, thank you Reza!
Welcome Saulo
Great video. How do I add an image to sharepoint document library please?
Any type of file can be uploaded by this method
Reza, I'm trying to update properties where one library's column is a lookup from another SP List. Into PowerApp, I select data with combox box, but when I save attach file, I get error Unexpected value when converting to JSON format "XXXXX" (Expected type "!") Any idea ?
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com