@@RezaDorrani Good morning Raza. I have a scenario like there will 500 coloumns in my share point list. I have a download button in my canvas aap. When I click download these records are downloaded in excel template format(for this I will take add rows into a table action (exce online business) iam used but it takes 15-20 mins to complete the flow) is there any alternate to download data from database using canvas&powerautomate flow?
@@khasimshaik2606 500 columns are too many. You need to look into redesigning the lists or selecting a better data source (relational database) to meet your needs. It would take time to generate your output because of so many columns. I have no solution for this.
Everything that Reza teaches us matters, collecting and structuring data is EXTREMELY important. I am in the middle of a Data Science program with MIT and the fist thing we do is to collect and clean data before any analysis. So pay extra attention what Reza says , it will make a hell of a difference later. Clean data is like drinking clean water. Thank you Reza!
Finally found this AMAZING video! I haven't found anyone else that address the creation of an Excel file from scratch as you have. THANK YOU! This is going to save me hours and hours!
I watched a few videos on this topic, but none were as clear and easy to follow as this one! I appreciate that you explained why you were doing each step as well. Thank you.
I don't know how but I can always find a video on your channel related to the problem I'm facing 😃...that means your content is 'real world problem solving content' thanks for your efforts
Hi Reza, your videos are definetly amongst the best that I've come across, just a tip, you might want to consider zooming in just a slight bit when making the video. Even on full screen I cant see some of the json code,so I have to go out the video to look for external content on google and then come back to the tutorial. Thank for the tone of effort that you put into these videos!!
Reza, this is super helpful. Just a quick question. I don't need the file name to be different every time this runs. Is that a problem? If I keep the file name the same(e.g updatedschedule.xlsx) will the file be automatically overridden?
@@RezaDorrani gave it a try and there is a snag. There is a 400 or 423 Error that occasionally happens when overwriting the same file in the directory which runs into the flow throwing an error and stopping. However, there is a workaround that several folks have pointed out. Some involved adding a loop until the lock is removed, while other's have a routine at the API server level to clear the lock immediately. All good solutions. Thanks again.
Awesome video. This has help me a lot. I was wondering if it was possible to use power query in excel with this method. For instance: when excel file is sent to an outlook email. Grab that file and use power query to clean data then create another file to email the cleaned data. Not sure if it’s possible. Thanks
Your videos are always super helpful, Reza!! One question - One of my SharePoint columns contains a link. I'd like to add that link to the resulting Excel file. What's the best way to extract the link and plug it into the Excel file? Thank you in advance!
Excelent video as always, I am a "Reza addict". always waiting for your next video. Personally most of the very long live events, not including the expressions series, are totally a waist of time for me. Thank you
Thank you for the video, i have one question. in the excel attached in the email i get one row all the time, even if there are more rows in de sharepoint list. How do i set the number of rows?
I have not come across any issue where its only 1 row all the time. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, all your videos are very helpful. Is it possible to export data from multiple collections to different sheets in the same excel ? If so, how to achieve that?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza, thank you for this video. It was just about perfect for my project I was working on. I do have a question for you (or anyone else who has solved this): When the data is brought into the newly created Excel file (based on the template I have), it formats the Excel table with the default formatting. This does not look good or even fit with the rest of the template I have created. Is there a way of either a) pre-formatting an Excel table and inserting my data into that table, or b) formatting the table as it gets created inside my file? Thank you!
Thanks for this video. Exactly what I am looking for. Instead of OneDrive for Business to store files, I used Sharepoint Library. The steps are similar to using OneDrive for Business connector. Works great This video also answered my question regarding dynamic table range. Great video!
Hi Jay, I am looking for something si,ilar to what you did, using Sharepoint instead of OneDrive, would you care sharing your flow ( provided there is no security data involved)?
Perfect tutorial, thanks for it. Do you happen to know how I can also export Vlookup column values? When I try to match them in the select step, there is an error at the end of the flow (Add a row into a table) saying that 'A value must be provided for item.' Thanks
Thanks, Reza. It was definitively a well-explained video over how to export to Excel. I have two questions: Is it possible to change the name of the exported Excel file to something (unique) more User-meaningful instead of the GUID? Do you have a similar video where the destination of the file is Sharepoint not OneDrive?
You could call the file anything you desire. I used guid to keep it unique. I do not have a SharePoint based video. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Wonderfully detailed! Is there a way, or do you have a video that instructs how to use date and choice inputs from the manual trigger to create a table? I wish to create an Excel table from instant Flow, being able to choose beginning date, ending date, and choice field selections. My attempts to incorporate this into the OData filter query fails. Any guidance is greatly appreciated. I may be trying to do the impossible 🤔
Hey Reza, your video tutorials have been super helpful for my project, but I've got a question. So, the thing is, I've got more than 1000 rows in my SharePoint list, but when I run my Flow automation, it's only grabbing 100 rows. Any idea how to fix this? Thanks again, by the way!
thanks a lot Reza !!! it works perfect :-) the only problem that I have is that instead of sending it per email I need to save the excel file into a Teams folder (and post the link there). I tried with "Post a message in a chat or channel" but I cannot attach the excel file like when sending by email. Would you have a solution for that ?
Thanks for watching and liking the video. For saving in teams folder, I guess you would need to use SharePoint actions since Teams backend is SharePoint. I don’t think post a message supports attachments. I would recommend to post your query on the forums at powerusers.microsoft.com in case someone has done something similar.
Awesome, tutorial Rezza, Thanks. I have a query though. I have made this flow as you have explained and have added a filter query, but I only seem to be getting the results of my filter query from the first 100 records in my sharepoint list. Is there a reason for this???
Thanks for this video. Is it possible however to dynamically loop through the columns of a table? Imagine we have an Excel that always has a properly formatted table, but we don't know the name of its columns nor the amount beforehand, apart from one column name that we know will always be present (not that we really care). Is it possible to copy some of these rows (let's imagine the 10th row and first) to a new table?
I am not sure about looping through columns (might be possible via graph api) and would have to try it out to provide guidance. I would recommend posting your query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani I had one question or request - The file name that comes as output is a mix of #'s and alphabets... Is there a way we can have the some naming convention for the file. In My flow, the column I am filtering is Name of Managers and I would like the excel to have a specific naming convention. In case you are able to clarify, I will be highlly obliged, other wise, I thank you for such a fantastic video.
Thank you for this video! After many trial and error, I was able to automate a queried dataset and export to Excel with your steps. However, I noticed the leading zeros disappear which was the reason for the export to Excel vs CSV. Do you know how the leading zeros can be retained? The queried data has leading zeros as a text format. Many thanks.
Im not aware of a workaround for leading zeros as I have not come across a scenario with it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thank you!! I actually just figured it out. The Excel Template, highlighted the entire worksheet and formatted to text then saved. Worked perfectly!!
Hi Reza, it's amazing and really useful. I've created the same flow for exporting an Excel report from SP List but encountered an error that the Excel file attached at the email is not openable. However, the same Excel file generated at the OneDrive folder is openable. I've 100% followed the steps and details as yours and now I can't resolve the issue. Hope you may help please!!! Thanks you very much. Raymond
Thanks so much! I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani Thanks for your advice and I've visited the website you suggested but sorry that I don't know how to post my issue there. Please can you provide me with some more guidelines. Thank you so much for your assistance!!!
Hi Reza, nice video thank you! I just have one question: is it possible to add more than one row at a time to an excel table? Because it takes too much time adding to the table many rows. Do you know if exists an alternative way?
You would need to look into excel api's if it allows bulk additions. I have not attempted that. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Great explanation! Do you have a video that explains when it is connected to SQ server? I want to connect to SQL server(Execute a SQL query(V2)), create a table in excel and send an email.
Excellent VIdeo Thank you so much am facing a issue with Multiselection dropdown field. when runt the flow, am getting below issue ."A value must be provided for item." Can you help where am worng
I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Thank you very much, learned a lot from your channel, I encountered a problem, if I have different fields, how to dynamically export different fields of SharePoint List
@@RezaDorrani Thank you very much for your reply. There is another SHAREPOINT LIST for the required fields. I plan to use removeproperty object to delete unnecessary fields, but I need to obtain the person list field
@@MMYGOGO Its possible but not something I have tried. Give it a try and if facing issues, then post the issue with screenshots on the forums at powerusers.microsoft.com
I used the API to list the fields of the SHAREPOINT LIST, and an error occurred while processing each field,show The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('LIST')' is of type 'Object'. The result must be a valid array.
Thanks Reza for the extremely useful video, I am trying to get the dropdown values of dataverse column, But getting the values of it, instead of text in excel file, Can you please suggest what action needs to be done to get dropdown text, instead of values?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Raza, Thank you very much , i want to do this process for different different Excel files. can we make select operation dynamic or can we use any other operation to make it dynamic?
You can write dynamic operations using expressions. I do not have a specific video for it though. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Nice video Reza! I'm trying to create an Export to Excel feature within Canvas App that would only export the items in a gallery (even after the user filters that gallery; So, columns and rows they want to export to excel will change every time they filter the gallery). How do I approach this? Every tutorial I find wants me to decide the columns before-hand but I want to be able to let the user decide what data to be exported.
Columns do not change when user filters a gallery. Only the row changes. There is no selector option for columns in power apps and that’s why there are no tutorials on it. I have a video coming out tomorrow that will showcase how to export large data. In there I also talk about exporting columns dynamically using list views. However here as well there would need to be some predefined views which have columns set for exporting. But at least it would give some level of flexibility.
Great Video Reza, the only question I have is, this approach needs to have access to the one drive which has that template.xlsx available. If I am creating a generic flow for users leveraging their one drive storage, this file would be unavailable there and I would not be able to leverage this approach. Any thoughts? An alternate based on my research would be to use a script approach which I am not very keen on implementing either.
Great viddeo Reza. Just one question, the delay here is because the add rows takes a lot of time. Any idea how to make it synchronous which means next actions should start only after the each loops ends with add rows being completed.
@@RezaDorrani What I faced is the each loops gets executed and next action below to it starts running but till that time excel would have added just 1 rows to the table. Though its synchronous to the call/action but in actually because its not waiting until all the rows are added to the excel table. I hope I was clear to explain the situations, looking forward for your valuable response, Reza. Thanks :)
@@RezaDorrani Hi Reza, Its not about the delay action, adding rows to excel actually takes a lot of time in real but the each loop finishes in fraction. So if you have any action after that such as create file, then we see only 1 row would have added when create file completes, however if you give it a minute or so, it completes adding all the rows to the excel. So in reality even if each loops completes the action, add rows in excel actions were still in queue to execute it. As a whole each loop becomes synchronous but with add rows in excel takes more time as individual.
@@nishikantrath1905 That’s why the delay was added. As far as flow is concerned the actions are synchronous, apply loop completes only then next action is called. However the excel file is still loading data.
Thank you Reza , With this video reference i managed to complete my few reports automation . However the workflow gives wrong value as power automate uses the UTC format . would it be possible to share the expression for date and time created field .( 3:20 )
Hello Reza, Time zone conversion is well explained on ua-cam.com/video/O97IdCbfMQI/v-deo.html . However am trying to convert column "Created" and updating in an excel from SharePoint list , I lost in here . Looking for the expression in Select operation ,Date and Time should be converted time zone of my :Created" Column .
Thank you very much Reza for your videos. I wanted to tell you how to export fields from the sharepoint list that are vlookup, I have not been able to do it. Thank you so much.
Thanks for watching and liking my videos. Lookup columns in SharePoint are complex type columns. You will need to extract the values from it and then export that to excel. I do not have a video on this scenario. I will recommend to check on the forums at powerusers.microsoft.com in case someone has done something similar
Great Video and thank you for taking the time to reply to your commenters. I am hoping to develop a flow that will enable me to add rows of data to an existing sheet. In the video you mentioned that you have to make a new sheet, is there a way to do export to an excel sheet that is preexisting? Thanks
Great job this worked amazing but how do I remove the HTML style data from the emailed Excel spreadsheet for the Rich Text fields in my list? Thanks for any help you can provide.
Rich text fields will include html info. I’m not sure how but there must be a way to strip the html or simply convert it to text only. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com
This instructions are amazing. I found one tweak though. It’s not mandatory to provide the accurate range during create table step. Even if I create table with 2 columns only, the header names will be populated as a table only
Thank you for this very helpful tutorial. I am currently building a monthly report via Power Automate and one of the columns that i am trying to send to Excel is a multiple-line text column. The challenge I am having is that it doesn't send all the lines from this column, it only sends the top most line. Can advise how I can send the full data of this column into the Excel column? Hope you can help me. Thank you in advance for your response :)
Thank you for watching the video. I will have to look at your flow in action to know more about your issue or provide any guidance. Looks like it has to do with the new line character or some other case. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@@AutomationDose4U I make videos when I receive multiple requests on a topic. Every quarter 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.
Its been a while since I did this video. At what point (timing) in video, do I show delete file? You could always introduce a delay action prior to file delete.
Hi Reza, great video as always. Question: my flow apply to each only loop for 100 times so i only get 100 items, is there a way to extend that loop and get all the item base on the query i made in get items?
Hi Reza, Thank you for this. I have an issue that because sometimes one of the fields are blank i keep getting the error 'A value must be provided for item.'. Do you know a work around?
Hi Reza, thanks for this clear and useful example, one question: I'm getting the history of versions from sharepoint list, and want to send to an excel file, I'm using the Send HTTP Request to SharePoint connector, I actually got the history of versions, but I can not parse fields with parse JSON to put the desired fields into a previously created Excel table, I've got "schema validation failed" error, how can I fi it? is there another way to do it? regards
I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Very informative and real-world schenario based video. Thank you Reza !! Quick question: While generating csv file, I can see columns are sorted in ascending order even provided in random order (expected). Can we retain column ordering in csv file? I saw in flow content action, input is already sorted in ascending order. Hence it seems the PowerApps Json function is causing issue (automatically sorting columns to ascending order ) . Thanks again.
Thank You! Alphabetical sequence is an in-built behavior of the Create CSV table action. In advanced options for create csv table action, you can define custom columns and list out the header and values. Those will be ordered. Its more work.
Hello Reza, your videos are helping us a lot.... i am facing issue when i trying to export multiline text from share point to excel... not getting exact same output
I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hey Reza, this is helpful. Just curious, how can I add data into multiple sheets using this method? I can create multiple tables, but how can we write it to multiple sheets in the same file itself?
Amazing tutorial Reza, but if my table in excel has a column that should contain a picture in each row (coming from a Sharepoint Document Library), how can I add that picture and how do i set it up in the Select Action?
Thanks. I have not tried with picture in each row so not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
i just followed it step by step and the ouput got created by magic, thank you so much... one catch, the looping takes forever upto 30 mins sometimes, any suggestions ??
Superb video, will you create a video on copying one excel to another excel another email please? that sound similar but i had been struggled on it for awhile...
Really liked your video with example and step by step explanation, if I wanted to copy the data from one excel to another excel, and apply condition, which video would you recommend please?
Will add the topic suggestion to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.
Will add the topic suggestion to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.
Great video as always. I've followed this but using approvals in teams. How do I post the final excel file to my teams channel rather than sending via email?
Hi Reza , Thanks for your wonderful sharing . I followed you step by step . but it was very strange that the file in one-driver has three rows, but the email attachment only contains one row . Why that . Thank you for your time .
Most welcome! As for the issue, 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
Hi Reza, thank you very much for your video, it is great help to me. I am looking for a flow which help to download / update Planner data to Excel in realtime (for Power BI report purpose) to all the plans in my Team group. Do you have any video or guideline to set this up? I can do flow to the first download but when make it recurrent it keep duplicate same rows. And I am looking for how to download all the plans at the same time as well. Would be great if you can help on this matter please. Thank you very much.
@@RezaDorrani My Organization needs a flow to get MS Planner data in realtime update (or close to real time) for a plan. Can I contact you to support create this flow as outsourcing job? please let me know how can contact you, thank you very much.
Is it possible to reuse this code with a collection or gallery of Power apps? , It caught my attention that you did not do the example with powerapps only with Dataverse and Planner
Possible. Same concept applies. I will add this idea to my backlog but will need a lot more folks requesting this topic to give it a higher priority. Meanwhile, I will recommend checking the forums at powerusers.microsoft.com/ in case someone has done something similar.
learn a lot from your video, thanks for your great video. one question, is there any way to split excel sheets to different files with power automate? thanks
Hi Reza, as always, it's an excellent video, but you know in my scenario i am getting an excel file in an email with raw data with headers, not in table format, from here i want to copy and paste filtered data into new excel table, can you guide me or refer me any other video of yours?
Thanks! I do not have a video reference on this scenario and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Many thanks for the amazing video. Just one issue I am facing, everything else has been created as expected but no data coming on the Excel table. Just
Hello Reza, thank you for the helpful videos. I have a question regarding this video. is there a possibility to show also the size of folders and subfolders in excel?
You rock Reza, but what about if I use the action of create a File and then create a table but I have 2 tabs in that file. I want to create 2 tables, one for each tab in the same flow, because it takes only the first tab when I run the flowm.I need your help:(
Hi Reza, great video. When I search for "current Item" it doesn't come up as an option. Do you know why that could be? any help would be greatly appreciated
Most weclome! I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani I have that issue resoled now. However, when I run the flow to test it, it fails at the "apply to each" (ActionFailed. An action failed. No dependent actions succeeded.) and "Add row into a table" steps (BadRequest.). Error Details (A value must be provided for item.) Any suggestions?
Hey, Thanks for this video, but right now i am looking for workflow where email excel attachment data save in SharePoint list , its like a reverse of your workflow, possible to make a video or give me a suggestion?
I do not have a video reference on that topic. I make videos when I get multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted ideas get added to my backlog. Make sure to add this idea to next topic post suggestion.
Hello Reza, really nice tutorial. just one more thing, is there possibility to download Web data in excel using online version of Power Automate. Thanks, Jai
Reza, love the video....great information. Wondering if there's a way to set the Filter Query (at the start) to a dynamic choice I'd provide in PowerApps (so the SharePoint List item returned would be based on the record I'd like selected)? So far, when I try to create an Output from PowerApps (Ask in PowerApps) PowerAutomate doesn't actually seek out that record from the Ask in PowerApps request
It should work if data is being passed correctly from apps to flows. I will have to look at your App & flow in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thanks so much Reza. I will be sure to do that Really appreciate all the great content and information. Your videos have helped me tremendously.
@@RezaDorrani sorry that was my mistake. I took the Array instead of the expression without split. That is fixed now but I want to select a Multiselect Choice field values in comma separated string into Select Action .
Hi Reza, thank you so much for the video! I was wondering how can we achieve this if there are multiple selections for certain columns on the SharePoint list? I tried using the compose and join expressions but it ends up populating every item into the same row:(
Nice work Reza :) but in your recent videos, you are trying to cover a lot of things that increase the complexity of the flow and somewhere I am losing the focus. Please try to give more time to explain the "actions" which you are using inside the flow, thank you!
Thanks for the feedback. I did provide sample flows in my recent videos which can be downloaded. Plan was to cover more scenarios. I will try and strike a better balance in future videos.
Great video, I have an exact use case for this.. I am running into an issue though as my people column is actually multi select. I tried using a variable but I just get all the records display name in every row of the table instead of each row having their unique records.. Any thoughts on how to use this flow when a field is a multi select people field?
You will need to use an apply to each loop in flow on your multi select column and then for each item in loop you can start adding a row in excel. I do not have a video reference on this exact scenario though. I will recommend checking on forums at powerusers.microsoft.com in case some has done something similar
@@RezaDorrani can you please make a video out of it? It's really hard and I can't figure out how to do it :/ When I move Select operation inside the loop the add row into a table can't refer to Select anymore. If I move add row into a table into the loop I will have loop in loop and it just not work
@@pgadacz I have many other video ideas I am working on. I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my UA-cam channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Your best bet will be to post your issue with screenshots on the forums at powerusers.microsoft.com/
I have not experienced that issue hence not sure what the fix is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Thanks Reza, great video!!! In the case that you need to fill a complex template such as an invoice, maybe you can reference invoice template cells with the table cells. Or you have a better workaround?
Not sure to be honest. It depends on where the data is coming from. Are you trying to extract data directly from an invoice document using AI Builder? Concept would be similar. Build the Select action and provide that to the pattern showcased in the flow.
Excellent! I love that you provide demos on real-life business examples and I can put them into practice immediately!
Glad you like them! Thanks for watching.
@@RezaDorrani Good morning Raza. I have a scenario like there will 500 coloumns in my share point list. I have a download button in my canvas aap. When I click download these records are downloaded in excel template format(for this I will take add rows into a table action (exce online business) iam used but it takes 15-20 mins to complete the flow) is there any alternate to download data from database using canvas&powerautomate flow?
@@khasimshaik2606 500 columns are too many. You need to look into redesigning the lists or selecting a better data source (relational database) to meet your needs.
It would take time to generate your output because of so many columns. I have no solution for this.
@@RezaDorrani sorry 500 records Raza not coloumns
@@khasimshaik2606 500 rows may take 5-10 mins for sure. Im not aware of any faster process.
Everything that Reza teaches us matters, collecting and structuring data is EXTREMELY important. I am in the middle of a Data Science program with MIT and the fist thing we do is to collect and clean data before any analysis. So pay extra attention what Reza says , it will make a hell of a difference later. Clean data is like drinking clean water. Thank you Reza!
Wow! Thanks for the amazing feedback.
I completely agree with the statement "Collect and clean data before any analysis".
"Clean data is like drinking clean water." Couldn't have said it better myself!! lols!
Finally found this AMAZING video! I haven't found anyone else that address the creation of an Excel file from scratch as you have. THANK YOU! This is going to save me hours and hours!
Glad it was helpful! Thanks for watching
I watched a few videos on this topic, but none were as clear and easy to follow as this one! I appreciate that you explained why you were doing each step as well. Thank you.
Most welcome!
You are the Best, I love you. I have been struggling with Excel files locks and this Technic helped me a lot. No more locks with this approach.,
Glad I could help
New on power automate, but after 2 days of searching, this finally solved my issue - my man!
Thats a lot of searching :)
majority of videos are not really my use case or things has changed in power automate compared to how they do it... but this worked :) @@RezaDorrani
I don't know how but I can always find a video on your channel related to the problem I'm facing 😃...that means your content is 'real world problem solving content' thanks for your efforts
You are most welcome!
Best Powerapps content on entire UA-cam.. very easy and detailed explanations.. Thank you so much :)
Wow, thanks!
Hi Reza, your videos are definetly amongst the best that I've come across, just a tip, you might want to consider zooming in just a slight bit when making the video. Even on full screen I cant see some of the json code,so I have to go out the video to look for external content on google and then come back to the tutorial. Thank for the tone of effort that you put into these videos!!
Thank you for the feedback.
I will try and zoom in more specially when showcasing code.
Thank you Dear Reza... It's an actual world project like all your previous teaching. Awesome.
#1 in Teaching Power Platform.... Awesome...💚
Wow, thank you so much 🙏
Reza, this is super helpful. Just a quick question. I don't need the file name to be different every time this runs. Is that a problem? If I keep the file name the same(e.g updatedschedule.xlsx) will the file be automatically overridden?
I believe it will. Best is to give it a try and check.
@@RezaDorrani gave it a try and there is a snag. There is a 400 or 423 Error that occasionally happens when overwriting the same file in the directory which runs into the flow throwing an error and stopping. However, there is a workaround that several folks have pointed out. Some involved adding a loop until the lock is removed, while other's have a routine at the API server level to clear the lock immediately. All good solutions. Thanks again.
@@TheOxIshere Workaround sounds like a good idea :)
This worked great! I'm using Planner and SharePoint in my solution and have had no issues.
👍
Awesome video. This has help me a lot. I was wondering if it was possible to use power query in excel with this method. For instance: when excel file is sent to an outlook email. Grab that file and use power query to clean data then create another file to email the cleaned data. Not sure if it’s possible. Thanks
I’m not sure either. I would recommend checking on forums in case someone has tried it.
powerusers.microsoft.com
@@RezaDorrani I’ll check it out. Thanks
Excellent Reza you rock! Thank you for sharing. I am going to try this out at the weekend. Happy Days!
Have fun!
Your videos are always super helpful, Reza!! One question - One of my SharePoint columns contains a link. I'd like to add that link to the resulting Excel file. What's the best way to extract the link and plug it into the Excel file? Thank you in advance!
Most welcome!
I have not tried with hyperlink type column, hence not sure of the steps.
Great stuff Reza ⚡ - Thanks, this is a big help for a current use case. That dynamic hack is something something else - great find!
Glad it was helpful!
Excelent video as always, I am a "Reza addict".
always waiting for your next video.
Personally most of the very long live events, not including the expressions series, are totally a waist of time for me.
Thank you
Thank you for following and liking my channel.
I am not a big fan of long running live events either.
Thank you for the video, i have one question. in the excel attached in the email i get one row all the time, even if there are more rows in de sharepoint list. How do i set the number of rows?
I have not come across any issue where its only 1 row all the time. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, all your videos are very helpful. Is it possible to export data from multiple collections to different sheets in the same excel ? If so, how to achieve that?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Great explanation. Was about to give up on Power Automate and your vid really helped.
Never give up
Hi Reza, thank you for this video. It was just about perfect for my project I was working on. I do have a question for you (or anyone else who has solved this): When the data is brought into the newly created Excel file (based on the template I have), it formats the Excel table with the default formatting. This does not look good or even fit with the rest of the template I have created. Is there a way of either a) pre-formatting an Excel table and inserting my data into that table, or b) formatting the table as it gets created inside my file? Thank you!
I am not sure if that is possible. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thank you Reza.
Thank you Reza, the A1 notation mapping resulted WAY easier than I expected 😁 as always, thanks for such a useful and insightful video.
Great to hear! Thank You for watching.
Hi Reza, another great video, very clear and to the point. Worked first time.
Great to hear!
Thanks for this video. Exactly what I am looking for. Instead of OneDrive for Business to store files, I used Sharepoint Library. The steps are similar to using OneDrive for Business connector. Works great
This video also answered my question regarding dynamic table range. Great video!
Glad to hear the video is useful. Thanks for watching Jay.
Hi Jay, I am looking for something si,ilar to what you did, using Sharepoint instead of OneDrive, would you care sharing your flow ( provided there is no security data involved)?
useful video indeed, everyone request this video, explaining clear as water. much appreciate your effort, keep it up.
Thanks a lot for the amazing feedback.
Perfect tutorial, thanks for it. Do you happen to know how I can also export Vlookup column values? When I try to match them in the select step, there is an error at the end of the flow (Add a row into a table) saying that 'A value must be provided for item.'
Thanks
Thanks!
I am not sure about vlookup columns.
Thanks, Reza. It was definitively a well-explained video over how to export to Excel. I have two questions: Is it possible to change the name of the exported Excel file to something (unique) more User-meaningful instead of the GUID? Do you have a similar video where the destination of the file is Sharepoint not OneDrive?
You could call the file anything you desire. I used guid to keep it unique.
I do not have a SharePoint based video.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hey Reza, fantastic video. Great work!
Thank You!
Hi Reza.. Playing with different components of O365 I have to learn from you.. You make the life easy..
Glad to hear that! Thanks for watching.
Wonderfully detailed! Is there a way, or do you have a video that instructs how to use date and choice inputs from the manual trigger to create a table? I wish to create an Excel table from instant Flow, being able to choose beginning date, ending date, and choice field selections. My attempts to incorporate this into the OData filter query fails. Any guidance is greatly appreciated. I may be trying to do the impossible 🤔
Thanks!
I do not have a specific video reference on this scenario and would have to try it out to provide guidance.
Hey Reza, your video tutorials have been super helpful for my project, but I've got a question. So, the thing is, I've got more than 1000 rows in my SharePoint list, but when I run my Flow automation, it's only grabbing 100 rows. Any idea how to fix this? Thanks again, by the way!
Increase row limit + explore pagination property. Check documentation on flow action for get rows.
@@RezaDorrani Thanks for your reply! I'll be looking into that
thanks a lot Reza !!! it works perfect :-) the only problem that I have is that instead of sending it per email I need to save the excel file into a Teams folder (and post the link there). I tried with "Post a message in a chat or channel" but I cannot attach the excel file like when sending by email. Would you have a solution for that ?
Thanks for watching and liking the video.
For saving in teams folder, I guess you would need to use SharePoint actions since Teams backend is SharePoint. I don’t think post a message supports attachments.
I would recommend to post your query on the forums at powerusers.microsoft.com in case someone has done something similar.
Awesome, tutorial Rezza, Thanks. I have a query though. I have made this flow as you have explained and have added a filter query, but I only seem to be getting the results of my filter query from the first 100 records in my sharepoint list. Is there a reason for this???
I have a video releasing today which explains exactly that. Wait for it :)
Thanks for this video. Is it possible however to dynamically loop through the columns of a table? Imagine we have an Excel that always has a properly formatted table, but we don't know the name of its columns nor the amount beforehand, apart from one column name that we know will always be present (not that we really care). Is it possible to copy some of these rows (let's imagine the 10th row and first) to a new table?
I am not sure about looping through columns (might be possible via graph api) and would have to try it out to provide guidance. I would recommend posting your query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, Great video, instead of starting with a sharepoint list can I start with an excel file and then follow the same steps you show in the video?
It should work but not something I have tried
Thanks Reza. You are wonderful person. Your explanation is really wonderful.
You are most welcome
Thank you Reza for the lovely video... You are a true champ
You are most welcome
@@RezaDorrani I had one question or request - The file name that comes as output is a mix of #'s and alphabets... Is there a way we can have the some naming convention for the file.
In My flow, the column I am filtering is Name of Managers and I would like the excel to have a specific naming convention. In case you are able to clarify, I will be highlly obliged, other wise, I thank you for such a fantastic video.
@@sankhlayashraj You have full control over file name. Not sure whats the challenge with changing it?
Thank you for this video! After many trial and error, I was able to automate a queried dataset and export to Excel with your steps. However, I noticed the leading zeros disappear which was the reason for the export to Excel vs CSV. Do you know how the leading zeros can be retained? The queried data has leading zeros as a text format. Many thanks.
Im not aware of a workaround for leading zeros as I have not come across a scenario with it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thank you!! I actually just figured it out. The Excel Template, highlighted the entire worksheet and formatted to text then saved. Worked perfectly!!
Hi Reza, it's amazing and really useful. I've created the same flow for exporting an Excel report from SP List but encountered an error that the Excel file attached at the email is not openable. However, the same Excel file generated at the OneDrive folder is openable. I've 100% followed the steps and details as yours and now I can't resolve the issue.
Hope you may help please!!!
Thanks you very much.
Raymond
Thanks so much!
I have not come across the mentioned issue and hence not sure what the cause could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani Thanks for your advice and I've visited the website you suggested but sorry that I don't know how to post my issue there.
Please can you provide me with some more guidelines.
Thank you so much for your assistance!!!
@@himoray Sorry I cannot assist with that. Its a public forum.
Great comprehensive video, thanks!
Glad it was helpful!
Hi Reza, nice video thank you! I just have one question: is it possible to add more than one row at a time to an excel table? Because it takes too much time adding to the table many rows. Do you know if exists an alternative way?
You would need to look into excel api's if it allows bulk additions. I have not attempted that.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Great explanation! Do you have a video that explains when it is connected to SQ server? I want to connect to SQL server(Execute a SQL query(V2)), create a table in excel and send an email.
I do not have a video with SQL.
Excellent VIdeo Thank you so much
am facing a issue with Multiselection dropdown field. when runt the flow, am getting below issue ."A value must be provided for item."
Can you help where am worng
I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Sure Thank you
Hi..Thank you for the video. It was really helpful. One question- Can we run the flow automatically at the end of the month?
Simply change trigger of flow to schedule flow.
Hi Reza, thanks for this video. It has been really helpful for me. Is there a reason why its only bringing only 100 records while my list has +500?
ua-cam.com/video/yeAnuTB85eg/v-deo.html video has the answer
Thank you very much, learned a lot from your channel, I encountered a problem, if I have different fields, how to dynamically export different fields of SharePoint List
Idea is to select fields from SharePoint for any column type but not dynamically select columns. How would flow know which cols to select dynamically?
@@RezaDorrani Thank you very much for your reply. There is another SHAREPOINT LIST for the required fields. I plan to use removeproperty object to delete unnecessary fields, but I need to obtain the person list field
@@MMYGOGO Its possible but not something I have tried. Give it a try and if facing issues, then post the issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani OK, thanks
I used the API to list the fields of the SHAREPOINT LIST, and an error occurred while processing each field,show The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('LIST')' is of type 'Object'. The result must be a valid array.
Thanks Reza for the extremely useful video,
I am trying to get the dropdown values of dataverse column,
But getting the values of it, instead of text in excel file,
Can you please suggest what action needs to be done to get dropdown text, instead of values?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Love this video Reza! I'm a Flow novice. During the select operation (to select columns), can this be dynamic as well?
Thanks :)
Select can be made dynamic but complexity would increase. Something that I have not tried before.
Hi Raza, Thank you very much , i want to do this process for different different Excel files. can we make select operation dynamic or can we use any other operation to make it dynamic?
You can write dynamic operations using expressions. I do not have a specific video for it though.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Helpful as always, thank you for another great video!
Glad it was helpful!
Nice video Reza! I'm trying to create an Export to Excel feature within Canvas App that would only export the items in a gallery (even after the user filters that gallery; So, columns and rows they want to export to excel will change every time they filter the gallery). How do I approach this? Every tutorial I find wants me to decide the columns before-hand but I want to be able to let the user decide what data to be exported.
Columns do not change when user filters a gallery. Only the row changes.
There is no selector option for columns in power apps and that’s why there are no tutorials on it.
I have a video coming out tomorrow that will showcase how to export large data. In there I also talk about exporting columns dynamically using list views. However here as well there would need to be some predefined views which have columns set for exporting. But at least it would give some level of flexibility.
Great Video Reza, the only question I have is, this approach needs to have access to the one drive which has that template.xlsx available. If I am creating a generic flow for users leveraging their one drive storage, this file would be unavailable there and I would not be able to leverage this approach. Any thoughts? An alternate based on my research would be to use a script approach which I am not very keen on implementing either.
Load the file in SharePoint and grant everyone read access to template file.
Awesome Video. Everything worked like a charm. Thank you!
Most welcome!
Great viddeo Reza. Just one question, the delay here is because the add rows takes a lot of time. Any idea how to make it synchronous which means next actions should start only after the each loops ends with add rows being completed.
The delay is set after add rows has completed. It is synchronous.
@@RezaDorrani What I faced is the each loops gets executed and next action below to it starts running but till that time excel would have added just 1 rows to the table. Though its synchronous to the call/action but in actually because its not waiting until all the rows are added to the excel table. I hope I was clear to explain the situations, looking forward for your valuable response, Reza. Thanks :)
@@tuniarath153 Delay is after apply to each loop. The delay action will get called only after the apply to each step ends.
@@RezaDorrani Hi Reza, Its not about the delay action, adding rows to excel actually takes a lot of time in real but the each loop finishes in fraction. So if you have any action after that such as create file, then we see only 1 row would have added when create file completes, however if you give it a minute or so, it completes adding all the rows to the excel. So in reality even if each loops completes the action, add rows in excel actions were still in queue to execute it. As a whole each loop becomes synchronous but with add rows in excel takes more time as individual.
@@nishikantrath1905 That’s why the delay was added. As far as flow is concerned the actions are synchronous, apply loop completes only then next action is called. However the excel file is still loading data.
Thank you Reza , With this video reference i managed to complete my few reports automation . However the workflow gives wrong value as power automate uses the UTC format . would it be possible to share the expression for date and time created field .( 3:20 )
formatdatetime I believe. Check ua-cam.com/video/O97IdCbfMQI/v-deo.html
Hello Reza, Time zone conversion is well explained on ua-cam.com/video/O97IdCbfMQI/v-deo.html . However am trying to convert column "Created" and updating in an excel from SharePoint list , I lost in here . Looking for the expression in Select operation ,Date and Time should be converted time zone of my :Created" Column .
Thank you very much Reza for your videos. I wanted to tell you how to export fields from the sharepoint list that are vlookup, I have not been able to do it. Thank you so much.
Thanks for watching and liking my videos.
Lookup columns in SharePoint are complex type columns. You will need to extract the values from it and then export that to excel.
I do not have a video on this scenario.
I will recommend to check on the forums at powerusers.microsoft.com in case someone has done something similar
Great Video and thank you for taking the time to reply to your commenters. I am hoping to develop a flow that will enable me to add rows of data to an existing sheet. In the video you mentioned that you have to make a new sheet, is there a way to do export to an excel sheet that is preexisting? Thanks
If your excel already has a table created (within a sheet), you can just add data in there.
Hi Reza, thanks for video. I'd like to learn that how we export our attachments picture to Excel or PDF files?
Thanks.
I have not done any work with exporting attachments to excel.
I will recommend checking on the forums at powerusers.microsoft.com/
Great job this worked amazing but how do I remove the HTML style data from the emailed Excel spreadsheet for the Rich Text fields in my list? Thanks for any help you can provide.
Rich text fields will include html info. I’m not sure how but there must be a way to strip the html or simply convert it to text only. I will recommend checking on forums in case someone has done something similar
powerusers.microsoft.com
This instructions are amazing. I found one tweak though. It’s not mandatory to provide the accurate range during create table step. Even if I create table with 2 columns only, the header names will be populated as a table only
Good find
@@RezaDorrani Thanks Mr Reza for this tutorial. Now I could export large power Bi dataset into an excel table. Could not find any easier way earlier.
Thank you for this very helpful tutorial. I am currently building a monthly report via Power Automate and one of the columns that i am trying to send to Excel is a multiple-line text column. The challenge I am having is that it doesn't send all the lines from this column, it only sends the top most line. Can advise how I can send the full data of this column into the Excel column? Hope you can help me. Thank you in advance for your response :)
Thank you for watching the video.
I will have to look at your flow in action to know more about your issue or provide any guidance. Looks like it has to do with the new line character or some other case. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, thanks for sharing your knowledge.
Is it possible to export 25k items from sp list to excel in one go (without loop).
Thanks 👍
Possible using graph api but not something I have explored
@@RezaDorrani thanks 👍.
Really helpful if you have plan to create video on it.
@@AutomationDose4U I make videos when I receive multiple requests on a topic. Every quarter 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.
@@RezaDorrani ohk, thanks buddy for quick help and reply. 🙏
Your videos are truly amazing.
Hello, Very helpful video. When i run it i get an error on the delete file flow, It says the file is still locked. Do you have any suggestions?
Its been a while since I did this video. At what point (timing) in video, do I show delete file?
You could always introduce a delay action prior to file delete.
@@RezaDorrani Thank you Reza this worked!
Hi Reza, great video as always. Question: my flow apply to each only loop for 100 times so i only get 100 items, is there a way to extend that loop and get all the item base on the query i made in get items?
Are you adding a filter query to fetch data from list?
You can set top count as 5000 and turn on pagination for list items action.
Hi Reza, Thank you for this. I have an issue that because sometimes one of the fields are blank i keep getting the error 'A value must be provided for item.'. Do you know a work around?
Workaround would be to write expressions to do null checks.
I do not have a video reference on this scenario though.
Hi Reza, thanks for this clear and useful example, one question: I'm getting the history of versions from sharepoint list, and want to send to an excel file, I'm using the Send HTTP Request to SharePoint connector, I actually got the history of versions, but I can not parse fields with parse JSON to put the desired fields into a previously created Excel table, I've got "schema validation failed" error, how can I fi it? is there another way to do it?
regards
I will have to look at your flow in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Very informative and real-world schenario based video. Thank you Reza !! Quick question: While generating csv file, I can see columns are sorted in ascending order even provided in random order (expected). Can we retain column ordering in csv file? I saw in flow content action, input is already sorted in ascending order. Hence it seems the PowerApps Json function is causing issue (automatically sorting columns to ascending order ) . Thanks again.
Thank You!
Alphabetical sequence is an in-built behavior of the Create CSV table action.
In advanced options for create csv table action, you can define custom columns and list out the header and values. Those will be ordered. Its more work.
@@RezaDorrani in create table how to define sorting order ? i.e. if we want to sort the Excel with particular column is there any option ?
@@2007pradipta I don’t remember if it does have that option.
Thanks Reza, this is really helpful . Thanks for this
My pleasure!
Hello Reza, your videos are helping us a lot.... i am facing issue when i trying to export multiline text from share point to excel... not getting exact same output
@rezadorrani can you suggest option
I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hey Reza, this is helpful. Just curious, how can I add data into multiple sheets using this method? I can create multiple tables, but how can we write it to multiple sheets in the same file itself?
I have not tried with multiple sheets hence not sure
Amazing tutorial Reza, but if my table in excel has a column that should contain a picture in each row (coming from a Sharepoint Document Library), how can I add that picture and how do i set it up in the Select Action?
Thanks. I have not tried with picture in each row so not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani alright I'll update you in case i find something useful. thanks again!
Really usefull, this is just what i needed. thank you for saving my life !! , love your videos
Thanks so much for watching and liking the videos
i just followed it step by step and the ouput got created by magic, thank you so much... one catch, the looping takes forever upto 30 mins sometimes, any suggestions ??
Most welcome!
In my latest video, I show how you can speed up the loop.
ua-cam.com/video/b3aQf17ptAs/v-deo.html
Superb video, will you create a video on copying one excel to another excel another email please? that sound similar but i had been struggled on it for awhile...
Really liked your video with example and step by step explanation, if I wanted to copy the data from one excel to another excel, and apply condition, which video would you recommend please?
Will add the topic suggestion to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.
Will add the topic suggestion to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.
Great video as always. I've followed this but using approvals in teams. How do I post the final excel file to my teams channel rather than sending via email?
Use the create file action to add the file to the SharePoint team site backed by the Microsoft Team.
Hi Reza , Thanks for your wonderful sharing . I followed you step by step . but it was very strange that the file in one-driver has three rows, but the email attachment only contains one row . Why that . Thank you for your time .
Most welcome!
As for the issue, 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
Hi Reza, thank you very much for your video, it is great help to me. I am looking for a flow which help to download / update Planner data to Excel in realtime (for Power BI report purpose) to all the plans in my Team group. Do you have any video or guideline to set this up? I can do flow to the first download but when make it recurrent it keep duplicate same rows. And I am looking for how to download all the plans at the same time as well. Would be great if you can help on this matter please. Thank you very much.
I do not have any videos with Planner and flow. I will recommend you check on the forums at powerusers.microsoft.com/
@@RezaDorrani My Organization needs a flow to get MS Planner data in realtime update (or close to real time) for a plan. Can I contact you to support create this flow as outsourcing job? please let me know how can contact you, thank you very much.
@@minhphuc7993 About me tab on my UA-cam channel has my email address.
Is it possible to reuse this code with a collection or gallery of Power apps? , It caught my attention that you did not do the example with powerapps only with Dataverse and Planner
Possible. Same concept applies.
I will add this idea to my backlog but will need a lot more folks requesting this topic to give it a higher priority.
Meanwhile, I will recommend checking the forums at powerusers.microsoft.com/ in case someone has done something similar.
learn a lot from your video, thanks for your great video.
one question, is there any way to split excel sheets to different files with power automate?
thanks
Possible. I do not have a video on that though.
I will recommend you check on the forums at powerusers.microsoft.com
Hey Reza, great video. I would like to choose the item (row) that I want to export from SharPoint Lists, do you have a video about how to do that?
I do not have a video on that scenario
Hi Reza, as always, it's an excellent video, but you know in my scenario i am getting an excel file in an email with raw data with headers, not in table format, from here i want to copy and paste filtered data into new excel table, can you guide me or refer me any other video of yours?
Thanks!
I do not have a video reference on this scenario and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@@RezaDorrani , Thanks for replying to my query Reza, amazed with your prompt response. sending love from India. Sure, I will try the link.
Hey guys! In the "Create Table" connector I had a format issue. I solved it by changing the Table range from A1:E1 to Sheet!A1:E1. Hope it helps!
Thanks for sharing
Hi Many thanks for the amazing video. Just one issue I am facing, everything else has been created as expected but no data coming on the Excel table. Just
Hi Reza. Thanks for the video. Do you know a way to convert xls files to xlsx in power automate without using premium license?
I am not aware of one. I will recommend checking on the forums at powerusers.microsoft.com/
Hello Reza,
thank you for the helpful videos.
I have a question regarding this video.
is there a possibility to show also the size of folders and subfolders in excel?
Not sure. I have not tried it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
You rock Reza, but what about if I use the action of create a File and then create a table but I have 2 tabs in that file. I want to create 2 tables, one for each tab in the same flow, because it takes only the first tab when I run the flowm.I need your help:(
Thanks! I have not tried with 2 tabs so not sure.
Hi Reza, great video. When I search for "current Item" it doesn't come up as an option. Do you know why that could be? any help would be greatly appreciated
Most weclome!
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani I have that issue resoled now. However, when I run the flow to test it, it fails at the "apply to each" (ActionFailed. An action failed. No dependent actions succeeded.) and "Add row into a table" steps (BadRequest.). Error Details (A value must be provided for item.) Any suggestions?
@@straightrespect2446 I have not faced that issue either
Hey, Thanks for this video, but right now i am looking for workflow where email excel attachment data save in SharePoint list , its like a reverse of your workflow, possible to make a video or give me a suggestion?
I do not have a video reference on that topic. I make videos when I get multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted ideas get added to my backlog. Make sure to add this idea to next topic post suggestion.
Wonderful. Just one thing how to send the email by sender name as SharePoint site name not by wf owner?
You can send an email from a shared mailbox. There is an action for that in flow.
Hello Reza, really nice tutorial. just one more thing, is there possibility to download Web data in excel using online version of Power Automate. Thanks, Jai
Possible using Power Automate Desktop
Reza, love the video....great information.
Wondering if there's a way to set the Filter Query (at the start) to a dynamic choice I'd provide in PowerApps (so the SharePoint List item returned would be based on the record I'd like selected)?
So far, when I try to create an Output from PowerApps (Ask in PowerApps) PowerAutomate doesn't actually seek out that record from the Ask in PowerApps request
It should work if data is being passed correctly from apps to flows.
I will have to look at your App & flow in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thanks so much Reza. I will be sure to do that
Really appreciate all the great content and information. Your videos have helped me tremendously.
@@yusenlogistics-externaltra1978 You are most welcome!
Thanks, Reza for his amazing video. May I suggest another video topic "Sync PowerBI report to SharePoint list "
Where is the data in power bi report coming from?
Not sure if I understand the use case to sync power bi data to SharePoint.
謝謝你的教學，讓我們受益無窮。
Welcome
Great video as always!
Q) while export to excel ,columns are getting sorted with alphabet order.is there any way to control the column order?
You can use the select action to pick the columns you need from the array.
Do you happen to have a tutorial simular to this, but allows us to create the Excel file in SharePoint, instead of in OneDrive?
I have done several videos and do not remember each one of them. I may have shown it but dont remember which video.
thanks for the help full videos. I have one query. I want to select a Multiselect Choice field values in comma separated string into Select Action .
It's been a while since I did this video. Not sure I ran into this issue.
@@RezaDorrani sorry that was my mistake. I took the Array instead of the expression without split. That is fixed now but I want to select a Multiselect Choice field values in comma separated string into Select Action .
@@2007pradipta Ok. multi select choice is not something I have done.
Hi Reza, thank you so much for the video! I was wondering how can we achieve this if there are multiple selections for certain columns on the SharePoint list? I tried using the compose and join expressions but it ends up populating every item into the same row:(
Join would be the answer. Not sure why its not working in your case. I will recommend posting your query on forums at powerusers.microsoft.com
Nice work Reza :) but in your recent videos, you are trying to cover a lot of things that increase the complexity of the flow and somewhere I am losing the focus. Please try to give more time to explain the "actions" which you are using inside the flow, thank you!
Thanks for the feedback.
I did provide sample flows in my recent videos which can be downloaded.
Plan was to cover more scenarios.
I will try and strike a better balance in future videos.
@@RezaDorrani thank you 😊
Great video, I have an exact use case for this.. I am running into an issue though as my people column is actually multi select. I tried using a variable but I just get all the records display name in every row of the table instead of each row having their unique records.. Any thoughts on how to use this flow when a field is a multi select people field?
You will need to use an apply to each loop in flow on your multi select column and then for each item in loop you can start adding a row in excel.
I do not have a video reference on this exact scenario though.
I will recommend checking on forums at powerusers.microsoft.com in case some has done something similar
@@RezaDorrani can you please make a video out of it? It's really hard and I can't figure out how to do it :/ When I move Select operation inside the loop the add row into a table can't refer to Select anymore. If I move add row into a table into the loop I will have loop in loop and it just not work
@@pgadacz I have many other video ideas I am working on. I make videos when I get multiple requests on a particular topic.
Every quarter I ask subscribers for topic suggestions on the Community Tab of my UA-cam channel.
Subscribers vote for topics and the highest voted topics get added to my backlog.
Your best bet will be to post your issue with screenshots on the forums at powerusers.microsoft.com/
Thanks! Any solution for the "A value must be provided for item." error? I see a lot of commenters (myself included) are experiencing this
I have not experienced that issue hence not sure what the fix is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Thanks Reza, great video!!! In the case that you need to fill a complex template such as an invoice, maybe you can reference invoice template cells with the table cells. Or you have a better workaround?
Not sure to be honest. It depends on where the data is coming from. Are you trying to extract data directly from an invoice document using AI Builder?
Concept would be similar. Build the Select action and provide that to the pattern showcased in the flow.