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 !
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.
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.
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.
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.
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 RUclips 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!
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.
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 🙏👍
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!
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 🙏🏻
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 ruclips.net/video/Kupz71dWYyY/видео.html
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
@@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
@@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
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.
Thanks for this video, it's very complete. I'm wondering if the 6 mins delay is also needed when I move files from the initial folder to another folder (for example having a folder per status instead of a column) ?
Amazing video for someone new to power automate! Was able to create new so easily! Thank you! One Question… for the list create item or update condition - can the update excel template only contain a specific column you want updated? Along with the UID so it can match?
Hi Reza, first let me thank you for your exceptional videos. I’ve learned so much just by following your examples. I am struggling a lot with the opposite scenario, ‘Add & update SharePoint List to Excel using Power Automate’. I’ve searched for hours and hours and tried a million options but so far, I couldn’t figure out out to add multiple people (people picker) into excel with only one entry. I managed to do it but it always adds a row for each person on the record. Any help would be appreciated and I’ll be eternally grateful!
Thanks for watching and liking the videos. 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
@@RezaDorrani Thank you so much for getting back to me! I will use the link provided for future questions! And I have so many! I’ve managed to solve this particular problem though, now having a million more! Thank you again, Reza! I couldn’t be where I’m at if it wasn’t for you and your videos.
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.
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
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 the insightful step by step video. It was a life savior. I have a query- in my dataset I have an image column too in the excel. The images are inserted into excel sheet. While running the flow power automate is getting the value of the image. Could you please tell how the images should be inserted into excel so that SharePoint is able to read them and display it?
I do not have a video reference on image scenario and would have to try it out to know more about it. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
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!!!!
Hi Reza, this worked so well for me! Thank you for the step by step. It was very intuitive. I want to know if there is an ability to update the excel and it will modify the exisiting data in the sharepoint list? Basically, open up the excel and then sync with the SharePoint list data?
Amazing solution. Excellent explaination. There is one topic missing - how would you delete SharePoint entries which are not available in the Excel spreadsheet?
Thanks. For that you would want to set a flag(column) of past items in excel that you would want to delete. Read those excel rows and delete them from SharePoint.
This video is wonderful and helped so much! Quick question, do you have another video about the logging results section you showed in the last few minutes of it? It looks like exactly what I need for my failures but I can’t figure out how you did it. If you don’t have a video for it, do you have any recommendations for where I might be able to find more information about how you did it?
I do not have another video reference for it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thanks Reza for this great videos. Your videos are clear and easy to understand. I noticed that when the Excel column name has a "." it will not work. Example "Document No." . When I remove the "." it works ok. Is there a work around for this. Thanks.
Thanks for watching and liking the videos. Not sure of a workaround for this. Best would be to not use . in column name:) I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thank you Reza, for teaching us, I want to perform this activity from Power App, using attached file, Please help me if you have created any tutorial in past
Fantastic video Reza. Thank you very much - I built 2 such flows. 1 flow it works perfectly for me. Another flow has additional columns that need to be updated. When I run the flow, 2 fields from excel (which are populated and are in same format as others), dont show up on the list. They show up as null value. I have checked the settings, excel and other things that I could have thought of. NOt sure why things are not working.
Most welcome. 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
Great Job Reza Thanks a million for your great training materials always, quick question do you have a tutorial on how to export data from sharepoint list to excel using power automate, thanks a million for your great help
@@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. 👍🏻👍🏻
Your demonstration was great! Can you assist in a question. One of my columns in my table I want to make as comments to each created item. How would I go about doing that?
Comments in SharePoint I assume, which is stored differently. I have not done a video on how to do that. I would need to try it out myself to know more about it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@Reza, Excellent video, as always. I got a question about something I didnt understand: how does your Sharepoint doesnt get duplicates every time you run the same file?
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!
Hi reza! This is sooo great! Been watching your tutorials!!! however, i am working on the approvals of newly created and tagged as specific status "for approval" on files saved in the sharepoint library. from there, I need to get the list of all the files tagged as for approval by creating items in the sharepoint list - I tried creating a table inside the files and get the data to be used in the sharepoint list. However, I am really having a hard time connecting your tutorial on the approval workflow and this one - to get the data from excel to sharepoint list. I so much appreciate your help on this! thank you so much in advance!
Thank You! You scenario of approvals on library and tying it to a list is not something I have tried or have a video reference for. I will recommend posting or checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza, Thanks for your video, I have seen that the URL Hyperlink doesn´t have a description, could a description be created instead of showing the entire web page?, example "Link" or the Title's name, thanks
I believe it is possible but by using the SharePoint Rest API. I do not have a video reference on this scenario though. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thank you very much Reza for your answer, please let me know if in the future you will be able to create this condition, I have tried with an Http request but I have not been able to relate it to the hyperlink field.
@@pedromaldonado1541 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 RUclips 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.
HI Reza, First of all thank you so much for making this wonderful video. I have created the similar automated flow based on this video to create or update the record on SharePoint list. I am stuck at update item condition. When I am using single line text column as my unique then it is updating but when I am changing it to lookup driven column the condition is always evaluating to true and creating new record. Can you please suggest if I need to add any additional condition to use lookup column as unique ?
Hi Reza,thanks for sharing such as educated video here. I've followed all steps and not sure if I missed something, it successful but instead of update the data it is adding the same data that I have edited. Appreciate your help on this
Most welcome! 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
Thank you for this video, so much to learn. I haven't finished watching the video but would like to know the username that will be recorded in the "Created by" column of the sharePoint list.
Reza, Thanks for this video. One question, is there a way to tell the flow to skip x number of rows at the top of the Excel spreadsheet? They contain column help text and there are 3 header rows prior to the field name row. Thanks again!!
@@RezaDorrani Thanks...I just joined your channel, and hope to find out how to download flows / apps from your site. Haven't figured that out yet. You have been a great help to me and I want to start paying it back!!
Thanks for joining. Members in gold or silver tier get access to download apps and flows. The info is in community tab of my channel. Check ruclips.net/user/postUgkxOUKdBOVOWPTPRg68XbFrc2a_k8uFGas2?si=WjzPqlaQb5LO4PGd
Thank you so much Reza as always for sharing your knowledge; great video!!! Is it possible to create a document set from excel data using something like this? So instead of adding a SharePoint list item, it creates a document set. Thanks again!
Possible but I do not have a video reference for it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza, your videos are really great, I'm just starting with power automate and SharePoint. Your videos are very easy to follow, thanks a lot for that. Now, I have a job tracking list where I need to calculate a deadline for the recruiter on each position. I have a requisition date column and a Time to complete column, I can calculate the final date pretty straight forward, but I need to exclude sundays from the calculation. I've even found how to exclude weekends, but I need to exclude only sundays. I'm very confused on how to do that, any advise?
Thanks! I dont have any specific video reference for your scenario. Check if ruclips.net/video/ihI7_QneVOI/видео.html helps or try posting your query on forums at powerusers.microsoft.com
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!
Great Video Reza . I have a small doubt whether the null check where you kept it as ' ' , will it also work for single select choice column and number column present in SP list . I am updating my excel to SP list where i am basically putting blank validation expression on all columns when updating / creatinf the list from excel
Its been a long while since I did this video hence do not remember the specifics. Always best to test it out at your end. You can check for '' or trim text and compare etc. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani yup i tried with trial and error and at the end used the empty function , it was working fine with that. Thanks for the video , it helped with other steps where I was stuck.
Thank you, Reza, for another fantastic video! I followed it, and everything was fine, but I have a column where data validation is active in my Sharepoint list. Even if I don't change the value on that column, the update flow fails. I would like to keep that validation on the column because users manually add values in the Sharepoint list, not only by buk update with Excel. Is there any way to also permit Excel import in a Sharepoint List with column validation? Or the only way to make it work is to remove validation from the list? Thank you so much in advance.
Welcome! I have not faced any such issue. As long as the data coming in is valid, it should work. I will recommend checking or posting your issue on the forums at powerusers.microsoft.com/ in case someone has experienced something similar.
Hey Reza,Thanks for the awesome vidoe, i have a Question if we need to move 100K rows do we need to make any changes in the flow to make it more efficient.
Thank you for your great work! It's really helpful. I have one question about Get items, after i added there is error comes "An action failed. No dependent actions succeeded." What can be the reason? Thank you
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
Reza - great job on content, structure and editing! Really the best I've seen on the topic. I don't know how many times I've watched portions of video now to help set up my first flows to have Sharepoint Lists function as filtered "mirrors" of excel workbooks. Did a bit of tweaking to your video as I didn't need to make uses of the dynamic portion. Has been helpful to use the lists to springboard with PowerApps to look up content. Well done! Question for you though - what would be your recommended methodology during the update item step (item already exists in Sharepoint list), that would only update fields that were changed, and leave the others alone. If nothing changed, would skip that item all together. I'm running the flow daily, and everyday it updates every item and every field whether or not there have been changes. Any guidance would be great!
Thanks for the awesome feedback! Update item step - To only perform an update if any change was made in excel, you would have to query SharePoint to grab that specific item and do a comparison of all the fields (a lot more work).
Thanks Reza, awesome videos. I have one specific question: I have built the flow as described and it works perfectly but what I need in a addition is a condition to check for each record whether a specific field in my excel has has a specific value and then update only that one field in my SharePoint List for that record if the value is different (i.e. check for each record if the status field in excel is „closed“ and the status field in SharePoint is „closed“, if that is the case then update the status field in SharePoint for that specific record to „closed“). Thanks for any help and suggestions.
It should be possible, but I would have to try it out to provide guidance. I would recommend posting your use case with screenshots on the forums at powerusers.microsoft.com
Its been a while since I did this video, hence do not remember all the steps. I have done a separate video on error logging. You can check that and see if it helps.
@@RezaDorrani i have it all working apart from when it fails - it stops at append variable - i dont have the filter array as im not sure what that does , but when its successfull it appends the success variable and flows to delay and condition , but if failure it stops
Thanks for your valuable video. Its awesome. What if if there are multiple rows of headers with data across multiple columns like header section to be looked at for each file ?
Hi Reza, Thanks for sharing this video really helpful. Question on the field Subcons where you created an array of multiple user claims by using the split functions and composing the array. However if your excel sheet had blank values for Subcons, the flow throws an error as it does not update null values to the Subcons field in Sharepoint. How can we update null values in that case? Please advise.
I dont have the expression handy but idea would be to do a null check. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Really appreciate your work ..i really like your videos samll question -Is there any way to load Excel data to SharePoint without creating any table in Excelsheet?
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
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
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.
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)
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
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!
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.
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!
41 minutes and 49 seconds of pure gold. Thank you for this video!
Great to hear 👍
Extremely well organized lesson. Straight to the point and well articulated. Thank you for sharing.
Thank You so much
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.
💖
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
Thanks!
Thank You
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 RUclips 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
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!
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.
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!
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
Awesome, have been looking for a good example and this one is great!!
Thanks Johan
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 ruclips.net/video/Kupz71dWYyY/видео.html
@@RezaDorrani thanks for your views...
Reza, simply the-B-e-s-t
Thanks
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.
From beginning till the end there are so many important items covered. Amazing video. Thanks Reza !!
Glad to hear the feedback. Thanks Anshu.
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.
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!
Every video you make is so thorough and helpful! Thank you for making these videos!
You’re most welcome
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!
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 video Ive ever seen. You spoke clearly, you went just slow enough. I absolutely love you man!
Glad to hear it! Thanks so much.
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
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
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
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
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!
Lookup columns is hard work. Thx for the great walk-through 👏👏👏👏
Most welcome
Reza, you are the Power Automate / Power Apps KING!
Thank You so much.
Content is 👑
Thanks for this video, it's very complete. I'm wondering if the 6 mins delay is also needed when I move files from the initial folder to another folder (for example having a folder per status instead of a column) ?
Not sure about the delay in your case. Give it a shot and see what it does.
Awsome work and as i said for your earlier videos, you are my best mentor for Power platform...😀😀😀
Glad to hear that
Amazing video for someone new to power automate! Was able to create new so easily! Thank you! One Question… for the list create item or update condition - can the update excel template only contain a specific column you want updated? Along with the UID so it can match?
The excel template is what you define. You are free to include only columns which you want to update
You are a great teacher, I really enjoy your training videos. Thank You!!!
Glad you like them!
Hi Reza, first let me thank you for your exceptional videos. I’ve learned so much just by following your examples. I am struggling a lot with the opposite scenario, ‘Add & update SharePoint List to Excel using Power Automate’. I’ve searched for hours and hours and tried a million options but so far, I couldn’t figure out out to add multiple people (people picker) into excel with only one entry. I managed to do it but it always adds a row for each person on the record. Any help would be appreciated and I’ll be eternally grateful!
Thanks for watching and liking the videos.
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
@@RezaDorrani Thank you so much for getting back to me! I will use the link provided for future questions! And I have so many! I’ve managed to solve this particular problem though, now having a million more! Thank you again, Reza! I couldn’t be where I’m at if it wasn’t for you and your videos.
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.
This is what expected few months.. great Reza. You are masterpiece in this industry...
Thank You!
Incredibly helpful! Awesome! I am new to power automate and this was such a thorough and detailed walkthrough. Thanks!
Reza, big Thank you for what you do and teach, I really appreciate it. You are a great and expert trainer.
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.
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 the insightful step by step video. It was a life savior. I have a query- in my dataset I have an image column too in the excel. The images are inserted into excel sheet. While running the flow power automate is getting the value of the image. Could you please tell how the images should be inserted into excel so that SharePoint is able to read them and display it?
I do not have a video reference on image scenario and would have to try it out to know more about it. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
wow most detailed sharepoint flow tutorial ever. thanks!
Wow! Thank You for watching.
Good stuff Reza... Single video with lot of use cases and expressions... Thank you
Glad you liked it!
as always, thank you very much for taking your time to record, explain, edit and share all this knowledge!
You are most welcome
Thank you so much! I explored many options before finally discovering your approach.
Glad it helped!
Best tutorial on excel automation i've seen
Wow! Thank You!
Hello Reza,
Your videos have been so helpful to build Power Apps & Power Automate. Thanks So much
Glad to hear that!
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.
You made my day! thanks for this great video Reza, greetings from Argentina😀
Happy to hear that! Have a great day!
Hi Reza, this worked so well for me! Thank you for the step by step. It was very intuitive. I want to know if there is an ability to update the excel and it will modify the exisiting data in the sharepoint list? Basically, open up the excel and then sync with the SharePoint list data?
There is no sync feature in excel for SharePoint. You will need to run flow again.
Thank you for this awesome tutorial, Reza! You are awesome as per usual! ❤
You're most welcome and thank you for watching
Reza, my hero. Again, this is exactly what I was looking for to solve a problem at work. Thanks!!!!
Awesome!
Amazing solution. Excellent explaination. There is one topic missing - how would you delete SharePoint entries which are not available in the Excel spreadsheet?
Thanks.
For that you would want to set a flag(column) of past items in excel that you would want to delete.
Read those excel rows and delete them from SharePoint.
Saved my butt again Reza... quick, concise, spot-on help. You Rock!
Most welcome
This video is wonderful and helped so much! Quick question, do you have another video about the logging results section you showed in the last few minutes of it? It looks like exactly what I need for my failures but I can’t figure out how you did it.
If you don’t have a video for it, do you have any recommendations for where I might be able to find more information about how you did it?
I do not have another video reference for it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thanks Reza for this great videos. Your videos are clear and easy to understand. I noticed that when the Excel column name has a "." it will not work. Example "Document No." . When I remove the "." it works ok. Is there a work around for this. Thanks.
Thanks for watching and liking the videos.
Not sure of a workaround for this. Best would be to not use . in column name:)
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thank you Reza, for teaching us,
I want to perform this activity from Power App, using attached file,
Please help me if you have created any tutorial in past
Welcome!
I dont remember doing a video on that.
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!
Fantastic video Reza. Thank you very much - I built 2 such flows. 1 flow it works perfectly for me. Another flow has additional columns that need to be updated. When I run the flow, 2 fields from excel (which are populated and are in same format as others), dont show up on the list. They show up as null value. I have checked the settings, excel and other things that I could have thought of. NOt sure why things are not working.
Most welcome.
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
Great video, which solved all of my problems. Well, at least all of my Power Automate problems. 😀
Glad it helped!
Great Job Reza Thanks a million for your great training materials always, quick question do you have a tutorial on how to export data from sharepoint list to excel using power automate, thanks a million for your great help
Most welcome!
I have done a video or 2 on that topic.
Search for “export to excel reza dorrani”
Hi Reza, this is awesome and helped me immensely! You rock!
Glad it helped!
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 😎
Your demonstration was great! Can you assist in a question. One of my columns in my table I want to make as comments to each created item. How would I go about doing that?
Comments in SharePoint I assume, which is stored differently. I have not done a video on how to do that. I would need to try it out myself to know more about it.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@Reza, Excellent video, as always. I got a question about something I didnt understand: how does your Sharepoint doesnt get duplicates every time you run the same file?
Because I check to see if item exists then update else add. This is shown in video
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.
Hi reza! This is sooo great! Been watching your tutorials!!! however, i am working on the approvals of newly created and tagged as specific status "for approval" on files saved in the sharepoint library. from there, I need to get the list of all the files tagged as for approval by creating items in the sharepoint list - I tried creating a table inside the files and get the data to be used in the sharepoint list. However, I am really having a hard time connecting your tutorial on the approval workflow and this one - to get the data from excel to sharepoint list. I so much appreciate your help on this! thank you so much in advance!
Thank You!
You scenario of approvals on library and tying it to a list is not something I have tried or have a video reference for. I will recommend posting or checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza, Thanks for your video, I have seen that the URL Hyperlink doesn´t have a description, could a description be created instead of showing the entire web page?, example "Link" or the Title's name, thanks
I believe it is possible but by using the SharePoint Rest API. I do not have a video reference on this scenario though. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thank you very much Reza for your answer, please let me know if in the future you will be able to create this condition, I have tried with an Http request but I have not been able to relate it to the hyperlink field.
@@pedromaldonado1541 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 RUclips 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.
Great work man as always!, one question, how can I only add newly added rows to List, not entire table.
Video shows how to add newly added rows to list.
Most useful... special for Lookup and all type column... Thanks Reza..
Most welcome!
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!
really .its very good example to check duplicate /existing items and update status.
Glad you liked it
HI Reza,
First of all thank you so much for making this wonderful video. I have created the similar automated flow based on this video to create or update the record on SharePoint list. I am stuck at update item condition. When I am using single line text column as my unique then it is updating but when I am changing it to lookup driven column the condition is always evaluating to true and creating new record. Can you please suggest if I need to add any additional condition to use lookup column as unique ?
I have not faced this issue, so not sure. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza,thanks for sharing such as educated video here. I've followed all steps and not sure if I missed something, it successful but instead of update the data it is adding the same data that I have edited. Appreciate your help on this
Most welcome!
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
Thank you for this video, so much to learn. I haven't finished watching the video but would like to know the username that will be recorded in the "Created by" column of the sharePoint list.
The person under whose context the flow is running under.
Reza you're the best!!!!! thanks a lot for this video.
Thank You!
Amazing video. You have covered all the possible scenarios.
Glad to hear that
Reza, Thanks for this video. One question, is there a way to tell the flow to skip x number of rows at the top of the Excel spreadsheet? They contain column help text and there are 3 header rows prior to the field name row. Thanks again!!
I believe there are expressions for that. Might be something called skip. Il recommend checking flow documentation
@@RezaDorrani Thanks...I just joined your channel, and hope to find out how to download flows / apps from your site. Haven't figured that out yet. You have been a great help to me and I want to start paying it back!!
Thanks for joining.
Members in gold or silver tier get access to download apps and flows. The info is in community tab of my channel.
Check ruclips.net/user/postUgkxOUKdBOVOWPTPRg68XbFrc2a_k8uFGas2?si=WjzPqlaQb5LO4PGd
@@RezaDorrani I just upgraded to Silver tier. Trying to find the place to download now...
Is this flow too old to be downloaded? Don't see a link to download the flow
Thank you so much Reza as always for sharing your knowledge; great video!!! Is it possible to create a document set from excel data using something like this? So instead of adding a SharePoint list item, it creates a document set. Thanks again!
Possible but I do not have a video reference for it.
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani thanks Bro!
Hi Reza, your videos are really great, I'm just starting with power automate and SharePoint. Your videos are very easy to follow, thanks a lot for that. Now, I have a job tracking list where I need to calculate a deadline for the recruiter on each position. I have a requisition date column and a Time to complete column, I can calculate the final date pretty straight forward, but I need to exclude sundays from the calculation. I've even found how to exclude weekends, but I need to exclude only sundays. I'm very confused on how to do that, any advise?
Thanks!
I dont have any specific video reference for your scenario.
Check if ruclips.net/video/ihI7_QneVOI/видео.html helps or try posting your query on forums at powerusers.microsoft.com
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
Great Video Reza . I have a small doubt whether the null check where you kept it as ' ' , will it also work for single select choice column and number column present in SP list .
I am updating my excel to SP list where i am basically putting blank validation expression on all columns when updating / creatinf the list from excel
Its been a long while since I did this video hence do not remember the specifics. Always best to test it out at your end. You can check for '' or trim text and compare etc. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani yup i tried with trial and error and at the end used the empty function , it was working fine with that.
Thanks for the video , it helped with other steps where I was stuck.
Thank you, Reza, for another fantastic video! I followed it, and everything was fine, but I have a column where data validation is active in my Sharepoint list. Even if I don't change the value on that column, the update flow fails. I would like to keep that validation on the column because users manually add values in the Sharepoint list, not only by buk update with Excel. Is there any way to also permit Excel import in a Sharepoint List with column validation? Or the only way to make it work is to remove validation from the list? Thank you so much in advance.
Welcome!
I have not faced any such issue. As long as the data coming in is valid, it should work.
I will recommend checking or posting your issue on the forums at powerusers.microsoft.com/ in case someone has experienced something similar.
Hey Reza,Thanks for the awesome vidoe, i have a Question if we need to move 100K rows do we need to make any changes in the flow to make it more efficient.
100k is a lot of data and you will run into throttling issues. Best to explore bulk apis in SharePoint to add data.
Thank you for your great work! It's really helpful. I have one question about Get items, after i added there is error comes "An action failed. No dependent actions succeeded." What can be the reason?
Thank you
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
Reza - great job on content, structure and editing! Really the best I've seen on the topic. I don't know how many times I've watched portions of video now to help set up my first flows to have Sharepoint Lists function as filtered "mirrors" of excel workbooks. Did a bit of tweaking to your video as I didn't need to make uses of the dynamic portion. Has been helpful to use the lists to springboard with PowerApps to look up content. Well done!
Question for you though - what would be your recommended methodology during the update item step (item already exists in Sharepoint list), that would only update fields that were changed, and leave the others alone. If nothing changed, would skip that item all together. I'm running the flow daily, and everyday it updates every item and every field whether or not there have been changes. Any guidance would be great!
Thanks for the awesome feedback!
Update item step - To only perform an update if any change was made in excel, you would have to query SharePoint to grab that specific item and do a comparison of all the fields (a lot more work).
Wow. You covered a lot of subjects. Thank you for helping me to improve my skills
Thanks Anthony
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.
Thanks Reza, awesome videos.
I have one specific question: I have built the flow as described and it works perfectly but what I need in a addition is a condition to check for each record whether a specific field in my excel has has a specific value and then update only that one field in my SharePoint List for that record if the value is different (i.e. check for each record if the status field in excel is „closed“ and the status field in SharePoint is „closed“, if that is the case then update the status field in SharePoint for that specific record to „closed“). Thanks for any help and suggestions.
It should be possible, but I would have to try it out to provide guidance. I would recommend posting your use case with screenshots on the forums at powerusers.microsoft.com
I have the same question, Sven, were you able to compare and update only if there was a difference in values on the spreadsheet row?
Could you explain the error log a bit more - struggled getting that working but the rest was spot on
Its been a while since I did this video, hence do not remember all the steps. I have done a separate video on error logging. You can check that and see if it helps.
@@RezaDorrani i have it all working apart from when it fails - it stops at append variable - i dont have the filter array as im not sure what that does , but when its successfull it appends the success variable and flows to delay and condition , but if failure it stops
@@harrystephenson1101 I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Thanks for your valuable video. Its awesome. What if if there are multiple rows of headers with data across multiple columns like header section to be looked at for each file ?
Most welcome!
I don’t have a video reference on that scenario and something I have not come across so not sure.
Hi Reza, Thanks for sharing this video really helpful. Question on the field Subcons where you created an array of multiple user claims by using the split functions and composing the array. However if your excel sheet had blank values for Subcons, the flow throws an error as it does not update null values to the Subcons field in Sharepoint. How can we update null values in that case? Please advise.
I dont have the expression handy but idea would be to do a null check.
I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Really appreciate your work ..i really like your videos samll question -Is there any way to load Excel data to SharePoint without creating any table in Excelsheet?
Power Automate actions do need a table to work with excel data.
You can also create tables dynamically. Check ruclips.net/video/Kupz71dWYyY/видео.html
I am learning always from your video😀
Glad to hear that