Excellent! I love that you provide demos on real-life business examples and I can put them into practice immediately!
@RezaDorrani3 жыл бұрын
Glad you like them! Thanks for watching.
@khasimshaik2606 Жыл бұрын
@@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?
@RezaDorrani Жыл бұрын
@@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.
@khasimshaik2606 Жыл бұрын
@@RezaDorrani sorry 500 records Raza not coloumns
@RezaDorrani Жыл бұрын
@@khasimshaik2606 500 rows may take 5-10 mins for sure. Im not aware of any faster process.
@MarcosMonge-cz7fe Жыл бұрын
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!
@RezaDorrani Жыл бұрын
Thanks for sharing
@atanuS44 ай бұрын
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
@danielnj19912 жыл бұрын
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
@RezaDorrani2 жыл бұрын
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.
@subsguts2691 Жыл бұрын
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!
@RezaDorrani Жыл бұрын
Glad it was helpful! Thanks for watching
@rahullal20582 жыл бұрын
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 )
@RezaDorrani2 жыл бұрын
formatdatetime I believe. Check kzbin.info/www/bejne/hWqaepd5l8uAh6s
@rahullal20582 жыл бұрын
Hello Reza, Time zone conversion is well explained on kzbin.info/www/bejne/hWqaepd5l8uAh6s . 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 .
@matildemoller86402 жыл бұрын
Hi Reza, thank you for your videos, they are the best! Just a little help: my "add a row into a table" action result into this error: "A value must be provided for item. clientRequestId: 3598f5b5-1432-48b7-99b0-8f935eec1d56" How can I turn around this? Thanks in advance!
@RezaDorrani2 жыл бұрын
I will have to look at your flow in action to know the cause of your issue. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@indhumathi4727 Жыл бұрын
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 ??
@RezaDorrani Жыл бұрын
Most welcome! In my latest video, I show how you can speed up the loop. kzbin.info/www/bejne/mGTEgplnbNWnd9U
@michelvredeveld Жыл бұрын
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?
@RezaDorrani Жыл бұрын
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
@adrianalopez33059 ай бұрын
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:(
@RezaDorrani9 ай бұрын
Thanks! I have not tried with 2 tabs so not sure.
@belvr_6 ай бұрын
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!
@RezaDorrani6 ай бұрын
Increase row limit + explore pagination property. Check documentation on flow action for get rows.
@belvr_6 ай бұрын
@@RezaDorrani Thanks for your reply! I'll be looking into that
@anilkumar-ml2sl2 жыл бұрын
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
@RezaDorrani2 жыл бұрын
You are most welcome!
@RamaduraiU2 жыл бұрын
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
@RezaDorrani2 жыл бұрын
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
@RamaduraiU2 жыл бұрын
@@RezaDorrani Sure Thank you
@aaronpowell65322 жыл бұрын
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
@RezaDorrani2 жыл бұрын
I’m not sure either. I would recommend checking on forums in case someone has tried it. powerusers.microsoft.com
@aaronpowell65322 жыл бұрын
@@RezaDorrani I’ll check it out. Thanks
@Jyoti-h1h3 ай бұрын
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?
@RezaDorrani3 ай бұрын
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
@Jyoti-h1h3 ай бұрын
@@RezaDorrani , Thanks for replying to my query Reza, amazed with your prompt response. sending love from India. Sure, I will try the link.
@himoray9 ай бұрын
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
@RezaDorrani9 ай бұрын
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
@himoray9 ай бұрын
@@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!!!
@RezaDorrani9 ай бұрын
@@himoray Sorry I cannot assist with that. Its a public forum.
@TheOxIshere Жыл бұрын
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 Жыл бұрын
I believe it will. Best is to give it a try and check.
@TheOxIshere Жыл бұрын
@@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.
@RezaDorrani Жыл бұрын
@@TheOxIshere Workaround sounds like a good idea :)
@argyrodriguez54582 жыл бұрын
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?
@RezaDorrani2 жыл бұрын
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.
@softtop Жыл бұрын
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?
@RezaDorrani Жыл бұрын
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.
@softtop Жыл бұрын
@@RezaDorrani Thank you Reza this worked!
@akshaymane5522 Жыл бұрын
Hi Power Bi community while filtering the Excel 1:19 column name should not contain any space. I have wasted days for it. Hence mentioning here to save your time❗
@RezaDorrani Жыл бұрын
Good tip 👍
@straightrespect244610 ай бұрын
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
@RezaDorrani10 ай бұрын
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
@straightrespect244610 ай бұрын
@@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?
@RezaDorrani10 ай бұрын
@@straightrespect2446 I have not faced that issue either
@matejvolesini9 ай бұрын
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
@RezaDorrani9 ай бұрын
Thanks! I am not sure about vlookup columns.
@jeffderouin29972 жыл бұрын
Thank you Reza for this excellent video. I am very new to this coding. I am getting an Error Details when I run this flow. The input to Create Table - Table Range expression: OUTPUTS('A1_Notation_Mapping')[sub(length(outputs('Array_Col_Names')),1)] and Column Names - first(split(body('Create_CSV_table'),decodeUriComponent('%0D%0A')))
@RezaDorrani2 жыл бұрын
I will have to look at your flow in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@rochellenicholson63722 жыл бұрын
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???
@RezaDorrani2 жыл бұрын
I have a video releasing today which explains exactly that. Wait for it :)
@vineelkolluru18242 жыл бұрын
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.
@RezaDorrani2 жыл бұрын
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.
@zygons395 Жыл бұрын
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.
@RezaDorrani Жыл бұрын
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
@holycrossyouth12 жыл бұрын
Great tutorial! I followed your teaching but have the following error: "Http request failed: the content was not a valid JSON. Error while parsing JSON: 'After parsing a value an unexpected character was encountered: C. Path 'message', line 1, position 71.' " on the add row to the table, how can I solve this?
@RezaDorrani2 жыл бұрын
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
@horamansarkhosh86153 жыл бұрын
Thank you Dear Reza... It's an actual world project like all your previous teaching. Awesome. #1 in Teaching Power Platform.... Awesome...💚
@RezaDorrani3 жыл бұрын
Wow, thank you so much 🙏
@monterrosa642 жыл бұрын
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
@RezaDorrani2 жыл бұрын
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
@enricosita72532 жыл бұрын
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?
@RezaDorrani2 жыл бұрын
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
@climbyclimb67642 жыл бұрын
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 ?
@RezaDorrani2 жыл бұрын
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.
@Ru3daC0rp872 жыл бұрын
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?
@RezaDorrani2 жыл бұрын
kzbin.info/www/bejne/r5akn6iKd51om8k video has the answer
@ilikeshineys2 жыл бұрын
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?
@RezaDorrani2 жыл бұрын
Workaround would be to write expressions to do null checks. I do not have a video reference on this scenario though.
@mariamelendez38542 жыл бұрын
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.
@RezaDorrani2 жыл бұрын
I do not have a video with SQL.
@yojie1203 жыл бұрын
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 :)
@RezaDorrani3 жыл бұрын
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
@lorenzobretto5489 Жыл бұрын
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?
@RezaDorrani Жыл бұрын
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.
@gitaiganor41003 жыл бұрын
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
@RezaDorrani3 жыл бұрын
Thank you for following and liking my channel. I am not a big fan of long running live events either.
@aokcuoglu2 жыл бұрын
Hi Reza, thanks for video. I'd like to learn that how we export our attachments picture to Excel or PDF files?
@RezaDorrani2 жыл бұрын
Thanks. I have not done any work with exporting attachments to excel. I will recommend checking on the forums at powerusers.microsoft.com/
@raviandsiri Жыл бұрын
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?
@RezaDorrani Жыл бұрын
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.
@gabyc48382 жыл бұрын
Hi Reza. Thanks for the video. Do you know a way to convert xls files to xlsx in power automate without using premium license?
@RezaDorrani2 жыл бұрын
I am not aware of one. I will recommend checking on the forums at powerusers.microsoft.com/
@sergioarguellomontes40192 жыл бұрын
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.
@RezaDorrani2 жыл бұрын
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
@AutomationDose4U11 ай бұрын
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 👍
@RezaDorrani11 ай бұрын
Possible using graph api but not something I have explored
@AutomationDose4U11 ай бұрын
@@RezaDorrani thanks 👍. Really helpful if you have plan to create video on it.
@RezaDorrani11 ай бұрын
@@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.
@AutomationDose4U11 ай бұрын
@@RezaDorrani ohk, thanks buddy for quick help and reply. 🙏 Your videos are truly amazing.
@theoneandonlym102 жыл бұрын
Hey Reza Dorrani thank you very much for this video its amazing. I have a issue. I am getting this error code (Unable to process template language expressions in action 'Create_table' inputs at line '0' and column '0': 'The template language expression 'outputs('A1_Notation_Mapping')[sub(length(outputs('Array_Col_Names')),1)]' cannot be evaluated because array index '352' is outside bounds (0, 25) of array.) It would be great if you could help me out :)
@RezaDorrani2 жыл бұрын
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@ThatsMistaTwistToYou2 жыл бұрын
I had this issue, and it was to do with choice fields - could you double-check your Select Statement (used later by Array col Names) and check that you're using the "[your_choice_field] value" property of the Get Items? without the value, you're getting the whole object, which will be split out into extra headers that will break the flow. At least that's what I worked out. Hope it helps you out!
@shaiksamad15623 жыл бұрын
Hi Reza.. Playing with different components of O365 I have to learn from you.. You make the life easy..
@RezaDorrani3 жыл бұрын
Glad to hear that! Thanks for watching.
@fletchergrimlock68852 жыл бұрын
Love this video Reza! I'm a Flow novice. During the select operation (to select columns), can this be dynamic as well?
@RezaDorrani2 жыл бұрын
Thanks :) Select can be made dynamic but complexity would increase. Something that I have not tried before.
@patrickpaxton48583 жыл бұрын
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!!
@RezaDorrani3 жыл бұрын
Thank you for the feedback. I will try and zoom in more specially when showcasing code.
@tylerkolota2 жыл бұрын
Need to update and/or create many rows in Excel? Try Excel batch actions in Power Automate: kzbin.info/www/bejne/fpqohmZqft1onaM
@RezaDorrani2 жыл бұрын
👍
@yvonnew20103 жыл бұрын
Excellent Reza you rock! Thank you for sharing. I am going to try this out at the weekend. Happy Days!
@RezaDorrani3 жыл бұрын
Have fun!
@okidipekimbambo Жыл бұрын
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.,
@RezaDorrani Жыл бұрын
Glad I could help
@bobohuang224911 күн бұрын
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:(
@RezaDorrani11 күн бұрын
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
@MichaelGreeff3 ай бұрын
Great explanation. Was about to give up on Power Automate and your vid really helped.
@RezaDorrani3 ай бұрын
Never give up
@_jonathanburrows Жыл бұрын
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!
@RezaDorrani Жыл бұрын
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.
@_jonathanburrows Жыл бұрын
@@RezaDorrani Thank you Reza.
@aritramech Жыл бұрын
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
@RezaDorrani Жыл бұрын
Good find
@aritramech Жыл бұрын
@@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.
@wardydoes2 жыл бұрын
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?
@RezaDorrani2 жыл бұрын
Use the create file action to add the file to the SharePoint team site backed by the Microsoft Team.
@LAXMIKANT19923 жыл бұрын
Wonderful. Just one thing how to send the email by sender name as SharePoint site name not by wf owner?
@RezaDorrani3 жыл бұрын
You can send an email from a shared mailbox. There is an action for that in flow.
@tenisviejos3 жыл бұрын
Thank you Reza, the A1 notation mapping resulted WAY easier than I expected 😁 as always, thanks for such a useful and insightful video.
@RezaDorrani3 жыл бұрын
Great to hear! Thank You for watching.
@juandiegoorozco5531 Жыл бұрын
Really usefull, this is just what i needed. thank you for saving my life !! , love your videos
@RezaDorrani Жыл бұрын
Thanks so much for watching and liking the videos
@SusieQ-ok8bo Жыл бұрын
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.
@RezaDorrani Жыл бұрын
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.
@SusieQ-ok8bo Жыл бұрын
@@RezaDorrani Thank you!! I actually just figured it out. The Excel Template, highlighted the entire worksheet and formatted to text then saved. Worked perfectly!!
@msdynamics365cecrmknowledg93 жыл бұрын
Thanks Reza. You are wonderful person. Your explanation is really wonderful.
@RezaDorrani3 жыл бұрын
You are most welcome
@janeg1848 Жыл бұрын
This worked great! I'm using Planner and SharePoint in my solution and have had no issues.
@RezaDorrani Жыл бұрын
👍
@josephnasr33852 жыл бұрын
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?
@RezaDorrani2 жыл бұрын
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.
@josephnasr33852 жыл бұрын
@@RezaDorrani alright I'll update you in case i find something useful. thanks again!
@lauryap2 жыл бұрын
Hi Reza, Incredible explanation, thank you! :D. Would you do similar tutorial for similar case?. I get an excel file everyday, same format of data, just different name referring to the date. Example: Daily_Sales 15.12, Daily_Sales 16.12, Daily_Sales 17.12 and so on. These files are saved in a sharepoint folder. In the same folder I have a Master Data Excel file where I manually add the rows of new file of Daily_Sales comming. I would like to automate the update of my MasterData Excel file everytime we get this new Daily_Sales file, but don't know how 🤔
@RezaDorrani2 жыл бұрын
I do not have a video on this scenario. I add video ideas to my backlog when I get multiple requests on a particular topic. This is the first one on this topic. If I get a lot more requests, I will add it to my backlog. Meanwhile, I will recommend checking the forums at powerusers.microsoft.com/ in case someone has done something similar.
@pratiksoni62158 ай бұрын
Best Powerapps content on entire KZbin.. very easy and detailed explanations.. Thank you so much :)
@RezaDorrani8 ай бұрын
Wow, thanks!
@unbiasedUBR2 жыл бұрын
Hi can you show us how to delete multiple rows in a table or can we replace old data with new in excel table in existing file
@RezaDorrani2 жыл бұрын
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 KZbin channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.
@VenkataKrishnaDaddolu2 жыл бұрын
Hello Reza, How can we extract the Multi people picker values from the list to excel.. Its asking Apply to each action... is there any Formula to directly get the data in Select operation only?.
@RezaDorrani2 жыл бұрын
You will need to use the join expression to get the multiple values (Array) and make it a string joined by the character defined in the expression.
@victordauden91732 жыл бұрын
Dear Reza, big fan of yours here. Just wondering if built in feature Export Excel file (os CSV) directly from sharepoint list would also work. Just downlading the query, placng it ins a shared folder and then sharing that query file (.iqy) with colleagues (link) using Launch function from Power apps via Power automate Thx for your insights! Have not tried it but would make things really easier if it did
@RezaDorrani2 жыл бұрын
It should work. That would be a linked excel file though. Any change made there and re-synced would update SharePoint.
@victordauden91732 жыл бұрын
@@RezaDorrani Thx for inspiring me and letting me think of tweaking things here and there otherwise I wouldnt think of. Just by watching you I get inspired :). Just tried it and it works with my own user. As it is a query file (.iqy) you open it and then you save this query as a new excel file. That very file I tried to update one record from excelfile and it does not upfate Shapoint List. Update only goes one way. So, if it works with my colleagues (Sharepont list members) as well it would even a better solution, really simple as it is a direct download and my colleagues would just use power apps, not Sharepoin List as I intended. Works great so far. Thx for sharing your knowledge Reza
@RezaDorrani2 жыл бұрын
@@victordauden9173 Great!
@scottbrown96595 ай бұрын
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.
@RezaDorrani5 ай бұрын
Most welcome!
@SwastiSundarBose12 күн бұрын
Excellent ! This is a fantastic demo, that one can easily follow. Excel file gets created. But no data gets populated. Although I have successfully fetched data from Azure Devops query and made an array out of the json data. I am stuck at Create a Table part. Repeatedly I am getting BadGateway and created workbook is not getting opened. And also My Workflow is getting time out. I really appreciate if someone suggest any possible solution for it.
@RezaDorrani11 күн бұрын
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
@rishi20893 жыл бұрын
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!
@RezaDorrani3 жыл бұрын
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.
@rishi20893 жыл бұрын
@@RezaDorrani thank you 😊
@golfnutt82 жыл бұрын
Awesome Video. Everything worked like a charm. Thank you!
@RezaDorrani2 жыл бұрын
Most welcome!
@alzaimoor793 жыл бұрын
useful video indeed, everyone request this video, explaining clear as water. much appreciate your effort, keep it up.
@RezaDorrani3 жыл бұрын
Thanks a lot for the amazing feedback.
@alliel99707 күн бұрын
I know this is from 3 years ago, but i am trying to do almost exactly this except from a Sharepoint library not a list- rather that selecting the action of 'Get item' which only allows you to select a list, what would I select for exporting data for library files? I don't need the actual file to be exported, just its metadata. thanks!
@RezaDorrani7 күн бұрын
Get files action should be there. Get items can also point libraries I think. You must enter the name of library manually.
@jekyllhyde056 ай бұрын
Hi, Reza. Excellent video as usual! I need a little bit of help, the value in my SP list under Title column shows 10-9394, but somehow it's being converted as date format (Oct-94 or 10/1/9394) whenever it's being created in my flow. How can I keep the original value which is 10-9394? Any help will be greatly appreciated.
@RezaDorrani6 ай бұрын
Thanks! Im not sure about this.
@davidnavas906511 ай бұрын
Excelente, me ayudó mucho, muchas gracias!, saludos desde Colombia :)
@RezaDorrani11 ай бұрын
Most welcome
@divyabharathi321717 күн бұрын
I am trying to create a dynamic column on today's date and fill it with user response from Outlook ("send email with options"). I cldn't find the dynamically created column in update a row - "Advances parameters". Any ways how to do this ?
@RezaDorrani17 күн бұрын
Not sure why you dont get the dynamic content. You may have to look at writing expressions.
@泰迪熊-c9f10 күн бұрын
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 .
@RezaDorrani10 күн бұрын
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
@PriyadharshiniSuganthi11 ай бұрын
hi @rezadorrani , i have a doubt Iam Exporting the data to Excel from Model Driven App through Power Automate, I have "null" date value in Date and Time Column name, inside Export entity. if iam exporting it, the value (ie., null) in Excel showing "00-01-1900" why? Anybody knows reason, reply me then suggest me a solution to solve this
@RezaDorrani11 ай бұрын
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
@junedahmed14698 ай бұрын
Hello Dorrani, I have created a schedule flow in Power automate that pulls data from one Excel sheet and then pastes it into another sheet. The flow looks like Recurrence>List rows present in a table>Add a row in a table. My flow runs monthly and works fine. My Excel sheet has 13 columns (Professor name, January, February, March........December). But the problem is In January, My flow runs and gives me January data. However, in February, it runs again and it gives me data for February along with January data. I just want new data, not the months that I have already in my sheet. Each month, my colleagues input data in a specific column. For example, , in January, my colleagues made sure which professor was present in that month and input Present/Absent in the January column. In February, she does the same thing for February. Now my manager wants to change my schedule flow in a way that will pull data each month once the data is inputted already and the data should not have any duplicates. Could you please tell me how can I do that in Power Automate?
@RezaDorrani8 ай бұрын
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.
@favourokike8569 ай бұрын
Please I got this error What does this error mean Request to Azure Resource Manager failed with error. '("error" ("code": InvokerConnectionOverrideFailed","message":"Could not find any valid connection for connection reference name 'shared _excelonlinebusiness' in APIM header.")'.
@RezaDorrani9 ай бұрын
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
@gman711573 жыл бұрын
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
@RezaDorrani3 жыл бұрын
If your excel already has a table created (within a sheet), you can just add data in there.
@365g2 жыл бұрын
Great stuff Reza ⚡ - Thanks, this is a big help for a current use case. That dynamic hack is something something else - great find!
@RezaDorrani2 жыл бұрын
Glad it was helpful!
@caroltasseff18273 ай бұрын
I am excited to make this work but unfortunately I keep getting an error on the Create Table action that says the specified file cannot be found. It recommends that I make sure Create File is successfully creating a file, that it is returning the correct file ID, and that the file ID is being passed correctly as a parameter to the Create Table action. A file IS being created. How can I tell if the file ID is correct and is being passed correctly? Btw, my data is coming from a Power app trigger, so I am not sure if that makes a difference or not. My data is all coming out ok in the output of the select action. I'd appreciate a little guidance so very much!
@RezaDorrani3 ай бұрын
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
@josephr2927Ай бұрын
HI Reza , i am getting error while creating table , saying i dont have access to like" the request id forbidden by graph API". How can we proceed on this . Kindly guide me on this.
@RezaDorraniАй бұрын
I have not come experienced the mentioned 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
@Can2jiker2 жыл бұрын
Can you help me with the following error? The 'inputs.parameters' of workflow operation 'Add_a_row_into_a_table_2' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'table'
@RezaDorrani2 жыл бұрын
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
@minhphuc79933 жыл бұрын
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.
@RezaDorrani3 жыл бұрын
I do not have any videos with Planner and flow. I will recommend you check on the forums at powerusers.microsoft.com/
@minhphuc79932 жыл бұрын
@@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.
@RezaDorrani2 жыл бұрын
@@minhphuc7993 About me tab on my KZbin channel has my email address.
@yusenlogistics-externaltra19783 жыл бұрын
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
@RezaDorrani3 жыл бұрын
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
@yusenlogistics-externaltra19783 жыл бұрын
@@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.
@RezaDorrani3 жыл бұрын
@@yusenlogistics-externaltra1978 You are most welcome!
@mjmann24027 ай бұрын
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 🤔
@RezaDorrani7 ай бұрын
Thanks! I do not have a specific video reference on this scenario and would have to try it out to provide guidance.
@techspacex74742 жыл бұрын
hi Reza, I have a case which needed to display a dynamic column table in virtual agent, could you guide how to do? for example: a table with recent rolling 3 month data to be a response and show in a virtual agent chatbot, say, in May, the table will show 'Apr, May Jun' data, then get to Jun, 'May, Jun, Jul' will be displayed. how to achieve it. thank you very much!
@RezaDorrani2 жыл бұрын
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@yashshreeshinde43942 жыл бұрын
I am getting this error:-The request is forbidden by Graph API. Error code is 'AccessDenied'. Error message is 'Could not obtain a WAC access token.'.Anyone can help me out.what am i doing wrong?
@RezaDorrani2 жыл бұрын
I will have to look at your flow in action to provide guidance. Might have to do with some access issue. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@李婉儀-g7v5 ай бұрын
is there a limitation of rows/items from SharePoint to create an Excel file? I want to export 100+ items from SharePoint to an Excel file, but it only has exactly 100 items/rows in the excel. Thanks!
@RezaDorrani5 ай бұрын
Check row count and pagination settings for action. Check documentation.
@murthychitturi25622 жыл бұрын
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?
@RezaDorrani2 жыл бұрын
You can use the select action to pick the columns you need from the array.
@Ratheesh_G_Nambiar4 ай бұрын
Hi, My requirement is that when an email containing an attachment from SFDC is received, proceed to create a new Excel file based on the attachment. Next, generate a new worksheet within the existing file, and populate it with the data from the newly created file. Plz help me.
@RezaDorrani4 ай бұрын
I do not have a video reference on your requirement 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.
@eduardobelisario95565 ай бұрын
In this flow, can I set it up so that 'When a new item is created in SharePoint,' only the new row will be added to my Excel file? For example, if the flow runs today and there are 5 rows, as soon as someone adds another item in SharePoint, it will automatically keep the existing 5 rows and add only 1 new row. Is this flow able to achieve that?
@RezaDorrani5 ай бұрын
Possible. 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.
@2007pradipta Жыл бұрын
While creating Table in SharePoint instead of OD how to provide the library name dynamic? I give it through Environment Variable but says some error like Drive id not found. If u see log in Document library it doesn't show ID instead it show some combination of guid and something
@RezaDorrani Жыл бұрын
I'm not sure about this one. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@kiruthikarajan7397 Жыл бұрын
Hi Reza, I have 4500 records in share point with 80 Columns . Every step per your video is working perfectly but the add the row into table step alone is failing as runtime error . I even turned on the concurrency control to on and
@RezaDorrani Жыл бұрын
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
@rubenpuertosmartinez2 жыл бұрын
Can you export based on an 'ID' from the list? Basically, I want to export from Lists to Excel based on a selectable ID (Ideally from Power Apps, but I'm ok with any option) Great video :) you are a star!
@RezaDorrani2 жыл бұрын
Check my latest video kzbin.info/www/bejne/i4vHn5qorLymp6M
@rubenpuertosmartinez Жыл бұрын
@@RezaDorrani thanks for this great video, I have used most of the features to export an item from a SharePoint list into an excel file, I'm using a template; this template has some sort of mapping to ne ingested by an accounting software, and everytime when I'm creating the excel file, the mapping breaks :( Maping = Formulas (menu) > Name Manager The mapping breaks because I'm creating tables, do you know if there's any solution for these issues ?
@RezaDorrani Жыл бұрын
@@rubenpuertosmartinez I have no clue about this as I have not experienced this issue. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has done something similar
@dorthynovamani5351 Жыл бұрын
Hi, Can u help to create a new flow of current month 1st 15 days new joiners and according to the bands. Ex- A B C D E are bands. I want only A C D bands Exampl
@RezaDorrani Жыл бұрын
I would have to try it out myself to know more. I recommend posting your query on forums at powerusers.microsoft.com
@MusicIhave Жыл бұрын
I have a huge list (over 100 columns). It would take a very long time to use the Select feature to map all the columns manually. Is there any alternative? Like automatically mapping or importing the raw data into an already created table?
@RezaDorrani Жыл бұрын
I am not aware of a dynamic way for 100s of columns. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@jaikoshta4060 Жыл бұрын
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
@RezaDorrani Жыл бұрын
Possible using Power Automate Desktop
@mahalakshmi1404 Жыл бұрын
Hi Sir, Thanks for the video. could you please suggest the solution for the Auto width for the column generated in this excel. Searched even in the comments and in the forum.
@RezaDorrani Жыл бұрын
I am not sure if it is an option and not something I have attempted. Forums will be your best bet (You can also ask a question on forums and see if others have done something similar).
@mohammadriaz86353 ай бұрын
Excellent!, can you help me to create a schedule flow, as i did subscription from the PBI, and saving those file in the one drive my business folder, one is the complete detail and other having summary of the report, so now i need them to share with the team the report as attachment and the summary data need in the email body,
@RezaDorrani3 ай бұрын
I do not have a video reference on this 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