If you create the flow and run it from Power App, it works perfectly, but when someone else is trying to run the flow from powerapps....its throwing an error saying - resource not found in the excel (create table) connector. FIX: ruclips.net/user/postUgkxvQfTWNyuJWokAHCvM-NBazBXVnUtLJER?si=MAE660wkk1842wz6
I just had an ask for something like this in one of my apps, so I went ahead and implemented this. Following directions in the video exactly it worked like a charm, first try. Thank you for the incredible solution and thorough directions.
Hi Reza , I just wanted to take a moment to thank you for the excellent video on how to export large datasets from Power Apps to Excel using Power Automate. The content was fantastic and incredibly helpful! The explanation was clear, and the approach was very practical, which will definitely help streamline my processes. I’d like to make a suggestion: it would be great if you could create a similar video, but using Dataverse as the data source. Additionally, it would be really helpful to see how you handle Choice, Lookups, and other data types within Dataverse. I’m sure many of us working with this data would greatly benefit from a detailed explanation. Once again, congratulations on the great work, and I look forward to more amazing content from you!
Thanks so much. My rule for topic suggestions is set - "Every 6-8 months I ask for topic suggestions on community tab of my channel. Make sure to post this idea there. If it gets max votes, I will add the topic to my backlog"
Thanks a lot for this video, i was struggling with time out for 2 days, and this solves the problem. I just changed the source of data cause i´m using parsed data from a collection, and it worked fine. Thumbs up.
This is great Reza, thanks so much. An extension to your last week's video on exporting to excel via Graph, this video incorporates calling it via Power Apps. I did not know Flow must respond within 2 min or it errors out in the app so that was something new I learned. I'll be putting these in to action in my apps. 👍👍
@@RezaDorrani mate!! When my end-users are clicking on export the flow failed saying Action 'Create_table' failed: The request is forbidden by Graph API. Error code is 'accessDenied' I don't find any solution... Any idea legend?
@@johanynavarro8065 Its because the create table action needs onedrive id there. You would need to look for options to set those values dynamically based on user calling the flow.
Wow, you did it again... I have used power query to do this because there are 7 different filters i have to apply before downloading data... But this looks more prominent and quick.. Thanks again
Great video again. I'm really liking this Graph method of dealing with large volumes of data movement. Will certainly be doing this a bit more. Thanks again for sharing as I thought you'll miss this week because of PPCC. 😂😄
Another amazing tutorial and I can use it in a current project! 👍🏽👍🏽 Small tip: You can use the utcNow() function with the format specifier 'F' utcNow('F') in place of the formatDateTime(utcNow(), 'F') .
This is really good trick ! I love it. Only small problem in my opinion is that your solution use the share link of the file to open it. It is - i think - not a really good idea as it can give anybody in your organisation access to the file (if the link is shared). The better solution for me is to get the link of the file whithout sharing it (the file stay private). To achieve this, I used once again the api with me/drive/items/@{split(actions('Create_table')?['inputs']?['parameters']?['file'],'.')?[1]} endpoint. Then the result contains webUrl property which is the url to open the file which stay private ;)
Thanks Reza, I didn’t know the Office365 Users connector could be used for that graph api call. That enables some more use-cases without premium connectors.
Thankyou very much Reza. It works for me. The only thing is that I have some Lookup columns in my List that alllows multiple choices per register, So when I called it in the Select (colum Value) is not giving me any data on the spreadsheet, just a blank cell. I have other colums with the same configuration but not allowing multiple choices and in the spreadsheet appears the information. thanks for your tips.
Multi select columns return array of data. You would need to write expressions to normalize them and put them into the excel file. I do not have a video reference on it.
Hi Reza - thank you again for such a great tutorial! Can this work where some of the columns of my sharepoint list are Rich Text format? I've struggled with this in the past for exports - there are work arounds (using functions in preview in PowerAutomate) but they fail often.
Hi Reza, thank you very much for covering this topic. I need to include some variable data as a heading at the top of my Excel file (e.g. "Employee report for Joe Bloggs : Quarter 3, 2004" - which variables are basically my Power App filters). Is this possible, and if so then at which point of the flow can such additional data be pulled in and how? Thank you again. Everything you share is so clear and practical.
Thanks for the compliments. think it may be possible but something I would have to try to know the steps. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hey Reza, any idea if possible a recent update from Microsoft, change to power flow or something may have caused the export flow to break? I had this working perfectly, applied 'create table' action. All was great! A few weeks went by and I went to test this and the flow is failing at the last 'Send an HTTP request' step. Error: "The requested resource doesn't exist". Have you ran this flow recently? Is this something you've seen before?
another common scenario, if we want to filter gallery and export data as pdf using power bi report builder, we need videos using power bi report builder and power apps together like printing invoices and more, its very important
Hello Reza, your videos are really usefull and pragmatic, many time thanks. 1 question related to this video: In section 17:50 you used collection colQuery - but not really clear for me wher did you create it? Anyway: for now the export works really well so far, I am struggling a bit with setting the filters, that the reason why I am asking for colQery. Thanks Adam
I create it at 18:16. 17:50 - I am clearing the collection beforehand. If you follow steps in video end to end it will work. If you need access to the entire app and flow, I have shared the same with channel members in Gold or Silver tier.
I had the same case, what I did was to omit the use of the collection and use directly the filter as string. If( !IsBlank(SearchText.Value), Set( v_url, ExportToExcel.Run(“startswith(Org,' ‘ &SearchText.Value & ’')”), Set( v_url, ExportToExcel.Run(” ‘’).f_url ) )
Check the graph api documentation for the api endpoint for creating excel in SharePoint. I have not tried it, hence do not know the exact api endpoint.
Great video! I’ve watched it multiple times and followed you step by step. I’m having an issue with the data loading in the excel doc when it’s opened. Any recommendations?
I have not faced any issues with it, hence not sure. Video description has details on how to download entire solution (members only - check description for details) I would suggest giving that a try.
Hi Reza - thank you for the awesome tutorial videos. Can you share with me what software you use to handle pan / zoom when recording your screen? I'd like to learn to do this too.
Hi Reza, thank you so much for the tutorial! It perfectly covered the request I received from my client. I just have one question. The button "Open file" is visible after few seconds. Is the visibility affected by some timer or is there function/variable that verifies if the file has been created?
@@RezaDorrani Thank you for the response. I was not familiar with this. I needed to publish the app so I eventually just add a parameter to the trigger called "Succeeded" and when the flow is at the end, the value changes to "true" and this is the condition of button visibility. But I will look in to your possibility. Thanks again!! Your tutorials always speed up my creation process :-)
10:48 What about if the file cannot be in OneDrive and it must be in SPO. Can this work replacing the OneDrive bit with SPO and what would the expression be? Would be great if you can answer this because I can't use work OneDrive. All records must reside within SPO only. Would be great to get a response on this! Thanks again for an awesome video
it's such helpful video! can I ask how to amend the formula in the onselect property if I also have two datepicker columns for due date range? Thank you very much!
OK. Partially solved. I know how to filter: "children/Title eq '" & TextInputCanvas6_1.Value & "'" But I can't manage to view the values in excel. I don't know how to use the select in a multichoice column to concatenate all the values of the selected values of the multi-choice colum... any ideas?
Possible but the graph api would be different for that and may also require premium action to call it as there is no call graph api for SharePoint action. Check graph api documentation.
Thank you for creating such informative videos; they've been incredibly helpful! I’m working on an app that uses a Data verse table populated by a dataflow from Snowflake, which contains 1 million rows. Users need to fill out questionnaires for each row, and the input is saved in a SharePoint list with columns like ID, country, Status, Team, and so on. My customer wants both the Data verse data and the user-inputted values exported to CSV. Is this feasible? I’d really appreciate your insights!
Most welcome! I'm not sure of the options with your scenario as it is not something I have come across or have experience with. I recommend posting your query on forums in case someone has done something similar community.powerplatform.com/
I did a video on export collection data. Same logic is used here. Check my older videos on exporting data. Video description also includes details on how to download the solution (members only)
Any thoughts on how to accomplish creating a hyperlink in the Excel table from a collection? Running into issues with the '=' and double quotes trying to make it happen.
This is not something I have tried, hence not sure of the options. I recommend posting your query on forums in case someone has done something similar community.powerplatform.com/
Many thanks Reza for your very usefull video. I'm facing an issue. the EXCEL file generated is empty. I have only the title of the Columns but no data. What could be the issue?
I have not experienced the mentioned issue, hence not sure whats the cause for your issue. You can try downloading the solution shown in video (members only - check video description for details)
Hi Reza, Thanks for the great video!! I'm having an issue with the flow. When I'm running it I'm able to generate the excel but others are getting a corrupted file and not able to open it. Would you be able to help?? Thanks again
@RezaDorrani thanks ! I will give it a shot. My error is because of excel file being corrupted and not due to data source but will try and maybe let you know
The data is stored in SharePoint. One of the column save data in JSON format. Is it possible to extract the JSON into multiple column and then write into Excel?
Hi Rezza, thanks for the video. I have a question what do you think is the problem. I was able to generate and display the excel file all but why it is showing no DATA. I stop and select ALL
I have not experienced the mentioned issue, hence not sure whats the cause for your issue. You can try downloading the solution shown in video (members only - check video description for details)
@@RezaDorrani Hi Reza, I was able to generate the values and display them in Excel Online. However, only I can export, while my colleagues cannot. Could this be an issue related to the access permissions of the Power Automate flow?
Hi Raza ! amazing videos as usual , I tried to apply that on Dataverse and it works exporting all data but when filtering and after many tries it export empty excel sheet ! any recommendation ?
I have not experienced any issues with it, hence not sure of the cause for empty data in your scenario. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
The video is the best reference I have. Video description has details on link to download entire solution (members only - check video description for details)
Hi Reza - I'm having an issue when I try to create colQuery.... if I hard code the ODATA query it works perfectly but when I start to add Clear(colQuery) it is not recognised - do I need to initialise the collection elsewhere or should this work?
I encountered an error while saving the flow at the "Create a File" step in OneDrive. The issue seems to be due to the "File Content" field being left empty. @Reza, Could you please assist with resolving this?
Video description has link to download entire solution (members only - check description for details) I would suggest giving that a try. As for the issue mentioned, I have not experienced it and hence not sure what the cause for it could be.
@@RezaDorrani As the "File Content" field is required, it will result in an error if left empty, which seems to be the issue we are encountering in the flow. Could you kindly confirm if we should provide specific content for this field? Thank you for your attention to this matter.
Hi Reza, do you have a video relating to copying a large data from excel and paste to another excel workbook using powerautomate? Badly need thw tutorial
Hello Reza, this method is not working for other users than the owner of the flow because the onedrive action will create the file in their personal onedrive and create table action can't access that file. I also tried to use sharepoint instead of onedrive, but I can't figure it out how to configure the Uri. Your advice will be very much appreciated.
Hi Rezza, will this also work if the data is in list format or choice in Dataverse table? Will it show the actual text (Apple or Banana) instead of the numerical value of the date (e.g. 1 = Apple, 2 = Banana and so on ) Thank you so much for this great video more powers, followers and blessing to come to you!
Hi Reza, thank you! But, no matter what I do, I cannot get my flow for exporting collections to behave like yours. In my Select action, I cannot find the specific fields as yours does. Even when I download your solution, and look into your flow, in the dynamic content adding dialogue, I cannot find those field names there. All I see are "outputs" from the JSON data Compose action. What am I doing wrong here?
In that select function in flow for collections, you can use expressions to get data for specific columns for collection. Since you have the flow downloaded as a member, simply hover over the columns picked in select action in flow and you can see the expressions behind it. It’s probably item()?[‘columnname’]
Hello Reza, First of all, thank you for your great effort. secondly, I've a problem with one of the exported columns from sharepoint to excel is numbers which excel manipulates the data in this column (last digit is converted to 0). the question is, how to avoid this while exporting the data from sharepoint in this powerautomate flow?
Hi I followed through the whole video (without the filters, i do not need those), but my export file is empty. I only have the column names, but no content. If i do a flowcheck i do not get any errors. Where should i look for errors?
I have not experienced the mentioned issue, hence not sure whats the cause for your issue. You can try downloading the solution shown in video (members only - check video description for details)
Hi Reza, Wonderful video. I have created the flow and its working perfectly for me, but when someone else is trying to run the flow from powerapps....its throwing an error saying - resource not found in the excel (create table) connector. I'm really not able to fix the issue, can you hlp me on this
Yes, check the recent comments. You would need to make the "Create Table" action dynamic so it points to the Onedrive of the user calling the flow from power apps.
Hello, Reza. I am encountering a problem where my data are not showing only the column names on the exported excel. Upon checking PowerAutomate, the error is in the 'Send an HTTPS request'. What could be the possible error? Thank you so much for making these contents!
I have not experienced the mentioned issue, hence not sure whats the cause for it. You can try downloading the solution shown in video (members only - check video description for details)
Excellent content. Thank you very much. I tried to replicate it in my scenario, but when I do a search using a search input, the export to Excel appears empty. I noticed that in the flow, in addition to not bringing anything, the http request step showed me this message: Action 'Send_an_HTTP_request' failed: The number of rows or columns in the input array does not match the size or dimensions of the range. Any ideas?
Most welcome! Video description has details of link to download entire solution (members only - check description for details) I would suggest giving that a try as I have not experienced the mentioned issue and not sure how I can help.
I would have to try it out to know the steps. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
I have not experienced the mentioned issue, hence not sure whats the cause for your issue. You can try downloading the solution shown in video (members only - check video description for details)
Hey Reza, I replicated your video I added users as run only users to the flow, when they try to run the flow it is failing to create the table with the error "The server did not receive a response from an upstream server". Do you know what could be causing?
Hello Reza! I tried using the flow at my end. On Run, I get an error under the action 'Send_an_HTTP_request' and it states 'The response is not in a JSON format' How to handle this ? Regards
I have not experienced the mentioned issue, hence not sure whats the cause for your issue. You can try downloading the solution shown in video (members only - check video description for details)
Hi, what's the code inside the Open File button? I tried this code and it didn't give me any errors but I can't open it because I don't know the code in there
Code is simply to launch that file link. I have not experienced the mentioned issue, hence not sure whats the cause for your issue. You can try downloading the solution shown in video (members only - check video description for details) Note - you will need a premium license to install the flow shared as I use 100000 pagination limit
Thank you for the great video Reza! I am not sure why I am facing issue with Send an Http request , the action fails with "Encountered internal server error." :(
Most welcome! Video description has link to download entire solution (members only - check description for details) I would suggest giving that a try. As for the issue mentioned, I have not experienced it and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorraniI remember you used send an http request to sharepoint action in one of your video to bulk export, but now couldn't locate that... Im serching that for many days...
I have made videos on pipelines and solutions. Admin/Governance is not something that everyone will have access to and is specific to certain sec roles.
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.
Hello Reza I have migrated my plan to per user in power automate but still after 600 flows I am getting error that only 600 flows allowd in per user what I need to do I need to create 1900 flows.
Great video Reza, but I can't get mine to work. The file is created by when I try to create the table it fails with a message "The resource could not be found". Has anyone seen this? I'm sure it's a permissions thing somewhere, but I'm running this flow as myself (no service accounts or anything weird).
I'll post on the forum and tag this video, just in case anyone else has seen this....but where I work, we can't get this working. Having said that...I did actually get it working on another application, again, only for myself in that case, so I can absolutely see the benefit of this approach over the "Add a Row into a Table" approach, as the HTTP way is vastly quicker.
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani Can you Please let me know if I take membership program SILVER Will I be eligible to download course content of any video. as Gold is too costly for me from India
@@rishisharma1066 Training videos and course content is ONLY for GOLD members. What I share in my regular videos, that is available for both SILVER and GOLD.
Thanks for the video. I created a flow based on your sharing and ran it successfully myself. however, when someone else ran it, it's always showing errors. I checked the flow history, the error is in 'Create Table' step and error message is: Action 'Create_table' failed: The request is forbidden by Graph API. Error code is 'accessDenied'. Error message is 'Access denied'. Can you please kindly help to coach me how to fix that error? thanks again!!!
I have not experienced the mentioned issue, hence not sure whats the cause for your issue. You can try downloading the solution shown in video (members only - check video description for details)
Welcome! Did you also share the flow with other user as run-only permissions? I have not come across this issue with other users, hence can only make a guess
@@RezaDorrani Hello Reze, you're really the best and actually I learned a lot from you... I also have the same issue as @kwesi_AI with my colleagues, they have a connection problems and think that the "Send an HTTP request" is a premium, but I found that its just standard and didn't need any additional licesens. I'm already sharing the flow with them . I also thought of "Modify Permission" in the Graph explorer. Is this required from all users to run the flow? Thank again
@RezaDorrani when i try to export the solution in my tenant i get this error (The solution file is invalid. The compressed file must contain the following files at its root: solution.xml, customizations.xml, and [Content_Types].xml. Customization files exported from previous versions of Microsoft Dynamics 365 are not supported.) i need to make the link of the graph and the expression code
@@RezaDorrani Yes it works with me now, thanks so much, but I have an issue I need to show the attachment column contents in the excel when exported but I found the result of this column (TRUE OR FALSE)
@mohamedmasoud8564 I have not done any work with attachments column. That's a file. You would have to get the file content and post it in excel probably.
If you create the flow and run it from Power App, it works perfectly, but when someone else is trying to run the flow from powerapps....its throwing an error saying - resource not found in the excel (create table) connector.
FIX: ruclips.net/user/postUgkxvQfTWNyuJWokAHCvM-NBazBXVnUtLJER?si=MAE660wkk1842wz6
I just had an ask for something like this in one of my apps, so I went ahead and implemented this. Following directions in the video exactly it worked like a charm, first try. Thank you for the incredible solution and thorough directions.
Glad it helped!
Wonderful video...is EXACTLY what I need at work- just had a meeting with boss lady today about this is exact topic. Thanks Reza
You are so welcome! I was trying for long on how to best handle this common scenario and finally got it.
@@RezaDorrani you nailed it dude. I'm a proud subscriber...I don't interact much...but dude...really hit the nail square on the head for me.
And no premium license? STFU! Ur a blessing to the Data Driven
@@ericmild4050 Thanks so much for the compliments. Made my day!
Same here Dude, thank you so much Reza 😍
Hi Reza ,
I just wanted to take a moment to thank you for the excellent video on how to export large datasets from Power Apps to Excel using Power Automate. The content was fantastic and incredibly helpful! The explanation was clear, and the approach was very practical, which will definitely help streamline my processes.
I’d like to make a suggestion: it would be great if you could create a similar video, but using Dataverse as the data source. Additionally, it would be really helpful to see how you handle Choice, Lookups, and other data types within Dataverse. I’m sure many of us working with this data would greatly benefit from a detailed explanation.
Once again, congratulations on the great work, and I look forward to more amazing content from you!
Thanks so much.
My rule for topic suggestions is set - "Every 6-8 months I ask for topic suggestions on community tab of my channel. Make sure to post this idea there. If it gets max votes, I will add the topic to my backlog"
Thanks a lot for this video, i was struggling with time out for 2 days, and this solves the problem. I just changed the source of data cause i´m using parsed data from a collection, and it worked fine. Thumbs up.
Great to hear!
Reza bhai, thank you so much for your videos, not only this all the videos you uploaded regarding power apps and work flows. you made my day
Thanks a ton
This is great Reza, thanks so much. An extension to your last week's video on exporting to excel via Graph, this video incorporates calling it via Power Apps. I did not know Flow must respond within 2 min or it errors out in the app so that was something new I learned. I'll be putting these in to action in my apps. 👍👍
You're most welcome!
This is an enormous piece of gold legend!!! Keep it up
Thank You!!!
@@RezaDorrani mate!! When my end-users are clicking on export the flow failed saying Action 'Create_table' failed: The request is forbidden by Graph API. Error code is 'accessDenied' I don't find any solution... Any idea legend?
@@johanynavarro8065 Its because the create table action needs onedrive id there. You would need to look for options to set those values dynamically based on user calling the flow.
@@RezaDorrani :(
All the best. You have helped me and everyone is power apps developers in the world ❤ thank you so much
Cheers 🎉❤
You're most welcome
Wow, you did it again... I have used power query to do this because there are 7 different filters i have to apply before downloading data... But this looks more prominent and quick.. Thanks again
Great 👍
This is impeccable work. I absolutely adore your videos!
Thank You so much
Great video again. I'm really liking this Graph method of dealing with large volumes of data movement. Will certainly be doing this a bit more. Thanks again for sharing as I thought you'll miss this week because of PPCC. 😂😄
I had already recorded this one prior to PPCC 😊
Amazing Reza just amazing i always get this "Can i export to excel" question now i know we can export large data its crazy thank you sir 👍
Yes you can! This has been something I have been trying since long to find an effective solution for.
Brilliant as always!
Thanks alot Reza for sharing these wonderful info.
Glad you enjoyed it!
Another amazing tutorial and I can use it in a current project! 👍🏽👍🏽 Small tip: You can use the utcNow() function with the format specifier 'F' utcNow('F') in place of the formatDateTime(utcNow(), 'F') .
Great tip!
Now I can optimize all my slow flows. Thanks for great video!
Great to hear!
This is really good trick ! I love it.
Only small problem in my opinion is that your solution use the share link of the file to open it. It is - i think - not a really good idea as it can give anybody in your organisation access to the file (if the link is shared). The better solution for me is to get the link of the file whithout sharing it (the file stay private). To achieve this, I used once again the api with me/drive/items/@{split(actions('Create_table')?['inputs']?['parameters']?['file'],'.')?[1]} endpoint. Then the result contains webUrl property which is the url to open the file which stay private ;)
I wanted to keep the video simple hence did not want to delve into link best practices but your point is spot on.
After 4 days of trying to find workarounds I saw your pinned comment :X Thanks tho'
Glad to hear the pinned comment helped.
Thanks Reza. Nailed it. Looks different but works the same.
Thanks so much
Your videos are very good
Thank you very much!
thankyou very much.
Thanks Reza, I didn’t know the Office365 Users connector could be used for that graph api call. That enables some more use-cases without premium connectors.
It is super powerful
Thank youuuu!!
Most welcome!
R.D you are great. love
great tutorial..
Thank you!
Thank you Reza
You’re most welcome
I can see you took membership. Can you Please tell are you able to download course content for any video. Please help and answer. from india
@@rishisharma1066 Check this for all questions around memberships ruclips.net/user/postUgkxOUKdBOVOWPTPRg68XbFrc2a_k8uFGas2?si=pqHiYhlJWjC-anE9
Thankyou very much Reza. It works for me. The only thing is that I have some Lookup columns in my List that alllows multiple choices per register, So when I called it in the Select (colum Value) is not giving me any data on the spreadsheet, just a blank cell. I have other colums with the same configuration but not allowing multiple choices and in the spreadsheet appears the information. thanks for your tips.
Multi select columns return array of data. You would need to write expressions to normalize them and put them into the excel file. I do not have a video reference on it.
We are waiting your tutorial. 🎉
Hope you enjoyed this one
Hi Reza - thank you again for such a great tutorial! Can this work where some of the columns of my sharepoint list are Rich Text format? I've struggled with this in the past for exports - there are work arounds (using functions in preview in PowerAutomate) but they fail often.
I have not tried with rich text hence not sure of the limitations
Hi Reza, thank you very much for covering this topic. I need to include some variable data as a heading at the top of my Excel file (e.g. "Employee report for Joe Bloggs : Quarter 3, 2004" - which variables are basically my Power App filters). Is this possible, and if so then at which point of the flow can such additional data be pulled in and how?
Thank you again. Everything you share is so clear and practical.
Thanks for the compliments.
think it may be possible but something I would have to try to know the steps. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hey Reza, any idea if possible a recent update from Microsoft, change to power flow or something may have caused the export flow to break? I had this working perfectly, applied 'create table' action. All was great! A few weeks went by and I went to test this and the flow is failing at the last 'Send an HTTP request' step. Error: "The requested resource doesn't exist". Have you ran this flow recently? Is this something you've seen before?
I have not experienced this issue
Thank you I appreciate your reply. Something must have change at my org. Awesome video!
another common scenario, if we want to filter gallery and export data as pdf using power bi report builder, we need videos using power bi report builder and power apps together like printing invoices and more, its very important
I understand the importance but my current focus is more on power apps and automate. No plans for pbi report builder videos.
Really Appreciate your teaching if you can suggest same for sql database will be great 😅😇
Thanks so much. I have done no work with sql and power platform.
Hello Reza,
your videos are really usefull and pragmatic, many time thanks.
1 question related to this video: In section 17:50 you used collection colQuery - but not really clear for me wher did you create it?
Anyway: for now the export works really well so far, I am struggling a bit with setting the filters, that the reason why I am asking for colQery.
Thanks
Adam
I create it at 18:16.
17:50 - I am clearing the collection beforehand.
If you follow steps in video end to end it will work. If you need access to the entire app and flow, I have shared the same with channel members in Gold or Silver tier.
@@RezaDorrani thank you. hope that I get great info such as "only" bronz member...
@@adambobor9039 I can only share what I remember of the video. The download options are not for bronze members.
I had the same case, what I did was to omit the use of the collection and use directly the filter as string.
If( !IsBlank(SearchText.Value),
Set(
v_url,
ExportToExcel.Run(“startswith(Org,' ‘ &SearchText.Value & ’')”),
Set(
v_url,
ExportToExcel.Run(” ‘’).f_url
)
)
Hi Reza , great job and thank you for the new video in multi language
I have a question , where does the ´colQuery’collection come from at 17:49
It does not exist at that point. Right after that step, I create that collection.
Can you share the code you used to define your two variables?
@@MikeB-i4o You can download the entire solution shown in video (members only - check video description for details)
Great video as always Reza! Just had a question, what should be the Api endpoint if we are creating the excel file in a SharePoint document library?
Check the graph api documentation for the api endpoint for creating excel in SharePoint. I have not tried it, hence do not know the exact api endpoint.
Great video! I’ve watched it multiple times and followed you step by step. I’m having an issue with the data loading in the excel doc when it’s opened. Any recommendations?
I have not faced any issues with it, hence not sure.
Video description has details on how to download entire solution (members only - check description for details)
I would suggest giving that a try.
Hi Reza - thank you for the awesome tutorial videos. Can you share with me what software you use to handle pan / zoom when recording your screen? I'd like to learn to do this too.
Camtasia
Hi Reza, thank you so much for the tutorial!
It perfectly covered the request I received from my client.
I just have one question. The button "Open file" is visible after few seconds. Is the visibility affected by some timer or is there function/variable that verifies if the file has been created?
The flow when completes - it returns control back to power apps - that's when I show that button.
@@RezaDorrani Thank you for the response. I was not familiar with this. I needed to publish the app so I eventually just add a parameter to the trigger called "Succeeded" and when the flow is at the end, the value changes to "true" and this is the condition of button visibility. But I will look in to your possibility. Thanks again!! Your tutorials always speed up my creation process :-)
Hi Resa, I love that video. I have one question : why don't you use split(outputs('Create_a_file')?['body/Id'],'.')[1] to get the file id ?
Try that and check
10:48 What about if the file cannot be in OneDrive and it must be in SPO. Can this work replacing the OneDrive bit with SPO and what would the expression be? Would be great if you can answer this because I can't use work OneDrive. All records must reside within SPO only. Would be great to get a response on this! Thanks again for an awesome video
I'm sure there would be graph api calls for SharePoint. You would need to check that. It's not something I have explored.
@@RezaDorrani Ok thanks Reza! Keep up the amazing work :)
Reze,If I am a subscriber to the M365 Business Basic plan, can I use the solution you introduced, especially the use of the Graph API?
All actions shown in this video use standard connectors.
Always best to test it out and check.
it's such helpful video! can I ask how to amend the formula in the onselect property if I also have two datepicker columns for due date range? Thank you very much!
I would have to try that out to know the exact formula. Check my video on data query for flows - you will get an idea of the filter scenario
@@RezaDorrani I think I figure it out, Set(
VarUrl,
Blank()
);
Clear(colQuery);
If(
!IsBlank(TextInputCanvas3.Value),
Collect(
colQuery,
"startswith(Title,'" & TextInputCanvas3.Value & "')"
)
);
If(
!IsBlank(DropdownCanvas5.Selected.Value),
Collect(
colQuery,
"Task result Status eq '" & DropdownCanvas5.Selected.Value & "'"
)
);
If(
!IsBlank(DatePickerCanvas3.SelectedDate),
Collect(
colQuery,
"DueDate ge '" & Text(DatePickerCanvas3.SelectedDate) & "'"
)
);
If(
!IsBlank(DatePickerCanvas4.SelectedDate),
Collect(
colQuery,
"DueDate le '" & Text(DatePickerCanvas4.SelectedDate) & "'"
)
);
// Combine and send the query
Set(
VarUrl,
Exportexcel.Run(
Switch(
CountRows(colQuery),
0, "",
Concat(colQuery, Value, " and ")
)
).url
); hope this will work
Great video Reza! Thanks! Is it possible to filter a multichoice column?
In power automate? yes
Check odata query documentation
OK. Partially solved.
I know how to filter:
"children/Title eq '" & TextInputCanvas6_1.Value & "'"
But I can't manage to view the values in excel. I don't know how to use the select in a multichoice column to concatenate all the values of the selected values of the multi-choice colum... any ideas?
@@hernanjc probably expressions
May be join function
Can one use sharepoint instead on onedrive for business to create the excel file and table
You could, but here the idea is for each app user to create excel files on demand. OneDrive is a better option.
Nice video,just one question can we update the table in sharepoint library folder instead of one drive?
Possible but the graph api would be different for that and may also require premium action to call it as there is no call graph api for SharePoint action. Check graph api documentation.
Thank you for creating such informative videos; they've been incredibly helpful! I’m working on an app that uses a Data verse table populated by a dataflow from Snowflake, which contains 1 million rows. Users need to fill out questionnaires for each row, and the input is saved in a SharePoint list with columns like ID, country, Status, Team, and so on. My customer wants both the Data verse data and the user-inputted values exported to CSV. Is this feasible? I’d really appreciate your insights!
Most welcome!
I'm not sure of the options with your scenario as it is not something I have come across or have experience with.
I recommend posting your query on forums in case someone has done something similar community.powerplatform.com/
Hi, Reza Dorrani, my question is, how did you create a collection called "ColQuery" and how did you used it in the script to export the data
I did a video on export collection data. Same logic is used here. Check my older videos on exporting data.
Video description also includes details on how to download the solution (members only)
Hi Reza, Can we use SharePoint location to create and update files instead of one drive?
Possible but not something I have tried
Any thoughts on how to accomplish creating a hyperlink in the Excel table from a collection? Running into issues with the '=' and double quotes trying to make it happen.
This is not something I have tried, hence not sure of the options.
I recommend posting your query on forums in case someone has done something similar community.powerplatform.com/
does this also work for choices (multi select) items column on power apps/SharePoint? i tried but no values on the exported excel file
It should work but will require a lot more work as the response would be an array of data. Not something I have tried or have a video reference for.
Thank you Reza for this wonderful video. However, how can i use date range to filter and export to excel with your coding?
I have done videos on data queries showcasing date ranges. You can use the technique shown in those videos.
Thanks for this video. If i have a table with columns name that is over 20 and i want to dynamically pass the column names, how can i do that?
It would best to organize them in the flow as shown in video. I have not explored option for dynamic name passing.
Sir, can we add the attachments also in the excel sheet?
Not something I have explored, hence not sure
Reza Dorani, thank you very much for your videos, but I couldn't export from a TextInputSearch filter or a DatePicker. Can you help me
You can try downloading the solution shown in video (members only - check video description for details)
Many thanks Reza for your very usefull video. I'm facing an issue. the EXCEL file generated is empty. I have only the title of the Columns but no data. What could be the issue?
I have not experienced the mentioned issue, hence not sure whats the cause for your issue.
You can try downloading the solution shown in video (members only - check video description for details)
Thank for your quick feedback. I will go deeper into the root cause analysis. But again, thanks a lot for your very interesting and clear videos 👏👏👏👏
i am facing the same issue. Were you able to figure out the problem?
Hey Reza, have you tried with excel scripts ?
No
Hi Reza,
Thanks for the great video!! I'm having an issue with the flow. When I'm running it I'm able to generate the excel but others are getting a corrupted file and not able to open it. Would you be able to help??
Thanks again
Check PINNED COMMENT on video
@RezaDorrani thanks ! I will give it a shot. My error is because of excel file being corrupted and not due to data source but will try and maybe let you know
Video description has link to download entire solution (members only)
The data is stored in SharePoint. One of the column save data in JSON format. Is it possible to extract the JSON into multiple column and then write into Excel?
Probably yes but not something I have tried
Hi Rezza, thanks for the video. I have a question what do you think is the problem. I was able to generate and display the excel file all but why it is showing no DATA. I stop and select ALL
I have not experienced the mentioned issue, hence not sure whats the cause for your issue.
You can try downloading the solution shown in video (members only - check video description for details)
@@RezaDorrani Hi Reza, I was able to generate the values and display them in Excel Online. However, only I can export, while my colleagues cannot. Could this be an issue related to the access permissions of the Power Automate flow?
@@jamelludwigedma4405 please check pinned comment on video
Hi Raza ! amazing videos as usual , I tried to apply that on Dataverse and it works exporting all data but when filtering and after many tries it export empty excel sheet ! any recommendation ?
I have not experienced any issues with it, hence not sure of the cause for empty data in your scenario. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
I'm having trouble exporting collection data to Excel. Can you explain this in more detail? Thank you
The video is the best reference I have. Video description has details on link to download entire solution (members only - check video description for details)
Hi Reza, Good video, How do I get the column from the table in a collection without filtering
Why do you want to load it in collection?
Hi Reza - I'm having an issue when I try to create colQuery.... if I hard code the ODATA query it works perfectly but when I start to add Clear(colQuery) it is not recognised - do I need to initialise the collection elsewhere or should this work?
Im not sure why you would be running into an issue. Video description has details on link to download entire solution (members only)
I encountered an error while saving the flow at the "Create a File" step in OneDrive. The issue seems to be due to the "File Content" field being left empty.
@Reza, Could you please assist with resolving this?
Video description has link to download entire solution (members only - check description for details)
I would suggest giving that a try.
As for the issue mentioned, I have not experienced it and hence not sure what the cause for it could be.
@@RezaDorrani
As the "File Content" field is required, it will result in an error if left empty, which seems to be the issue we are encountering in the flow.
Could you kindly confirm if we should provide specific content for this field?
Thank you for your attention to this matter.
@@changalrayudu3151 Check video again. I do enter a space in the file content.
Hi Reza, do you have a video relating to copying a large data from excel and paste to another excel workbook using powerautomate? Badly need thw tutorial
I do not have a video on this
@@RezaDorrani do you have any video similar to what i'm aiming for? 🥲
@@paulinesalas6064 No. I would suggest checking on forums community.powerplatform.com/
Hello Reza, this method is not working for other users than the owner of the flow because the onedrive action will create the file in their personal onedrive and create table action can't access that file. I also tried to use sharepoint instead of onedrive, but I can't figure it out how to configure the Uri. Your advice will be very much appreciated.
Check pinned comment on video
Hi Rezza, will this also work if the data is in list format or choice in Dataverse table? Will it show the actual text (Apple or Banana) instead of the numerical value of the date (e.g. 1 = Apple, 2 = Banana and so on )
Thank you so much for this great video more powers, followers and blessing to come to you!
Yes, as you can always map the special type of columns to their text values in flow
Hi Reza, thank you!
But, no matter what I do, I cannot get my flow for exporting collections to behave like yours.
In my Select action, I cannot find the specific fields as yours does.
Even when I download your solution, and look into your flow, in the dynamic content adding dialogue, I cannot find those field names there. All I see are "outputs" from the JSON data Compose action.
What am I doing wrong here?
In that select function in flow for collections, you can use expressions to get data for specific columns for collection.
Since you have the flow downloaded as a member, simply hover over the columns picked in select action in flow and you can see the expressions behind it.
It’s probably item()?[‘columnname’]
Great news, Could I implement something similar to update a large SharePoint list from PowerApps? Thanks for the support
Technique with SharePoint is different. I have that as a video idea in my backlog as of now.
@@RezaDorrani Thanks a lot. I will be waiting, best regards
Hello Reza,
First of all, thank you for your great effort.
secondly, I've a problem with one of the exported columns from sharepoint to excel is numbers which excel manipulates the data in this column (last digit is converted to 0).
the question is, how to avoid this while exporting the data from sharepoint in this powerautomate flow?
I’m not sure if this technique supports formatting.
Hi
I followed through the whole video (without the filters, i do not need those), but my export file is empty.
I only have the column names, but no content.
If i do a flowcheck i do not get any errors.
Where should i look for errors?
I have not experienced the mentioned issue, hence not sure whats the cause for your issue.
You can try downloading the solution shown in video (members only - check video description for details)
Hi Reza,
Wonderful video.
I have created the flow and its working perfectly for me, but when someone else is trying to run the flow from powerapps....its throwing an error saying - resource not found in the excel (create table) connector. I'm really not able to fix the issue, can you hlp me on this
Yes, check the recent comments. You would need to make the "Create Table" action dynamic so it points to the Onedrive of the user calling the flow from power apps.
Hello, Reza. I am encountering a problem where my data are not showing only the column names on the exported excel. Upon checking PowerAutomate, the error is in the 'Send an HTTPS request'. What could be the possible error? Thank you so much for making these contents!
I have not experienced the mentioned issue, hence not sure whats the cause for it.
You can try downloading the solution shown in video (members only - check video description for details)
Hello, I am facing the same issue. Were you able to resolve it?
Hi Raza,
Need vedios on Dataverse backup, restore, Archive, cleaning
These ops are mainly performed by admins. Very few folks will even have access to do that.
Excellent content. Thank you very much.
I tried to replicate it in my scenario, but when I do a search using a search input, the export to Excel appears empty. I noticed that in the flow, in addition to not bringing anything, the http request step showed me this message: Action 'Send_an_HTTP_request' failed: The number of rows or columns in the input array does not match the size or dimensions of the range.
Any ideas?
Most welcome!
Video description has details of link to download entire solution (members only - check description for details)
I would suggest giving that a try as I have not experienced the mentioned issue and not sure how I can help.
How Can we do it for from date to date filter
I would have to try it out to know the steps. I will recommend checking or posting your query on forums in case someone has done something similar
community.powerplatform.com/
Sir, while running this flow, I'm getting the 'internal server error' in send an http request action . Could you tell me how to resolve this issue?
I have not experienced the mentioned issue, hence not sure whats the cause for your issue.
You can try downloading the solution shown in video (members only - check video description for details)
Hey Reza, I replicated your video I added users as run only users to the flow, when they try to run the flow it is failing to create the table with the error "The server did not receive a response from an upstream server". Do you know what could be causing?
Check the recent comments on this
Hello Reza! I tried using the flow at my end. On Run, I get an error under the action 'Send_an_HTTP_request' and it states 'The response is not in a JSON format'
How to handle this ?
Regards
I have not experienced the mentioned issue, hence not sure whats the cause for your issue.
You can try downloading the solution shown in video (members only - check video description for details)
Hello Reza. There happened a column name issue when making the flow run. Issue rectified and flow is like jhakaas.
Thank you and as always 👍
Ekdum jhakaas!
Well done
Hi, what's the code inside the Open File button?
I tried this code and it didn't give me any errors but I can't open it because I don't know the code in there
Code is simply to launch that file link.
I have not experienced the mentioned issue, hence not sure whats the cause for your issue.
You can try downloading the solution shown in video (members only - check video description for details)
Note - you will need a premium license to install the flow shared as I use 100000 pagination limit
Sorry, I found it after rewatching the tutorial.
I getting a bad gateway error though..
I would suggest you try the solution shared. I have not experienced the issues you are mentioning.
Thank you for the great video Reza! I am not sure why I am facing issue with Send an Http request , the action fails with "Encountered internal server error." :(
Most welcome!
Video description has link to download entire solution (members only - check description for details)
I would suggest giving that a try.
As for the issue mentioned, I have not experienced it and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Graph API is restricted in my organisation's environment, is there any workaround to bulk export to excel from sharepoint list?
I'm not aware of other workarounds
@@RezaDorraniI remember you used send an http request to sharepoint action in one of your video to bulk export, but now couldn't locate that... Im serching that for many days...
I dont remember or keep track of my own videos. Everything should be organized in playlists.
Hi Reza, my flow could able to genenerate the file and table within excel but couldnt able to auto populate the excel
I have not experienced the mentioned issue.
You can try downloading the solution shown in video (members only - check video description for details)
Need vedios on powerapps administration/Governance and Deployment, pipes
I have made videos on pipelines and solutions.
Admin/Governance is not something that everyone will have access to and is specific to certain sec roles.
@@RezaDorrani Is it possible to deploy a solution (un managed) from Dev environment to Test environment as un managed...?
@@shivasrk4014 Not via pipelines as it currently only supports managed.
Best practice is to deploy as managed.
Can you make vedio on sharePoint list export to excel attachment into the mail using power Automate
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.
Hi Reza, how do we write back the dates according to the Indian Time format.. Currently it is writing back in GMT format.
You would probably need to do format conversion prior to writing it to excel. I dont have a video reference on this.
Hello Reza I have migrated my plan to per user in power automate but still after 600 flows I am getting error that only 600 flows allowd in per user what I need to do I need to create 1900 flows.
Build flows inside Solutions
Great video Reza, but I can't get mine to work. The file is created by when I try to create the table it fails with a message "The resource could not be found". Has anyone seen this? I'm sure it's a permissions thing somewhere, but I'm running this flow as myself (no service accounts or anything weird).
I'll post on the forum and tag this video, just in case anyone else has seen this....but where I work, we can't get this working.
Having said that...I did actually get it working on another application, again, only for myself in that case, so I can absolutely see the benefit of this approach over the "Add a Row into a Table" approach, as the HTTP way is vastly quicker.
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani Posted! Thanks.
@@paulbruen3108 Hey Paul, I have exacly the same issue...
Have you found a solution to this problem?
Gracias
Me puedes compartir la expresión de URI
I will be sharing the entire App and flows with SILVER and GOLD members shortly
@@RezaDorrani Can you Please let me know if I take membership program SILVER Will I be eligible to download course content of any video. as Gold is too costly for me from India
@@rishisharma1066 Training videos and course content is ONLY for GOLD members.
What I share in my regular videos, that is available for both SILVER and GOLD.
Thanks for the video. I created a flow based on your sharing and ran it successfully myself. however, when someone else ran it, it's always showing errors. I checked the flow history, the error is in 'Create Table' step and error message is: Action 'Create_table' failed: The request is forbidden by Graph API. Error code is 'accessDenied'. Error message is 'Access denied'. Can you please kindly help to coach me how to fix that error? thanks again!!!
Try checking the PINNED comment on video as well
whenever i export the table in excel is empty
I have not experienced the mentioned issue, hence not sure whats the cause for your issue.
You can try downloading the solution shown in video (members only - check video description for details)
Thank you Reza, it worked for me but when I share the app with other they get an error
Welcome!
Did you also share the flow with other user as run-only permissions?
I have not come across this issue with other users, hence can only make a guess
@@RezaDorrani Hello Reze, you're really the best and actually I learned a lot from you... I also have the same issue as @kwesi_AI with my colleagues, they have a connection problems and think that the "Send an HTTP request" is a premium, but I found that its just standard and didn't need any additional licesens. I'm already sharing the flow with them . I also thought of "Modify Permission" in the Graph explorer. Is this required from all users to run the flow? Thank again
@khaled0k0f No additional setup is needed, and the connectors used in video are standard licensed.
split(actions('Create_table')?['inputs']?['parameters']?[file],'.')?[1] comes up as invalid.
Not an issue I have come across. Video description has details on link to download entire solution (members only) - I would suggest giving that a try
Hello, you listed [file] incorrectly. Should be ['file'] - - split(actions('Create_table')?['inputs']?['parameters']?['file'],'.')?[1]
I am facing issue while creating Person column multiple choice field 😢😢😢😢
I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@RezaDorrani when i try to export the solution in my tenant i get this error (The solution file is invalid. The compressed file must contain the following files at its root: solution.xml, customizations.xml, and [Content_Types].xml. Customization files exported from previous versions of Microsoft Dynamics 365 are not supported.) i need to make the link of the graph and the expression code
Check the read me file please
@@RezaDorrani Yes it works with me now, thanks so much, but I have an issue I need to show the attachment column contents in the excel when exported but I found the result of this column (TRUE OR FALSE)
@mohamedmasoud8564 I have not done any work with attachments column. That's a file. You would have to get the file content and post it in excel probably.
@@RezaDorrani Ok , Thanks a lot