Great one Reza Thank you ❤

@RezaDorrani

3 ай бұрын

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 !

@RezaDorrani

3 ай бұрын

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

@RezaDorrani

3 ай бұрын

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

Thank you Reza for sharing your knowledge and ideas.

@RezaDorrani

5 күн бұрын

My pleasure!

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. :)

@RezaDorrani

3 ай бұрын

Glad to hear that

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😊

@RezaDorrani

3 ай бұрын

You are 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.

@RezaDorrani

3 ай бұрын

Awesome! Thanks so much

Wonderful tutorial. Just like all your videos.

@RezaDorrani

Ай бұрын

Thanks Darren

Your videos are really helpful and i am gaining a lot from your videos

@RezaDorrani

Ай бұрын

Glad you like them!

Just wow ! another great vid. Thanks !!

@RezaDorrani

3 ай бұрын

Most welcome

Very smart method. Thank you. I was looking for how to upload files.

@RezaDorrani

3 ай бұрын

You are most welcome

Great video, thank you Reza!

@RezaDorrani

3 ай бұрын

Welcome Saulo

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!

@RezaDorrani

3 ай бұрын

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.

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.

@RezaDorrani

Ай бұрын

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.

@RezaDorrani

3 ай бұрын

Oh wow a year now! Comeback Carl :)

@carlw

3 ай бұрын

​@@RezaDorrani 😃 Hope to this or next month

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.

As always, Thanks a lot.👌👌🤗🤗

@RezaDorrani

3 ай бұрын

Most welcome

Thank you Reza, your excellent video will increase my Power Apps skill very fast. Thanks again.

@RezaDorrani

3 ай бұрын

Glad to hear that

@zhisonghuo

3 ай бұрын

@@RezaDorrani I've followed your video to build the upload functions. Could you elaborate a bit more on the 'FormInvoice.Updates' aspect? Thanks.

@RezaDorrani

3 ай бұрын

@@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.

@zhisonghuo

3 ай бұрын

@@RezaDorrani Thank you Reza!

Great, helpfull , Thanks

@RezaDorrani

3 ай бұрын

Glad it was helpful!

excellent video Reza, regards.

@RezaDorrani

3 ай бұрын

Welcome

This is really timely, Thanks @Reza

@RezaDorrani

3 ай бұрын

Most welcome

Thank you Reza 😊😊

@RezaDorrani

3 ай бұрын

Most welcome

@Sreekanth297

3 ай бұрын

@@RezaDorrani The task has been completed thank you so much for your help on this video

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?

@RezaDorrani

Ай бұрын

Folders would need to be done via power automate.

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!

@RezaDorrani

3 ай бұрын

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.

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!

@RezaDorrani

3 ай бұрын

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)

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?

@RezaDorrani

Ай бұрын

I have done videos on sorting and filtering for lists. Similar logic will apply here.

Thanks for the video, very useful content! Question- Is it possible to create multiple order list with attachments using Sharepoint & Powerapps bypassing PowerAutomate?

@RezaDorrani

Ай бұрын

I am not sure about the possibilities. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

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.

@RezaDorrani

2 ай бұрын

Yes it could

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).

@RezaDorrani

3 ай бұрын

kzread.info/dash/bejne/hqGGqKOJZ9u6p84.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?

@RezaDorrani

3 ай бұрын

Refresh - refreshes the connection and reloads all the data Reload technique shown in video - only loads the updates (caching)

Nice video Reza 😊 why don't use a timer control to reload the gallery after the upload ? 🤔

@RezaDorrani

3 ай бұрын

Because I am not a fan of timer control :)

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

@RezaDorrani

3 ай бұрын

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)

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.

@RezaDorrani

14 күн бұрын

Link to download is in community tab of channel. You will need to check the posts there.

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!

@RezaDorrani

2 ай бұрын

I did not understand the question.

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

Ай бұрын

File with same name will be overwritten. Not sure if it handles versioning. May be best to rename files so they have unique names.

@moeking5601

Ай бұрын

@@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});

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?

@RezaDorrani

5 күн бұрын

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

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)

@RezaDorrani

Ай бұрын

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

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?

@RezaDorrani

3 күн бұрын

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

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

3 ай бұрын

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)

@isaiaguillon9878

2 ай бұрын

@@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!

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 ?)

@RezaDorrani

2 ай бұрын

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, 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

@RezaDorrani

3 ай бұрын

I have done no work with FTP connector hence not sure

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...

@RezaDorrani

Ай бұрын

You can always append a timestamp or a guid to document name using expressions in power automate

@julienvdc

Ай бұрын

@@RezaDorrani yessss thanks

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

@RezaDorrani

3 ай бұрын

I dont think we have those options

beautiful Reza

@RezaDorrani

3 ай бұрын

Thank You

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❤️

@RezaDorrani

3 ай бұрын

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.

@uzairfarooq4622

3 ай бұрын

@@RezaDorrani Can I get the information how to enroll in that course which is being ran live?

@RezaDorrani

3 ай бұрын

@@uzairfarooq4622 On web browser (on desktop), open my channel and click on JOIN button. kzread.info/dash/bejne/eGGFz8aFfKmdc6g.html

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

@RezaDorrani

3 ай бұрын

I’m not sure what the reason is or if it is a planned feature in the roadmap

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. 👍

@RezaDorrani

3 ай бұрын

Thanks Spen! Patch function to upload file to a doc library? Is that possible?

@spen2431

3 ай бұрын

@@RezaDorrani Ahh.. seems I really must try to do 1 thing at a time.. LOL.

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?

@RezaDorrani

3 ай бұрын

Thanks! I have not done any work with url type column hence not sure.

@user-uf5nc4jc1r

3 ай бұрын

No worries, thanks for the swift response@@RezaDorrani

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

2 ай бұрын

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.

@isaiahmore

Ай бұрын

@@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.

@RezaDorrani

Ай бұрын

@@isaiahmore Video description has link to download entire solution (members only- check description for details)

Thank you Reza. One question. Is there a way to upload more than 10MB file to SharePoint using PowerApps?

@RezaDorrani

3 ай бұрын

You can increase the attachment size but performance will be impacted. Power Apps is not designed to upload large files.

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.

@RezaDorrani

3 ай бұрын

Link is only available for silver club and above. support.google.com/youtube/answer/6304294?hl=en&co=GENIE.Platform%3DDesktop

Reza, will you show us how to create the document library that resembles Sharepoint?

@RezaDorrani

2 ай бұрын

I have shared the entire code base with members. Check video description for details.

How would this flow change, if I want to have multiple directories inside the SharePoint Library and upload to specific folders within them?

@RezaDorrani

2 ай бұрын

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)

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.

@RezaDorrani

3 ай бұрын

There is no option other than setting folder permissions for true security

@freakinfocus

3 ай бұрын

@@RezaDorrani Can these folder permissions be associated with AAD groups in some way?

@RezaDorrani

3 ай бұрын

@@freakinfocus I believe Yes as you can put AD groups in SharePoint groups

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.

@RezaDorrani

3 ай бұрын

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.

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

@RezaDorrani

2 ай бұрын

Thanks! Form validation when submitting data from flow? Forms are filled in apps.

@devanshijain525

2 ай бұрын

@@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

@RezaDorrani

2 ай бұрын

@@devanshijain525 Check form.valid property or simply disable submit button until validations are met. You would need to write that logic.

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?

@RezaDorrani

2 ай бұрын

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.

@RezaDorrani

3 ай бұрын

I have purchased E3 license which includes Power Automate

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?

@RezaDorrani

2 ай бұрын

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

@alexbury

2 ай бұрын

@@RezaDorrani Appreciate the reply.

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!

@RezaDorrani

3 ай бұрын

The solution is designed to trigger multiple flows. I did not have an email process in my flow to send notification.

hi reza! is this also working for video files? if not, do you have another video for doing this?? thank you!!

@RezaDorrani

2 ай бұрын

Should work for any file type. Large file sizes wont perform.

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.

@RezaDorrani

2 ай бұрын

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)

@glennmurphy2546

2 ай бұрын

@@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?

@RezaDorrani

2 ай бұрын

@@glennmurphy2546 Not sure about the scenario you mentioned

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?

@RezaDorrani

3 ай бұрын

No, as Power Apps respects SharePoint security

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.

@RezaDorrani

Ай бұрын

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.

@NKBobcat

Ай бұрын

@@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!

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❓

@RezaDorrani

Ай бұрын

Try and see what happens. Even I don’t know.

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?

@RezaDorrani

27 күн бұрын

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

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?

@RezaDorrani

3 ай бұрын

Thank You so much! kzread.info/dash/bejne/hqGGqKOJZ9u6p84.html

@CesarHernandez-fq6ds

3 ай бұрын

@@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.

@RezaDorrani

3 ай бұрын

@@CesarHernandez-fq6ds I would recommend to become a channel member and get the entire code base.

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?

@RezaDorrani

3 ай бұрын

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.

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

@RezaDorrani

27 күн бұрын

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.

@user-hk5ci3ij5p

24 күн бұрын

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

@RezaDorrani

24 күн бұрын

@@user-hk5ci3ij5p My response would be the same. I have not faced any issues so not sure.

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

@RezaDorrani

Ай бұрын

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

@fundivine

Ай бұрын

@@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

@ajayrathod7777

Ай бұрын

​@@fundivinedoes it work for word and excel file?

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-

@RezaDorrani

Ай бұрын

Video description has details on link to download entire solution. Your scenario should be possible.

@darylbingham8332

Ай бұрын

@@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

how to add all the attachments from share point list to pdf file in power apps(not considering the id)

@RezaDorrani

3 ай бұрын

I do not have a video reference on this one and have not come across this scenario so not sure

Thank you very much for the information. I did it the way I wanted without any problems. But I have a question. How can I correct the uploaded data? is there a video for this?

@RezaDorrani

12 күн бұрын

Uploaded file data or file properties? File properties can be updated in form control. Actual file would have to be overwritten. I do not have a video reference on this.

@yusufaydogan07

11 күн бұрын

@@RezaDorrani Hello. Thanks for your answer. What I want to fix is ​​Uploaded file data. Not features. I can change its properties from the form, but instead of deleting and reloading the content, I want to refresh it with the existing image or pdf. In other words, updating the data itself, not the features.

@yusufaydogan07

11 күн бұрын

@@RezaDorrani Uploading is not a problem but updating the data itself is a problem

@RezaDorrani

11 күн бұрын

@@yusufaydogan07 Im not sure how to do that. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

@yusufaydogan07

7 күн бұрын

@@RezaDorrani Thank you again for your interest.

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.'."}}.

@RezaDorrani

2 ай бұрын

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

Did this a few month ago. But not by submitting the properties as json. Your way is much more elegant...

@RezaDorrani

3 ай бұрын

That properties trick is not well known. Im glad to hear this video is being appreciated for that.

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”.

@RezaDorrani

2 ай бұрын

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

@jamief3592

2 ай бұрын

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!

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?

@RezaDorrani

3 ай бұрын

I dont know :) but it does not make a big difference as I can see what property to set

@lencardinal1584

3 ай бұрын

@@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.

@RezaDorrani

3 ай бұрын

@@lencardinal1584 I dont remember if it puts out the name of the param as well.

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?

@RezaDorrani

3 ай бұрын

Why would you want to do that? Modified date cannot be blank

@Y0urN3m3sis

3 ай бұрын

⁠@@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.

@RezaDorrani

3 ай бұрын

@@Y0urN3m3sis Get file properties action should give you created and modified both.

@Y0urN3m3sis

3 ай бұрын

@@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.

@RezaDorrani

3 ай бұрын

@@Y0urN3m3sis Im not sure about whats the solution for that

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.

@RezaDorrani

Ай бұрын

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.

@GraceJoe-hi5zm

Ай бұрын

@@RezaDorraniUnderstood. I really appreciate your reply. But is my request technically possible?

@RezaDorrani

Ай бұрын

@@GraceJoe-hi5zm Possible with assistance from power automate

@GraceJoe-hi5zm

Ай бұрын

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

@RezaDorrani

Ай бұрын

@@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

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??

@RezaDorrani

Ай бұрын

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.

@phuongtran2491

Ай бұрын

you missed the s in contentByte(s)

@tarungupta6716

Ай бұрын

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.

@RezaDorrani

Ай бұрын

@@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

Is there a way to patch an attachment(s) to a row in a SharePoint list rather than a document library?

@RezaDorrani

25 күн бұрын

Patch function does not support file uploads.

@user-rt3fw5jw8l

25 күн бұрын

@@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

@RezaDorrani

25 күн бұрын

You will need to use flow for that as well

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.

@RezaDorrani

3 ай бұрын

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.

@mustafahussainmohsin320

3 ай бұрын

@@RezaDorrani got your point can you refer any video of yours? Or a playlist name?

@RezaDorrani

3 ай бұрын

@@mustafahussainmohsin320 I only have 15 playlists or so. Please check playlists on my channel.

When I start typing the "attach. Attachments" why doesn't intellisense pick that up? It just errors out

@RezaDorrani

Ай бұрын

No clue about it as I have not experienced this.

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?

@RezaDorrani

27 күн бұрын

Power Apps cannot handle large files. Attachment control can accommodate max 20 MB.

@dmvogan

27 күн бұрын

Actually, we see it handling up to 70 mb. I’ve come up with a pretty slick workaround though.

@RezaDorrani

27 күн бұрын

@@dmvogan Great

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.

@RezaDorrani

3 ай бұрын

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)

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

@RezaDorrani

3 ай бұрын

Table format?

@gkvgulshan

3 ай бұрын

@@RezaDorrani yes.

@RezaDorrani

3 ай бұрын

@@gkvgulshan Approvals supports markdown syntax. Check approvals documentation for details.

@gkvgulshan

3 ай бұрын

@@RezaDorrani Thanks for your kind support.

Great Tool, I followed along but my folders aren’t visible.

@RezaDorrani

2 ай бұрын

I have provided entire app for download (check video description for details) It has step by step guidance

missing column. your formula is missing a column content Bytes with a type of Blob. Getting this error. code-myflowx.Run({ file: { name: First(attach.Attachments).Name, contentBytes: First(attach.Attachments).Value } }). please help

@RezaDorrani

8 күн бұрын

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

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?

@RezaDorrani

Ай бұрын

Whats the problem if they do run at the same time?

@julienvdc

3 күн бұрын

@@RezaDorrani I would like to add an ID to each file name to make them unique to prevent file replacement. I was thinking of using an increment by 1 of the highest ID in the list. But if the flows are running in parallel they are using the same ID...

@RezaDorrani

3 күн бұрын

@@julienvdc You can always use a GUID for each name to make it unique. Flow has a guid function. You could also use current date and time (upto millisecs) to get a unique name.

@julienvdc

3 күн бұрын

@@RezaDorrani yep that's what I've ended up doing

Will this method work while offline(Once online again it will upload)?

@RezaDorrani

3 ай бұрын

SharePoint offline is not supported in Power Apps

@tylerdegrand3034

3 ай бұрын

Do I need to use the older method of base 64 to upload pictures offline?@@RezaDorrani

@tylerdegrand3034

3 ай бұрын

@@RezaDorrani To accomplish this would I need to convert the image to base 64?

@RezaDorrani

3 ай бұрын

@@tylerdegrand3034 I am not aware of how to do it with SharePoint

where we found "issue tracker" 2:16?

@RezaDorrani

3 ай бұрын

I mentioned in video that you can use an SP list of your choice. Issue tracker is list that I have.

How to create new folder for uploaded attachments?

@RezaDorrani

3 ай бұрын

Flow has a create folder action.

how to add all the attachments to pdf file in power apps

@RezaDorrani

3 ай бұрын

Not sure about this

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.

@RezaDorrani

2 ай бұрын

That sounds more like a KZread problem. Not something I have ever come across.

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.

@RezaDorrani

3 ай бұрын

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

@gkvgulshan

3 ай бұрын

@@RezaDorrani it would be appropriatble if you make a tutorial on this, thanks in advance

@RezaDorrani

3 ай бұрын

@@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.

Still now PowerApps doesn't have a control to upload files to a Doc library? The mind boggles.

@RezaDorrani

7 күн бұрын

attachments is the only option

@cardinalnight3883

7 күн бұрын

@@RezaDorrani cheeky question: I am using your solution, but I can't see the uploaded files from the doc library in the attachments control. What do I put for Default and/or Items properties?

@RezaDorrani

7 күн бұрын

@@cardinalnight3883 I have not faced any issues with it so not sure. I have made the entire solution available for download (members only - check description for details)

@cardinalnight3883

6 күн бұрын

@@RezaDorrani Thanks Reza - you helped me sort out an issue I was having for a while.

USELESS

@RezaDorrani

2 ай бұрын

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!

@RezaDorrani

3 ай бұрын

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

@Nico-xp1vk

3 ай бұрын

@@RezaDorraniany ideas on something I could try out? How can I change the output of the people picker datacard?

@RezaDorrani

3 ай бұрын

@@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.

@RezaDorrani

2 ай бұрын

You could make them required fields on the form