PowerApps upload multiple files attachment to SharePoint
Вставка
- Опубліковано 15 вер 2024
- #PowerApps #SharePoint #UploadMultipleFiles #AttachmentControl
In this video on PowerApps upload multiple files attachment to SharePoint, we will upload multiple files, tag and validate each file independently and upload to SharePoint list.
This technique can be leveraged to upload multiple files to any data source of choice.
Download the sample App which also includes the flow from the link below:
github.com/rdo...
Cheers Reza, cant wait. Staying up late (AEST) to watch this. It is desperately need to fill an information gap, i hope Microsoft is paying you for this..
Wow thats some compliment. Thank you.
All of my videos on UA-cam are made with the intent of sharing information with the community. I try my best to put out something new every time.
@@RezaDorrani the champ
I need a help in power apps. I am creating an app in which a user fill some details and in costing details user can input one or multiple line items and in attachments there may be one or multiple attachments . I want to store this in back end dataverse table. How to do this .
Whenever I stuck somewhere I just remember you and I got the answer👍👍
@@analyticsadda6080 This is not a scenario I have tried or have a video reference for
@@RezaDorrani pls share linker or name of the video. It is very difficult to find/
@@analyticsadda6080 I mentioned I dont have any references
Your page has the most useful tutorials. It seems you really understand the sort of things that people are actually trying to achieve.
Thank You 👍
Hello Reza! I'm very happy with your content, thanks for helping the Power Apps community, I'm from Brazil! Hugs! 👏❤
thank you and love to Brazil
My first comment ever. You are AMAZING! You have no idea how long it took me trying to create a solution like this. Please don't stop making videos
Thanks John. I will keep trying my best.
Excellent example of batch upload.
There is one nuance that you have to be aware of.
PowerApps expects response from the Flow within 120 seconds. App will treat the flow call as timed out and continue execution without getting flow response.
So it may have some problems when processing a lot of files.
Absolutely correct. Hence the limits of only 10 files and 10 MB each.
File size can be increased to 50 MB. Alternatively the flow can just respond to Power Apps with a upload process started message and once complete the user can be notified about the updates.
@@RezaDorrani That is a good idea, but how can you notify a user about updates when flow responded with "process started" message and finished interaction with the app?
The only way I was able to do that is by creating a timer in PowerApps which checks Job status log for status change for Job GUID returned by the flow.
Is there a better way to send flow status updates?
Ylotan Send email notification once complete or just show a gallery with job status of user jobs. Can also be a combination of both.
@@RezaDorrani Will gallery update by it's self when job status changes at data source?
Ylotan Not by itself. Unless user navigates to a different screen and comes back or a data source refresh is initiated or the user reloads the App which would initiate a data source refresh
This is exactly what I needed. Thank you, Reza! My solution was a bit more complicated due to what I needed to do with the data, but your video gave me the foundation I needed.
Thank you and glad to hear the feedback
Wow! Thanks for explaining mini tricks and implementation logic thoroughly! The problem statement you pick for your videos is always unique and important ! Looking forward for more videos! ✌✌
Thank you for the amazing feedback 😊
Hi Reza, Really appreciate for sharing your knowledge and expertise in PowerApps. And I like the way you explain every detail, it's very helpful to understand the process. Keep up the good work.. :)
Thank you Fathima
An intelligent way to make use of the controls... I loved your ideology buddy !!
Thank you
Superb, your sample file was very helpful.. Thanks Millions.
Glad to hear that!
Thanks a lot Reza Dorrani ! This is very helpful for PowerApps developer.
You are most welcome!
Thank you Riza, you saved my day again, God bless you
Glad to know video is helpful.
Thanks Reza .. great content as always and really well presented
Thank you Richard
Great video and all content that you share with us Reza!
One question: You have used a sharepoint list, but can I use a sharepoint library documents?
Possible. Here is the video ua-cam.com/video/UYK7yruBHDM/v-deo.html
I've watched about three of your videos which all were very helpful. I'll make sure to view all the others. Have you or will you be writing a book on PowerApps and Automate and how they work together? I think that would be a real asset!
Thank you for watching the videos on my channel.
I have received multiple offers for writing books but I had to politely decline since I have limited time. I need to be in the perfect frame of mind to write a book. Current focus is on my UA-cam channel.
Thank you for this video! It help me a lot, thanks for your work!
You're very welcome!
Superb, your sample file was very helpful.. Thank you!!
Glad to hear that!
@@RezaDorrani how to get SharePoint address/Path (where i had uploaded the image/file) back to powerapps in some lable. Appreciate your kind help
@@RaviShankar-ou1ly Once you upload the file from flow, the dynamic content output of that action should give you the path which you can send back to Power Apps.
@@RezaDorrani Thank you for your swift reply. Honestly, I am trying to get in Lable since yesterday but didn't get that using flow. If I may request you to add that option to your Github file as an enhancement.
@@RezaDorrani finally got it...First(formAttachment.LastSubmit.Attachments).AbsoluteUri
Thanks Reza.
Let me ask.. supose that i want to have more controle to my library.. im talking about to field some collumns, from powerapps.
So i could CREATE the file in sharepoint from powerapps and flow, according your video... OR drop and drag the file to sharepoint, and after to field all information in powerapp.
Both will work.. the question is.. both could be used without fear about to be scaled?
I was thinking that create files to my library... from powerapps and flow it would be a little against the grain.... "lookk.. we have sharepoint to you drop and drag... why would you create from Powerapps?"
Can u understand my question?
Drag and drop is supported in the attachments control as well.
Key to working with Power Apps is to know about the limitations of Power Apps.
Power Apps is built keeping mobile experience in mind.
Large files, large number of documents will result in performance issues.
Thank you very much Reza, it is wonderful🙂 !!!
Thank You :)
Hi Reza,
Thank you for your videos related to PowerApps and cheers to your channel.
I just have this question. In our sharepoint list, i was not allowed to upload PDF files. Resulting to unability to add the PDF in the attachment in powerapp. Is there any other way to solve this problem? * (Without using Azure Blob Storage- if possible)
It should work with all file types. I will have to look at your App in action to know why is pdf failing in your case. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
I am getting an error after pressing the "Upload to Data Source" button. The code highlighted as an error on the button is (OnSelect):
(...)
'PowerApps-SendFilesWithMetadataToSharePoint'.Run (
JSON (
colFinalData;
JSONFormat.IncludeBinaryData
)
) .success
(...)
Does anyone have any idea what causes this error? Thanks.
Solution:
In case anyone else gets this error I deleted the Flow connection from PowerApp, disabled the Flow then re enabled it.
I then added it back into PowerApps again this seems to have resoved the issue.
Delete flow association in App and re-add. Looks like you got it to work doing exactly that :)
I greatly appreciate your knowledge sharing
Thank you 😊
Hi Reza, thanks for the recommendation. I followed the instructions to import but didn’t work, I guess I’m tired and need to come back with a fresh mind. Anyhow, the idea you posted here is exactly what I was looking for, so this comes very useful. Regards
Did it work?
@@RezaDorrani hi Reza. It didn't. I figured out what I needed using a SharePoint instead of a library and it worked. I've saved your app to study it later with more patience. By the way thanks for your videos, I've learned tons from you. Hugs from Panamá
@@Maynardjones100 Great!
Reza, thanks again..
One question.. you put an image inside of galery called "imgDataStream", to get the real base64, using "imgDataStream.Image" in the last Collection (colFinalData).
I tried to do this, but wasnt work. My colFinalData come with DataStream = [Image], and this didn't go to my flow.
What i did? I collect in my colFinalData the DataStream using Substitute(JSON(imgDataStream.Image;IncludeBinaryData);Char(34);"") ... i converted this image in powerapps and sent to flow this base64 string.
Is it an bad way? I dont know why using your metod didnt go to my flow.
Your method is also fine.
Video description has link to download the sample App which includes the flow as well. Give that a try.
Excellent video Reza! Thanks
My pleasure!
Thank you. Great explanation!
You are welcome!
Thank you for this great solution! I have it set up exactly like yours and it works great for the most part but for some reason when I try to upload multiple files at once it adding both of them to the colFinalData collection twice and is therefore sending them each to the flow twice. So essentially if I upload two files at once, it creates 4 records in my collection and then in my SP list. Any idea why this might be?
I have not come across this issue &; hence not sure what the resolution is. Video description has link to download the sample App. You can give that a try. Alternatively, I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
any idea on how we would do this with the new powerappsV2 trigger? When I try to pass the variable back to powerapps, powerapps interprets it as a record rather than a boolean value. Thanks!
ua-cam.com/video/QUwzvUXgj58/v-deo.htmlsi=FSYLqMeMZqYkQD9K
Excellent tutorial! Thank you Reza! This was very helpful for my case. I got more columns in my SharePoint list, can you show a bit more about how you create the flow?
Thanks.
Video description has link to download the sample App which also installs the flows since they are connected to the App.
You can check the complete code in there.
@@RezaDorrani Thanks for your reply Reza, one more thing to ask about the flow, for the step "Scope" - "Create Item", after selecting the site address and the list name, how do you select the content of each column? For my site, I can only select the variable output only. When I view the code, it only shows "output(JSONMetadata)", but for your part, your selected column's coding is "item('Apply_to_each_and_send_to_Sharepoint_List')?('Date')", how can I do this step to select the correct column?
@@yongwhang8095 This is where expressions comes in. I would have to look at your flow in action to provide guidance. I will recommend you post your query with screenshots of your list, columns being passed etc. on the forums at powerusers.microsoft.com/
Again, when we have Reza Dorrani, who needs Netflix!
Thank You 😊
Hi Reza The documents are uploaded properly in my Document library. workflow shows succed. however if i navigate to respond to powerapps action i get this "The execution of template action 'Respond_to_a_PowerApp_or_flow' is skipped: the 'runAfter' condition for action 'Set_variable_2' is not satisfied. Expected status values 'Succeeded' and actual value 'Skipped'.
I would have to look at your flow in action to provide guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
what is the difference between IsBlank(datepicker.SelectedDate) and datepicker.SelectedDate=Blank() ?? which one do you suggest and why?
Great question.
Answer is in the docs :)
docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-isblank-isempty#description
Really nice explaination but I am stuck with large files(around 50MB) which I am not able to upload from powerapps to flow. When my flow.run is executed it is giving me invalid json response . Also I have increased the maximum size limit to 50MB but still it doesnot work. A solution would be really helpful
Flow has to respond to Power Apps within 2 mins.
When large files are uploaded, the entire file data first has to be trasnferred from Power Apps to flow and then flow has to process it and push it to the dat soruce of choice.
That is one of the reasons why in the sample App provided, I limited my file sizes to 10 MB max.
Its important to note that Power Apps are primarily designed keeping the mobile experience in mind. Loading large files in App (all data is held in memory on device or users browser) would surely run into performance issues).
For large files, Power Apps is not the best choice.
Hi Reza, thank you very much!! Question from my Case: If an user understands he/she needs to delete one of the uploaded files from SP List,
which formula could work for it in the nested gallery with download icon u. file name? Than you in advance!
Something like Remove(ThisItem)
Very useful and mainly to rename files before upload in bulk . However, do you know how can I download all attachments in one button click and not individual attachments from your main gallery ?
For bulk download, you would have to use flow. Flow could load all files, add them to a zip file and mail it out to the user or store it in a location which can be opened via Power App.
Thank you for the sample!)
My pleasure!
thanks Dorrani, would it be possible to use this to add documents with metadata to SharePoint library?
Yes. All you would need to do is change the flow to push the documents and its metadata over to a doc library instead of a SP list.
@@RezaDorrani thnx Dorrani, but im not able to change under scope. Anny sugesitons. Usd ad fil and fil information.
@@Zafar_Iqbal Try recreating all the actions in the scope including the scope from scratch.
@@RezaDorrani - works for me using your App Template... as you recommended, I replaced actions under scope as following; I deleted Old actions a the end, to utilize expressions already built :
1- Create a File , here moved datatobinary function formula with Metadata to File Content; file Name is coming from expression items(apply_to_each)?[‘Name’]
2-Update File Properties to change Tags -items(apply_to_each)?[‘field’]
Regards
Hi Reza, Great Tutorial. Just wanted to check if we can have multiple Attachment data card in powerapps and saving all the attachment to sharepoint list item?
SharePoint list only has 1 attachments column. So you cannot have multiple attachment cards per list item.
Thanks!!
Hi Reza,
Thanks for the excellent demonstration for the multiple attachments.
Here i have few things that i am struck with flow
1) i have created JSON in compose model, but i couldn't able to find the data which i have given in Power Apps
2) In your flow shows that the 'Title" is showing in JSON value, where i couldn't not get that.
3) Particularly in calling the Flow ,(.Run) method i am facing issue ...
4) i have also downloaded the file & tried importing it but i have different scenarios where i have to implement it in my tool.
Do you have any better suggestion on it to overcome the error ?
I would have to debug your flow to figure out the exact issue. Difficult to provide guidance here on chat.
I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
How are you? Could you solve it? I have almost the same drawbacks
@@657cobra I would need to recreate the scenario to solve it. I would recommend the issue to be posted on the forums with screenshots at powerusers.microsoft.com/
@@657cobra No buddy i have tried alternate way and completed it
Thanks you Reza excellent video and also for sharing the App and Workflow
You are most welcome
Thank you for sharing the information Reza... Big Fan of your videos .... Any plans to prepare video on the monitoring tool in power apps for identifying performance issue and improving performance?
I did a webinar on Power Apps peformance - ua-cam.com/video/oPwa-dSshZQ/v-deo.html
Monitoring tool is still in preview and many features are being added.
@@RezaDorrani Thank you for your response.
Hi Reza, loved the video! One doubt- what are we adding in PowerApps V2 input in flow?
ua-cam.com/video/QUwzvUXgj58/v-deo.htmlsi=8WyVb-aKThyih4Cv
Hi Rezza,
Thanks for the great video. I have implemented the same in my app, and the app works fine. However while trying to remove and added attachments which is the top most one, it is resetting the controls of bottom items. Can you let me know if you have faced this scenario?
I will have to look at your App in action to know about the cause of your issue. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, great video that has helped a lot with a current project. You mention in the video you can use Patch to push the data to SharePoint, but I'm confused as I thought you cannot Patch attachments... could you clarify? I am hoping to keep everything in Power Apps but will have to use Flow if not.
Yes, attachments cannot be patched. Flow is your friend.
I have done multiple videos on storing attachments apart from this. All of them use flow -
ua-cam.com/video/UYK7yruBHDM/v-deo.html
I am creating a flow for data entry I SharePoint list. The Trigger is a PowerApps form:
1: power apps form has a button that calls a flow on click
2: I am trying to capture name of that trigger button and save it in SharePoint list.
3: One field in flow is TYPE STRING and its purpose is to capture value/name of that trigger button to store in SharePoint list
4: but when i call flow by clicking this trigger button , it is capturing false/true instead of trigger button name.
I understands since this is trigger could be the reason of this boolean value but i need to have a name entry such as X or Y for both buttons Why i cannot figure out. any idea how to get button's name instead of false?
I have not understood your question. I would have to see your app/flow in action to provide any guidance. I will recommend you psot your query/issue on the forums with screenshots at powerusers.microsoft.com/
Amazing!
Thanks!
Hi reza when I tried to run the upload to data source button I got error that trigger is not enabled and I have followed the instructions to edit the button as mentioned in the video. Still there’s error
Video description has link to download sample App. Give that a try.
As for your issue, I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi, i have problems in the flow, with JSON. Do you have any idea about that? I'll appreciate too much, thanks!
I will have to look at your App & flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi, Reza! Thank you for this! But will this work only for sharepoint lists? does this work for Document Libraries too?
Action in flow is to upload to list attachments. If you change that logic to upload file, then it will work for libraries as well.
Hi @Reza, in your video at point 10:41, under variable Metadata I am not able to see Metadata_Value from Power Apps. Any idea what i am doing wrong ?
Video description has link to download sample App. Give that a try.
thank you for the video, it work very will and that help me a lot but i still have a question about the json in shema, i updated the share point list by adding a new column, and i add the value that i want to answer in the column in the collect but i don't know how to update the output of json in shema for put the value in sharepoint item?
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Good night Reza, very good your video lesson. I have a question: what would it be like to save this photo in an offline application and then sync when there was internet?
Possible using the SaveData & LoadData offline functions in canvas apps. I have a video planned on offline apps.
Yes Raza. I used save data and load data but my difficulty is good in relation to saving multiple images within the same ID (eg: 2 or more photos within the same record). I was unable to modify / change PowerApps and PowerAutomate to do this procedure.
@@diegocabralfigueiredo1771 I would have to see your App, lists etc. to provide any direction. I will recommend you post you scenario with screenshots on the forums at powerusers.microsoft.com/
Hi, Reza excellent video. I am having the same requirement where I need the user to select the document type from the drop-down, I am getting the first value for all entries in the collection even if I change attachment type drop-down values. please note I am doing this on SharePoint form customized in power apps.
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
thank you so much @@RezaDorrani for your reply, created a small document to make you understand the issue. I have already wasted 2 days behind this, I don't know what wrong I am doing. many thanks once again 🙏
docs.google.com/document/d/1AtyAY00hW3fZS_JLMNZ1duIig9R5xxJvOWiAGDRu4p4/edit?usp=sharing
Hi Prasad,
I have a lot of work priorities and commitments.
Your best bet will be to post your issue on the forums.
I also go to forums to assist but only in my free time.
Hi Reza ,good video . But You didn't give details of the parameters inserted in Power automate . I'm stuck because I don't know how did you put title , ecc... starting from your Json . Maybe for advance people it's piece of cak but not for beginners
Video description has link to download sample App.
Mostly, when a video is targeted for beginners, I do mention it in video description or title.
@Rezza,
How We can add Multiple attachments datacard in power apps edit form (using SharePoint data source)?
Or Could you suggest me a better solution.
ua-cam.com/video/hJQjGE-oUpM/v-deo.html
Thank you dear for doing such an amazing video dear. But dear how to autogenerate and auto increment the invoice number and lock it so no one can modify it ?
You can achieve that through formulas and permissions management via flow.
@@RezaDorraniThank you for your reply dear. So there is no way to do so via powerapps right?
@@ahmadyamout1115 Permission no. Auto number yes.
Can this also be applied to document library but attachments would be uploaded as files?
Yes, you can use the flow action to upload file to library instead of list item attachments
Hi Reza, I'm trying to do exactly what you're showing in your video, but I don't understand the flow at all. Is there a more detailed guide on this anywhere?
I would very much like to implement your great idea in my application.
i hope you can help me?
Hi Robert,
The flow is part of the App which is available for dowload. The link to download App is in description of video. The steps to install and configure are in the video.
Once you install the App, you can explore the flow and its steps.
Olá,
Caso você baixe e de erro, verifique os nomes das colunas da lista do SharePoint... Por exemplo: O meu deu erro no formulário por que minha lista estava com o nome "Anexos" e no App está "Attachments"...desta forma é só atualizar que já volta a funcionar.
Sorry, I did not understand if you are having an issue or not :)
Que coincidência, acabei de baixar e tive esse problema. Valeu
@@MarlonCasado Imaginava que alguém mais teria..... Abraço !
@@RezaDorrani I had a little problem. But I ended up correcting .... This way I only commented if someone also has this problem
@@MarlonCasado @Marlon Casado t.me/joinchat/H0LcPfvxBkNQwaku Esse link leva para um grupo de Power Apps no telegram...Se quiser entrar.
Coloca sua dúvida lá que lhe ajudamos.
Outra coisa, no minuto 17:05 você fez igual ? Apagou o código conforme ele pediu ?
Hi Reza, My use case is to upload single pdf files in two separate input Fields in Power apps (Field 1: Sample File and Field 2: Sample_1 File). For this I have written following expression "'PowerAppV2->Compose'.Run('Sample Text'.Text,{file:First(Sample.Attachments),file_1:First(Sample_1.Attachments)}". However Run Button of Power Apps is showing error "Invalid number of Argument- Received 3 expected 1-2.Pls help me how to overcome this issue. I even posted in Power apps community but nobody is able to solve this problem.
Forums will be your best bet. Remember it is a free platform. You may or may not receive a response.
If you need urgent assistance, then I would recommend getting consulting help.
@@RezaDorrani Hi Reza, Do you provide consultation services . If yes pls let me know how to contact you for same.
@@srv158 I do not offer consulting services.
Hi Reza, Thanks for the video. I want to create zip folder for multiple file upload ing. Is it possible to create zip folder for multiple file uploading.
I have not tried this so not sure. May be using some api in flow. I will recommend checking on forums in case someone has done something similar
powerusers.microsoft.com
Hey Reza, is it possible to instead update a list item with an attachment rather than create?
Yes. For that you can directly leverage the attachments connector in form control.
Dear,
Good morning and recently started your classes and very much interested learn your topics and all explanation very clear and excellent
And tried to import your one class and showing below error appeared please can you share the reason
Thanks for watching my videos.
I do not see any error here on chat. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Thanks Reza,
How can we attach a file from sharepoint document library?
Not from windows explorer.
Please suggest...
It will open windows explorer. If user has synced document library using OneDrive, they can select it from file explorer and attach file from there.
@@RezaDorrani If users are using virtual platform where they are unable to upload file from explorer,
This is why I asked, is there any possibilities to attach directly from sharepoint document library...
@@LaxmiPutraPawan No direct option based on my understanding.
This is what I need, well thank you once again for your time and consideration...
Excellent video Reza!
I need your advice, how could I upload multiple files and through the metadata only leave 1 visible to the end user?
Thanks a lot!!!
Thank you.
Can you elaborate a little more about your requirement?
I use a gallery control connected with sharepoint list in which the final user consult the PDF files. I was thinking to upload also the native document in the same id record and i think is neccesary to tag the attachment so the user can use the pdf file and i can see both, it is possible?.
Thank u again Reza!
I don't see the link for Attachment control video. please share the link.
I have a playlist on SharePoint list attachments that has all the videos
Hi Reza,
Can you help your follower with below requests?
Scenario:
A job ticket is created using power connected to SharePoint lists.
An organization with various department and selected user for each department are required to upload documents which is relevant to them to each create Job ticket ID.
Question:
How can PowerApps developer set permission where user can only see and modify documents which he uploaded.
Is it possible to create multiple attachment columns on SharePoint so that each department can be allowed to access his “Data Card” to upload the document?
You can set item level permissions at list/library level. You could also use flow to set item level permissions.
I do not have a video on this scenario though.
I will recommend you check on the forums at powerusers.microsoft.com/
Hi Reza. Is it possible to upload one file and copy it to multiple Forms (SP Items). Use case it a request system that creates tasks to multiple teams. They both need a copy of the same file but I want to avoid the user having to upload the same file twice into two separate attachment controls. I have one attachment control working.
Possible. But I do not have a video on that scenario and is something I would have to try out :)
I will recommend you check on the forums at powerusers.microsoft.com/
@@RezaDorrani thanks mate I managed to pull it off. Just used multiple patch statements to submit each item on a button with variables feeding the fields of the form. In between each patch I changed the variables in order to customise the item being raised. Works quite well.
@@JoshPlunkett 👍
Can't wait.
This is the first video with my new intro.
I hope it turns out good.
@@RezaDorrani I'm getting an error on the last step of editing the "Upload to Data Source" onselect code. Tried it a couple of times and when I re-associate the edited flow and then copy the code back into the onselect field, it throws an invalid argument error.
Christopher James did u follow the installation steps in the video?
Send me screenshot of Error on reza.dorraNi@outlook.com
@@RezaDorrani I did. But I'll run through the whole set again from scratch before I waste your time. Always possible I missed something.
Christopher James let me know in case of issues. I tested it in 2 tenants.
Hi Reza can you show the step how to display all information from sharepoint list at 1:02 including the file name at attachment?
Video description has link to download the sample App.
if the file size is big, e.g. 2.5MB , it will be slow response time or the browser without any response for a while. any idea what is the cause. I am doing the same way to use. for small file it is ok.
That is expected since Power Apps is built keeping the mobile experience in mind. In this case, we are passing the file object to flow, the larger the file object(s), the slower the response.
Good one Reza 👍
Thanks ✌️
Hi Reza, Good job as always, please is there a way to update the attachment list? Say i submit my powerapps with 2 attachments initially, can i update the form and add additional 1 attachment and make it 3 attachments? How can that be achieved please?
Form can always be updated. There are many form videos on my channel.
Update attachments is also a yes - with the standard attachments control.
I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thanks for your video, have recently started following for powerapps support. so, BIG Thanks...
Was wondering if we have a way to upload an image (in image field) in sharepoint and show that (as embedded) in powerapps and may be vice versa as well.
Thanks in advance.
The new Image column in SharePoint does not work with Power Apps (this is a known issue).
Oh ok. Do we have a different option ?
hey, what is the expression in creating item in sharepoint list? Ty!
Video description has link to download sample app (which will also install the flow).
Hi Rezza, is it possible to use to upload also multiple files attachment for one rows?
I'm assuming you mean list item attachments (multiple attachments to single row). Check for list item attachments related videos on my channel.
This is great. Do you think it would be possible to select a different document content type for each document and force required meta data for each type of document? Curious to get your thoughts.
Possible however Power Apps does not understand content types. You could query flow to get the columns related to a content type and built it.
Hi Reza, great video as always. I'm stuck in something similar I've been playing with. I have a pictures app that uploads photos and additional metadata to sharepoint. What I can't figure out is how to dynamically determine which sharepoint site to upload, especially for updating the file properties/metadata. For example, when a photo is uploaded, I'd like for it to upload to site based on a "project number" which matches with the site url. So I thought I could pass this value to flow so that I could inject it in the sharepoint site url where the photos would need to be uploaded to, but can't seem to figure out how to do this in flow or powerapps so that the metadata gets is updated as well. If I use a custom value for the site address in the Update file properties step, it does not display the columns I need to add the metadata to. Got any ideas or pointers? Thank you for creating these type of videos as they are great help in our journey of learning the Power Platform.
Hi Sergio,
The SharePoint actions - create item & update properties do require the link to the site at compile time.
Your best bet would be to use the "Send an http request" action for SharePoint where you can dynamically define the site url.
The challenge here will be to use the correct rest api method to create items/files and update item properties/files.
Reza Dorrani It’s a challenge indeed as I can’t seem to find any documentation or examples for creating files and/or updating file properties. All i found was for working with lists which i tried just to see what would happen but had no luck. Thank you for uour feedback, at least I now know I’m in the right track.
How to upload 700mb file to sharepoint document library or blob storage using powerapps and powerautomate??
Not sure if Power Apps is the right choice to do that. When passing file info from power apps to flow, there are limits. I believe file sizes greater than 20 MB run into timeout issues. I would recommend you post your query on the forums as well and see if someone has done something different at powerusers.microsoft.com
How to grab the SharePoint attachment in form. I do not see the link to that Video here. Please share.
The description of this video contains link to download the App.
Are you referring to any video reference given in video? Can you give me more info.
Thanks Reza for this video. I have a requirement to upload attachment files into Dataverse source. My question is Can we upload more than one file under one record of a table in dataverse? In your video i saw that you are adding multiple files to an existing list item. Can i achieve the same in Dataverse? If yes, please can you help in details. Thanks in Advance
Possible. Create another table to store files (use file data type). Then create a 1:N relationship with that table.
I have not tried this scenario.
I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thank you so much for the reply. i will definitely try this approach.
Thanks Reza! Is there any way to (a) download a single file automatically (without it opening as a preview first and then needing to select download) and (b) download multiple files?
I believe that is the default behavior wherein it does preview it and then downloads. Launch and Download are the 2 functions but they exhibit this behavior.
Download multiple files is not a feature. You could call flow so it can create a zip file of the files selected to download.
@@RezaDorrani thank you and Happy New Year!
@@geralddahl9159 Happy New Year
Many thanks
Most welcome
@@RezaDorrani hi Reza, the methods you provided were working, but now after a months it stopped working resulting in corrupted files. Tried to fix those using std office recovery but it didn't. So the content is getting lost. Can you help out here if your solution is still working. It could be some update from version which might have break it. Please help if you can repro this scenario. Many thanks 😊
@@MrDashingAshish Not sure if any version error has caused an error. Works fine for me. Try posting your query with screen powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Can this solution be tailor to a Sharepoint library as well ?
Yes. Just replace the actions in the flow to create file and update file properties.
@@RezaDorrani thanks for the prompt response 😊😊😊
Assalamualaikum, need help to upload gallery data along with pictures into email body as tabular format. Also how to prevent picture upload control to upload heavy image in term of pixel or mb
1 - when you pass collection to flow, you can create tabular data using csv data operation. To post image, some html code will be needed. I have a video planned on export to pdf which will include this concept.
2 - In Attachment control there is a setting to define the file size. I don’t think you can block based on pixel.
Good demo... Can you share left "upload files" control video? I don't see in description
Description has link to download App. Steps to install are in video. Both the app and flow are part of the solution.
Please include "upload files" control video? We don't see in description
Anand krish Description has link to my github repo where the App export is available. Install the App and follow the video to set up the App.
@@anandkrish1000 The upload files control is actually the attachment control.
Add a standard form control - point it to any SP list and add the attachment data card. Then copy paste the attachment control.
Hello Reza, Thanks for the video
can we get the video for attaching the files from two attachment controls in single page with power app.
Hello, not sure if I understood the request. You need 2 attachment controls? You can just add the attachment control shown in the video twice.
Sorry if I misunderstood your request.
@@RezaDorrani thanks for response, Just I need to display the relevant attachments in particular controls.
@@rohinisb3853 For that you would have to save the attachments in a seperate library since allfiles stored in list attachments are treated as a single unit. You would need to categorize your attachments in a seperate library or follow some naming standards to categorize.
i have 15 errors with "ThisItem" , name is not valid in GalAttach
Hello,
There must be some incorrect step or action that is causing this issue.
The description of this video contains a link to download the sample App (which also includes the flow). The video also contains a walkthrough of how to setup the sample App shared.
How should I create multiple attachments datacard in single powerapps form and send all attached file to SP list?
That's the default behavior of the attachments data card for a SharePoint list.
@@RezaDorrani ie, we can have multiple attachment control in single form? I created one tabbed form, first tab I need to have one attachment control, in the 2nd tab I need 2 attachment control. Also when an user open the submitted form, they need to c the attached documents in the form as well as in list. Is that possible?
@@shinshae7882 You can only have 1 per form.
@@RezaDorrani is there is any way to achieve my requirement?
@@shinshae7882 I am not sure. I would have to investigate. I would recommend you post your query on the forums at powerusers.microsoft.com/
Nice video but a little bit to faster. I can' add your apps or flow in my work environnement (security policies). I can't obtain for the Json outputs the name you have for you columns. so i don't understand how you get this information.
For video speed, UA-cam has a feature where you can slow the video speed. All my new videos I have ensured I speak slowly :)
As far as importing goes, I would recommend you sign up for a dev tenant and import the code. That ways you can check each step of the flow.
@@RezaDorrani it's not the video speed but more the speed of the several operations that you do. by exemple: when you attach in your flow the output from JSON, you get the several name of the field to update. In my side, y only have "Outputs" as value and no title, name or other data. other point: when do you create your flow. you insert first a buton and next, create the flow, after that you code the other elements? I have spend 2 days trying and retrying to follow your video but i doesnt work a my side. For the "Dev Tenant", It's not auhorized in my organisation.
@@giudicephilippe5644 You can setup your own dev tenant (outside your organization) for free. Sign up for a free office 365 dev tenant.
It is difficult to know why your flow is not producing the output values without looking at your flow. I would also recommend you post your query on the forums at powerusers.microsoft.com
I managed to get the flow partially work. Now, my problem is that he want "DataStream" as first object "Title", it doesn't work because the data are above 255 caracters. I'm still unable to get for my "create item", the value from the Json, only "Outputs" is available... For this Json, wich one do you use? Message? or a another one?
@@giudicephilippe5644 It is tough to understand here on chat the exact issue you are facing since I cannot see the App in action. I would recommend you post your issue with screenshots on the forums at powerusers.microsoft.com/
Is it possible to use patch function for saving attachments to sharepoint list?
Patch function does not support attachments and hence this video :)
@@RezaDorrani Thank you!
Hello Reza, great video! In this video it looks like you are sending documents as attachments to a SharePoint list. Can you use this process to send to a SharePoint document library?
Absolutely. In the flow use the create file action and then update file properties action to tag the metadata.
@@RezaDorrani using the Upload and tag multiple files screen in your demo and recreating it in another screen. The funny thing is there is an error on the line for OnVisible on the screen that is: Set(varSuccess, Blank()). Power Apps doesn't like that. Any idea what might be causing this?
I notice on your example for the List you have individual items such as Title, Date, etc. and I don't get any of those items listed for the document library. All I am receiving back is Outputs under JSON Metadata for Dynamic Content. Any ideas or suggestions on how to get Title, Date, Description, etc. to be displayed to create file and to update file properties?
John Heck The description of the video contains a link to download the sample App which also includes the flow. The steps to configure the App are in the video.
@@RezaDorrani yes, I downloaded the sample app and have watched the video a couple of times. I must be missing something somewhere.
@@RezaDorrani where does the Metadata value selected come from that you are using in the Flow in the initialize Metadata step? I think this is the section I am missing and/or not connecting with.
How to show list attachment file thumbnail into power app landing page. Ex: PDF wordor, ppt and xls ..
powerusers.microsoft.com/t5/Power-Apps-Ideas/View-thumbnail-images-of-List-Item-Attachments-on-mobile-devices/idi-p/264476
@@RezaDorrani Thanks for your reply .. images are showing but attached files are not displaying the thumbnail format .. Ex: i've attached PDF , PPT,Word excel files, these file thumbnail it's not displaying .
@@sureshp7204 I believe there is a different way for that. Post your query on the community forum at powerusers.microsoft.com
Thanks for the video Reza. Followed the video & files to replicate on my side. Everything works fine except the Create Item step. After the 'JSONMetaData' step (which i think is a compose right?), I don't see the keys of my json string like is your case (Title, etc). So I've only been able to create an item with static data. Please any help/advice on this? Yet I have same json schema as what your MetaData step gives as output:
[
{
"upfile": "data:application/pdf;base64,JVBERi0x..........
"ProposalStatus": "Pending",
"RequestID": 1,
"RequestPhase": "Start",
"Title": "Comments"
}
]
Hello,
There must be some incorrect step or action that is causing this issue.
The description of this video contains a link to download the sample App (which also includes the flow). The video also contains a walkthrough of how to setup the sample App shared.
@@RezaDorrani Thanks for the reply. I already downloaded & installed the app... It works fine with the flow & I have replicated exactly your flow, just with different list & those data points in my schema coming from the powerapps. Anyways I'll give another attempt at debugging else I'll have to find another method. Thanks
Thanks Reza
Most welcome
Hi Reza... Can we show each attached file Size in the gallery ?
I’m not sure if that’s possible
@@RezaDorrani I've tried to show with a label in gallery using "AttachmentCtrl.Size". But not sure on it
@@venumadhavravulapalli1463 Im not sure. I recommend checking on forums in case someone has done something similar
powerusers.microsoft.com
@@RezaDorrani Thank you
i'm new to powerapps can you make video of this from scratch? ireally like your video but i still don't know how to make it:'(
Hello, the description of this video has a link to download the sample app (it also includes the flow as part of the app).
The video also walks you through the setup.
@@RezaDorrani if i want to move it to the an existing app, can it work???
@@crestcentmoon you would have to move all the logic over. It will not move into an existing App.
How can I pass and add more fields' values in Compose section of the flow from Jason Metadata? In thi example you have only shown the Title field and it's value. but in my case I need to pass several other field values. If you can help me with. Thank you so much for sharing this. This has actually helped me a great deal in one of my projects.
You can just add more fields in Power Apps and pass those values in the collection as shown in video.
In flow the json action will convert the received data from Power Apps into JSON which can then be parsed to set values in SharePoint.
To learn json parsing, check ua-cam.com/video/C52brz28poU/v-deo.html
how to grab the attachment
Video description has link to download the App and try it out. Flow will have the attachments.
It's still working?
Should be