I will be the first to comment, haven't even watched the video yet. Confident that you always come through with the best step-by-step guided tutorials on the Power platform. 😀...
Absolutely phenomenal. I was building a flow to talk directly to Salesforce via their premium connector but it was such a heavy operation (s) to get all the values ,etc. Then realised I could use Excel to talk to a preconfigured report in sales force which would give me the values I needed without multiple lookups and then to use this file to update SharePoint. Your video could not have been posted at such an appropriate time. It's gonna save me days of figuring out stuff. And I learnt so many new things. You are a genius and I thank you for sharing your knowledge to bring the rest of us (ok I am referring to myself) to about 5% of your level !
II spent several days and several videos trying to find the solution to my problem and with you, no matter how long the video was, I managed to get my flow working. I really appreciate the time you spent explaining this task so well, thank you so much.
Thank you very much for this video, excellent work! I have a large excel file (4000+ rows) that would have taken several hours for this exact method to update every row each day. In my scenario, only a few dozen cells change each day in the Excel Spreadsheet, so not every one of the 4000+ rows really needed to update each day. As a solution, I created a Data connection in my Excel file which pulls down the SP List. Then I created 3 Merges in PowerQuery for Excel, which produced 3 separate Tables. One table contains items that need to be "Added to Sharepoint", another table contains items that need to be "Deleted from Sharepoint", and the 3rd table contains items which need to be "Updated in Sharepoint". From there I used the concepts in Reza's video to create 3 parallel branches of "Apply to Each" in PowerAutomate: "Create item", "Update Item", and "Delete Item". Only updating the rows where a change has been made has worked flawlessly and only takes about 4 minutes to run each day.
The video covers complex processes. Will require a number of views to even begin to grasp the subject matter covered. But if you are serious about automation this is a MUST VIEW video. Thank you Reza. Keep up the good work.
This is really one of the most helpful tutorials on Sharepoint that I have seen. Thanks for all the incremental steps as well. It helps to prevent issues in my particular case, and I appreciate the clarity and excellent teaching.
A lot to digest, but *extremely* helpful, thank you! I learned quite a bit in one sitting. I will have to play & pause to get some details right, but you have paced this in such a way that won't be as difficult to do. Thanks again for taking the time to create this.
Thank you so much reza, I was struck at adding multiple persons to a SharePoint column but you solved my problem thanks a lot Every time regarding power apps or power automate if I struck I'll come to your videos only thanks a lot for helping
Hi Rezza...thank you for posting this video. Creating the flow proved to be so efficient in inserting over 4000 rows of data from a spreadsheet to a list in SPO. Keep up the good work.
Extremely useful information. This is something that is needed in many scenarios for solutions built in SharePoint. There are some tricky things to address when moving the data. Thanks!
This is really great. Could you please create a seperate complete video around error handling. That would be really helpful. Once again thank you for sharing your knowledge.
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. 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.
I'm with you Akash! I'd love a deep dive into what is going on at the end.:) Thank you Reza for all that you do! You've taught me (us) SOOOO much! Thank YOU!
@@RezaDorrani I remember I saw one of your video about Master Detail like invoice data entry in powerapp.. Do you have that link. i tried to find but cant find it. thanks
That magic of video editing that you do not have wait for delay action to finish running. BTW in my test tenant update file properties 2 action after 6 minutes delay ended with 400 error. Icreased the delay up to 10 minutes, flow ran successfully. Thanks for sharing 🙏👍
Really a gem Reza. Though it looks like a very simple and easy topic, I experienced that it is really very complex activity to import data from Excel to SP List. You have explained very complex part like adding multiselect choice fields, multiselect person field, date and time field with the classic workaround are really great. This I would say you demonstrated a complete solution all together. Thanks a lot as always 🙏🏻
@@RezaDorrani Please every time I run my flow (until Create item), it duplicates the items. I have 02 items at my excel and is created 04 items at SP List. My SP List has only columns text. Could you give a hint, please?
@@diltoncesarjunior1848 I have not experienced this issue. I will recommend checking or posting your query on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani You will not believe that am a finance guy but I built a whole new app using your trainings and we will soon be using this across organisation. Kudos to your learning session. Thank you so much. 👍🏻👍🏻
Thanks so much for this video. You explained very well and allowed me to help me provide an over 4000 line list to an app that we are using to search for parts. GREAT JOB!!!!
These are the kind of channels I subscribe to. This was simply brilliant!!! Thank you. Now where is that bell notification I need to stay tuned to all you future videos.
Thank you so much for this video! I have been looking for an example of how to do this and your example is great. I will be sure to check your site when I need an example in the future!
Super video. Even though I have been using Excel connectors for the past couple of years, there’s no always some details in your videos that helps me to increase the flow performances. Thanks Rezza
@@RezaDorrani You are so fast replying! I wanted to edit my comment and add a question which is whether one can have multiple sheets on the excel file and if so how does one would direct power automate to refer to that specific Sheet?
Hola Reza, pero que excelente tutorial siguiendo tus videos he podido aprender mucho sobre powerapps y power automate gracias por compartir tu conocimiento y explicar tan bien!
Hi Reza, thanks for the quality content. Big fan of you. I have some suggestions like 1. Instead of adding 6 minutes delay, add "do untill" for file check out, if it fail I add 1 minute delay if success, go ahead. It will reduce flow run time. As files which are Not checked out need not to wait for 6 minutes 2. You have handled dates columns by converting to UTC and then again additional helper column in templates, I usually updates excel dates using addDays formula in flow to update sharepoint list which I found more convenient. Adding helper column may not be possible for many cases. Like My users get data from on premises application export to excel which is used to update SP List. 3. In your case as you are using templates so it will not be applicable in your used case , but I do check if excel file has table or not.
Thanks for watching & liking my videos. 1 - I believe the list rows present in a table action does lock file ASAP and that delay would be needed. However, no harm in checking file lock status every minute. A better approach would be to let all files process and then at the end wait for 6 minutes and update status of each file. 2 - You could do those calculations in flow as well. The goal of the video was to keep content to 100-200 level and there is a reason why I showcased things in a particular order :) 3 - Typically such scenarios do include a template with defined columns. I did a video on dynamic tables in excel. Check ua-cam.com/video/Kupz71dWYyY/v-deo.html
This is so great. At the end you talked about creating a success or failure log, and I wonder if there is another video showing how to do that? Thanks again for great content.
I do not have a specific video reference on that. Idea would be to add error handling to the actions using (configure run after) to track items which passed vs failed and accordingly log them in a list or excel file.
Thank you, Reza, for such a wonderful video. I would like to learn more about setting up the Failure Log step-by-step. Wondering if there is a video on that topic. Thank you.
Great video, now users can still make entry on excel spreadsheet to be loaded to SP list and I can Create canvas App using the same SP list. no more delegation issue bc I can use the SP list as a data source for my boss. Thanks Reza !!!
WOW! Best setup explanation E.V.E.R. Thanks Reza, you delivered it in a simple, easy to understand way in describing the nomenclature and syntax. I learned about a lot of other facets to data connections.
I will be the first to comment, haven't even watched the video yet. Confident that you always come through with the best step-by-step guided tutorials on the Power platform. 😀...
Wow, thank you but I would love to hear your feedback on the video whenever you get a chance to watch it :)
@@RezaDorrani I will surely watch it during my Power Hour, currently at work.
@@amigomusa “power hour” love it
You and Shane young are basically carrying my career on your backs
Thank You so much for watching our videos. We try our best our best to share our learnings.
(Speaking on behalf of Shane as well)
41 minutes and 49 seconds of pure gold. Thank you for this video!
Great to hear 👍
Absolutely phenomenal. I was building a flow to talk directly to Salesforce via their premium connector but it was such a heavy operation (s) to get all the values ,etc. Then realised I could use Excel to talk to a preconfigured report in sales force which would give me the values I needed without multiple lookups and then to use this file to update SharePoint. Your video could not have been posted at such an appropriate time. It's gonna save me days of figuring out stuff. And I learnt so many new things.
You are a genius and I thank you for sharing your knowledge to bring the rest of us (ok I am referring to myself) to about 5% of your level !
Glad to hear the video is helpful! Thanks so much for sharing your scenario.
II spent several days and several videos trying to find the solution to my problem and with you, no matter how long the video was, I managed to get my flow working. I really appreciate the time you spent explaining this task so well, thank you so much.
Glad it helped! Thanks so much for watching and liking the video.
Thank you very much for this video, excellent work! I have a large excel file (4000+ rows) that would have taken several hours for this exact method to update every row each day. In my scenario, only a few dozen cells change each day in the Excel Spreadsheet, so not every one of the 4000+ rows really needed to update each day.
As a solution, I created a Data connection in my Excel file which pulls down the SP List. Then I created 3 Merges in PowerQuery for Excel, which produced 3 separate Tables. One table contains items that need to be "Added to Sharepoint", another table contains items that need to be "Deleted from Sharepoint", and the 3rd table contains items which need to be "Updated in Sharepoint". From there I used the concepts in Reza's video to create 3 parallel branches of "Apply to Each" in PowerAutomate: "Create item", "Update Item", and "Delete Item". Only updating the rows where a change has been made has worked flawlessly and only takes about 4 minutes to run each day.
Thanks for sharing David!
But you cannot run the Power Query automatically right? For doing that you should open excel at least once
It's always the best when I google a very specific scenario and a video from Reza documenting exactly what I'm trying to do pops up.
💖
The video covers complex processes. Will require a number of views to even begin to grasp the subject matter covered. But if you are serious about automation this is a MUST VIEW video. Thank you Reza. Keep up the good work.
You are most welcome!
This is really one of the most helpful tutorials on Sharepoint that I have seen. Thanks for all the incremental steps as well. It helps to prevent issues in my particular case, and I appreciate the clarity and excellent teaching.
Most welcome!
A lot to digest, but *extremely* helpful, thank you! I learned quite a bit in one sitting. I will have to play & pause to get some details right, but you have paced this in such a way that won't be as difficult to do. Thanks again for taking the time to create this.
Glad it was helpful!
Every video you make is so thorough and helpful! Thank you for making these videos!
You’re most welcome
Extremely well organized lesson. Straight to the point and well articulated. Thank you for sharing.
Thank You so much
Thank you so much reza, I was struck at adding multiple persons to a SharePoint column but you solved my problem thanks a lot
Every time regarding power apps or power automate if I struck I'll come to your videos only thanks a lot for helping
Very happy to hear the videos are helping resolve issues. One of the main reasons I make them.
Hi Rezza...thank you for posting this video. Creating the flow proved to be so efficient in inserting over 4000 rows of data from a spreadsheet to a list in SPO. Keep up the good work.
Most welcome
Man, you are the best! Continue to do the work you are doing, because you are helping so many people! Congratulations.
Thank You for your kind words. I will keep trying my best.
wow most detailed sharepoint flow tutorial ever. thanks!
Wow! Thank You for watching.
Extremely useful information. This is something that is needed in many scenarios for solutions built in SharePoint. There are some tricky things to address when moving the data. Thanks!
You're very welcome!
Reza, you are the Power Automate / Power Apps KING!
Thank You so much.
Content is 👑
This is really great. Could you please create a seperate complete video around error handling. That would be really helpful.
Once again thank you for sharing your knowledge.
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.
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.
I'm with you Akash! I'd love a deep dive into what is going on at the end.:) Thank you Reza for all that you do! You've taught me (us) SOOOO much! Thank YOU!
@@RezaDorrani the error handling would be very useful
Awesome, have been looking for a good example and this one is great!!
Thanks Johan
From beginning till the end there are so many important items covered. Amazing video. Thanks Reza !!
Glad to hear the feedback. Thanks Anshu.
Reza, simply the-B-e-s-t
Thanks
There was a piece in this video that really helped me that I was struggling with, thank you so much Reza for your valuable knowledge and videos 🙏
You're so welcome!
Great tutorial. The best thing this is a professional tutorial.. Everything explain well.
Glad you think so! Thanks so much for watching.
@@RezaDorrani I remember I saw one of your video about Master Detail like invoice data entry in powerapp.. Do you have that link. i tried to find but cant find it. thanks
@@smaheen Honestly I do not remember:)
Check playlists on my channel.
Best tutorial on excel automation i've seen
Wow! Thank You!
Lookup columns is hard work. Thx for the great walk-through 👏👏👏👏
Most welcome
Thank you so much! I explored many options before finally discovering your approach.
Glad it helped!
That magic of video editing that you do not have wait for delay action to finish running. BTW in my test tenant update file properties 2 action after 6 minutes delay ended with 400 error. Icreased the delay up to 10 minutes, flow ran successfully. Thanks for sharing 🙏👍
Video editing magic but in reality, I had to wait for 6 mins :)
I agree with that issue. If you set it to 7 mins you should be good.
Best video Ive ever seen. You spoke clearly, you went just slow enough. I absolutely love you man!
Glad to hear it! Thanks so much.
Saved my butt again Reza... quick, concise, spot-on help. You Rock!
Most welcome
Really a gem Reza. Though it looks like a very simple and easy topic, I experienced that it is really very complex activity to import data from Excel to SP List. You have explained very complex part like adding multiselect choice fields, multiselect person field, date and time field with the classic workaround are really great. This I would say you demonstrated a complete solution all together. Thanks a lot as always 🙏🏻
Thanks so much for the appreciation Akshay
You are a great teacher, I really enjoy your training videos. Thank You!!!
Glad you like them!
This is what expected few months.. great Reza. You are masterpiece in this industry...
Thank You!
This worked perfectly and saved me hours of work manually migrating items to a SP list! You are much appreciated Reza!
You are most welcome
Great video, which solved all of my problems. Well, at least all of my Power Automate problems. 😀
Glad it helped!
Thank you so much as usual Reza! I have learnt many new ideas from this video. You are the backbone of our success in our work environment.
Wow, thank you
I wish you knew how much I APPRECIATE you, Reza! I have learned so much from your tutorials and couldn't do my job without them!
You are so welcome!
Reza, big Thank you for what you do and teach, I really appreciate it. You are a great and expert trainer.
Most welcome
Good stuff Reza... Single video with lot of use cases and expressions... Thank you
Glad you liked it!
really .its very good example to check duplicate /existing items and update status.
Glad you liked it
Thank you for this awesome tutorial, Reza! You are awesome as per usual! ❤
You're most welcome and thank you for watching
Most useful... special for Lookup and all type column... Thanks Reza..
Most welcome!
Incredibly helpful! Awesome! I am new to power automate and this was such a thorough and detailed walkthrough. Thanks!
Reza, my hero. Again, this is exactly what I was looking for to solve a problem at work. Thanks!!!!
Awesome!
Amazing video. You have covered all the possible scenarios.
Glad to hear that
Awsome work and as i said for your earlier videos, you are my best mentor for Power platform...😀😀😀
Glad to hear that
You made my day! thanks for this great video Reza, greetings from Argentina😀
Happy to hear that! Have a great day!
Reza you're the best!!!!! thanks a lot for this video.
Thank You!
Congrats Reza, very useful content. You are the bested at Power Platform. I'll study and try do it. Tks a lot
Most welcome!
@@RezaDorrani Please every time I run my flow (until Create item), it duplicates the items. I have 02 items at my excel and is created 04 items at SP List. My SP List has only columns text. Could you give a hint, please?
@@diltoncesarjunior1848 I have not experienced this issue. I will recommend checking or posting your query on forums in case someone has experienced something similar powerusers.microsoft.com
Excellent information Reza. You have helped me learn so much. Appreciate all your long hours of time and effort making your videos. 🙂
Most welcome and thanks so much for watching
Hi Reza, this is awesome and helped me immensely! You rock!
Glad it helped!
This guy is good. One of the best I have seen. Subscribed!
Thanks for the sub Anthony
@@RezaDorrani You are more than welcome, I look forward to learning more from you!
as always, thank you very much for taking your time to record, explain, edit and share all this knowledge!
You are most welcome
Indeed your videos are very informative. I have learnt so much from these videos.
Glad you like them!
@@RezaDorrani You will not believe that am a finance guy but I built a whole new app using your trainings and we will soon be using this across organisation. Kudos to your learning session. Thank you so much. 👍🏻👍🏻
@@karun036 Awesome 😎
Thanks so much for this video. You explained very well and allowed me to help me provide an over 4000 line list to an app that we are using to search for parts. GREAT JOB!!!!
Glad to hear that! Thanks so much for watching.
Many topics were covered! Amazing video!
Thank You
These are the kind of channels I subscribe to. This was simply brilliant!!! Thank you. Now where is that bell notification I need to stay tuned to all you future videos.
Welcome aboard!
Hello Reza,
Your videos have been so helpful to build Power Apps & Power Automate. Thanks So much
Glad to hear that!
And there I was thinking oh I know how to do that before watching the video lol, amazing content Reza!
Thanks for watching. I did a lot of research before making this video :)
I wanted to ensure I cover all bases.
Thank you so much for this video! I have been looking for an example of how to do this and your example is great. I will be sure to check your site when I need an example in the future!
Awesome! Thanks for watching and liking the video.
I am learning always from your video😀
Glad to hear that
Amazing tutorials! Thanks a lot!
Thanks Angelica
Thank you Reza. Always great tutorial and easy to follow
Glad to hear that!
The video was super helpful and it helped me build the same for my work. Thank you so much for preparing and sharing the video.
You are most welcome!
Super video. Even though I have been using Excel connectors for the past couple of years, there’s no always some details in your videos that helps me to increase the flow performances. Thanks Rezza
Great to hear! Thanks for watching.
Wow. You covered a lot of subjects. Thank you for helping me to improve my skills
Thanks Anthony
very good example! I am looking for this since yesterday! thank you!
Glad it was helpful!
Very well explained and worked like charm
Thanks
What a lesson! Thank you so much for the video!
Most welcome
Your videos are brilliant. Very helpful
Thank you again for another excellent presentation.
Most welcome
@@RezaDorrani You are so fast replying! I wanted to edit my comment and add a question which is whether one can have multiple sheets on the excel file and if so how does one would direct power automate to refer to that specific Sheet?
@@ion669 Add multiple tables in multiple sheets. And then replicate the logic in flow.
As usual, super informative video. THANKS
You’re most welcome
Hola Reza, pero que excelente tutorial siguiendo tus videos he podido aprender mucho sobre powerapps y power automate gracias por compartir tu conocimiento y explicar tan bien!
bienvenido
Reza ! You are the best !
Thank You 😊
Hi Reza, thanks for the quality content. Big fan of you. I have some suggestions like
1. Instead of adding 6 minutes delay, add "do untill" for file check out, if it fail I add 1 minute delay if success, go ahead. It will reduce flow run time. As files which are Not checked out need not to wait for 6 minutes
2. You have handled dates columns by converting to UTC and then again additional helper column in templates, I usually updates excel dates using addDays formula in flow to update sharepoint list which I found more convenient. Adding helper column may not be possible for many cases. Like My users get data from on premises application export to excel which is used to update SP List.
3. In your case as you are using templates so it will not be applicable in your used case , but I do check if excel file has table or not.
Thanks for watching & liking my videos.
1 - I believe the list rows present in a table action does lock file ASAP and that delay would be needed. However, no harm in checking file lock status every minute.
A better approach would be to let all files process and then at the end wait for 6 minutes and update status of each file.
2 - You could do those calculations in flow as well. The goal of the video was to keep content to 100-200 level and there is a reason why I showcased things in a particular order :)
3 - Typically such scenarios do include a template with defined columns.
I did a video on dynamic tables in excel. Check ua-cam.com/video/Kupz71dWYyY/v-deo.html
@@RezaDorrani thanks for your views...
Brilliant video - really useful - thanks for posting.
Thanks for watching and liking
Thank you. This helped me. Exactly what I was looking for.
Great to hear!
top class video, Reza. Awesome, keep it going.!
Thanks Shiva
This is so great. At the end you talked about creating a success or failure log, and I wonder if there is another video showing how to do that? Thanks again for great content.
I do not have a specific video reference on that. Idea would be to add error handling to the actions using (configure run after) to track items which passed vs failed and accordingly log them in a list or excel file.
Amazing video, Thanks for the wonderful explanation
My pleasure
Welcome to Reza University on Power Platform :), these are immensely helpful
Thanks Sandeep
A great video once again.. thank u so much Reza for the efforts you would have put in...
Thanks so much
God bless you bro. You've helped me so much!
Glad to help
Was exactly what I was looking for. Thanks!
Your most welcome
Outstanding video
I have never seen such a thing before..
Thank You :)
Thank you, Reza, for such a wonderful video. I would like to learn more about setting up the Failure Log step-by-step. Wondering if there is a video on that topic. Thank you.
Most welcome!
I dont have a step by step video on that.
Great video as always. Lots of learning. Thanks for your efforts and time, very nice step-by-step presentation.
Many thanks!
Great video Reza, you game me a lot of tips and ideas.
Glad to hear it!
Thank you for your time and really helpful Reza!!
My pleasure!
Reza you are the best, thanks
Thank You :)
this is absolute brilliant work.. thank you so much for sharing it
Thanks so much
Asusual Reza You rocked it 🤗🤗
Thanks
Thank you for your knowlege sharing! It lavarage our skills a lots
My pleasure!
thank you from Poland
Welcome!
Excellent video, much apprecaited.
Most welcome
Great video, now users can still make entry on excel spreadsheet to be loaded to SP list and I can Create canvas App using the same SP list. no more delegation issue bc I can use the SP list as a data source for my boss. Thanks Reza !!!
Most welcome
Thank You , Ready for March Demo
Absolutely! Ready for it 🔥
Thanks in a million.Great content.
Thanks for watching
WOW! Best setup explanation E.V.E.R. Thanks Reza, you delivered it in a simple, easy to understand way in describing the nomenclature and syntax. I learned about a lot of other facets to data connections.
Thanks for the awesome feedback. You are most welcome!
This is excellent. Thank you!
Thanks for watching