Add & Update Excel Data to SharePoint List using Power Automate | Excel Import using flow

Поделиться
HTML-код
  • Опубликовано: 14 май 2024
  • This video is a step-by-step tutorial on how to add and update your SharePoint list items from Excel Table data using Power Automate flows.
    We will create a template Excel file, where data to be imported to SharePoint will be loaded. The Template file will be made available for download from SharePoint Library (or OneDrive). Excel files with data rows will be uploaded to a SharePoint drop off library where Power Automate flow will be listening to start adding or updating the data from the Excel file (Table with rows) to SharePoint List.
    Flow will track the status of the Excel file, Log updates & perform error handling, add & update SharePoint list data for most column types - Text, Date, Date & Time, Choice, Lookup, Person, Multi select choice, multi select person columns & more.
    We will also look at getting lookup column ID from secondary SharePoint List.
    Flow will check if row in Excel has an existing item in SharePoint. If yes, then flow will update SharePoint item from Excel row data else flow will create a New Item in SharePoint List.
    This Power Apps Video covers the following:
    ✅ SharePoint List
    ✅ Excel Template from SharePoint List
    ✅ Add Excel data to SharePoint List using Power Automate
    ✅ Update Excel data to SharePoint List using Power Automate
    ✅ Add data validation & null checks in Excel & flow
    ✅ Date and time conversions
    ✅ Excel file import status logging & more.
    ✅ Performance & Limitations for large excel files with large number of rows, 256 row limits, pagination, 6 minutes delay for locked file status & more.
    🔗 Download ⬇️ Sample flows
    github.com/rdorrani/Microsoft...
    🔗 List rows present in a table (Excel Connector)
    docs.microsoft.com/en-us/conn...
    🔗 SharePoint connector
    docs.microsoft.com/en-us/conn...
    🔗 Power Automate flow Expressions Tutorial
    • Power Automate flow Ex...
    Table of Contents:
    0:00 - Introduction to Add & Update Excel Table data to SharePoint using flow
    0:47 - SharePoint List Scenario
    2:08 - Import Excel data to SharePoint
    2:41 - Create the Excel template file to Import to SharePoint
    7:19 - Excel Data Validations
    8:35 - Create Power Automate flow to add Excel Table rows to SharePoint List
    24:33 - Add Null Checks in Flow
    26:41 - SharePoint Date & Time Columns - Time Zone Conversions
    29:25- Limitations & Performance for large data in Excel
    32:27 - Update Excel File Status (file locked scenario when List Rows present in a Table action is called in flow)
    35:51 - Add logic in flow to update SharePoint List data from excel file.
    40:04 - Log results of Excel file import to SharePoint using Power Automate
    41:42 - Subscribe to Reza Dorrani channel
    #PowerAutomate #Excel #SharePoint #ExcelImport #SharePointList #Flow #MicrosoftFlow
    🤝 Let’s connect on social:
    🔗 LinkedIn: / rezadorrani
    🐦 Twitter: / rezadorrani

Комментарии • 915

  • @amigomusa
    @amigomusa 2 года назад +35

    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. 😀...

    • @RezaDorrani
      @RezaDorrani  2 года назад +1

      Wow, thank you but I would love to hear your feedback on the video whenever you get a chance to watch it :)

    • @amigomusa
      @amigomusa 2 года назад +2

      @@RezaDorrani I will surely watch it during my Power Hour, currently at work.

    • @TheMKTube
      @TheMKTube 2 года назад +1

      @@amigomusa “power hour” love it

  • @chrysarreola5902
    @chrysarreola5902 Год назад +13

    You and Shane young are basically carrying my career on your backs

    • @RezaDorrani
      @RezaDorrani  Год назад +1

      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)

  • @tomseymore9395
    @tomseymore9395 Год назад +6

    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.

  • @rupatron7
    @rupatron7 11 дней назад +1

    Reza, big Thank you for what you do and teach, I really appreciate it. You are a great and expert trainer.

  • @manishh7323
    @manishh7323 2 года назад +13

    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 !

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Glad to hear the video is helpful! Thanks so much for sharing your scenario.

  • @WillCooper1
    @WillCooper1 2 года назад +3

    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!

  • @UCanDoIt2Mike
    @UCanDoIt2Mike Год назад +6

    Extremely well organized lesson. Straight to the point and well articulated. Thank you for sharing.

  • @bobthewobbly6516
    @bobthewobbly6516 10 месяцев назад +2

    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.

  • @danyell12345
    @danyell12345 3 месяца назад

    Incredibly helpful! Awesome! I am new to power automate and this was such a thorough and detailed walkthrough. Thanks!

  • @akashkaushik3267
    @akashkaushik3267 11 месяцев назад +3

    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.

  • @SS-lu2bm
    @SS-lu2bm 2 года назад +1

    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!

  • @jourdan6947
    @jourdan6947 Год назад

    This worked perfectly and saved me hours of work manually migrating items to a SP list! You are much appreciated Reza!

  • @johanvandyk6532
    @johanvandyk6532 2 года назад +3

    Awesome, have been looking for a good example and this one is great!!

  • @CloudhoundCoUk
    @CloudhoundCoUk Год назад +3

    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.

  • @deborahshipp7597
    @deborahshipp7597 Год назад

    Best video Ive ever seen. You spoke clearly, you went just slow enough. I absolutely love you man!

    • @RezaDorrani
      @RezaDorrani  Год назад

      Glad to hear it! Thanks so much.

  • @dianarobledov1670
    @dianarobledov1670 Год назад +1

    as always, thank you very much for taking your time to record, explain, edit and share all this knowledge!

  • @akashnet
    @akashnet Год назад +5

    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.

    • @RezaDorrani
      @RezaDorrani  Год назад +1

      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.

    • @christopherthornton8152
      @christopherthornton8152 Год назад

      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!

    • @davidoddy4668
      @davidoddy4668 11 месяцев назад

      @@RezaDorrani the error handling would be very useful

  • @NaranRet
    @NaranRet Год назад +8

    Reza, simply the-B-e-s-t

  • @anshukumari8982
    @anshukumari8982 2 года назад +1

    From beginning till the end there are so many important items covered. Amazing video. Thanks Reza !!

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Glad to hear the feedback. Thanks Anshu.

  • @enitesh
    @enitesh 2 года назад +1

    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
      @RezaDorrani  2 года назад

      Great to hear! Thanks for watching.

  • @jhhatcher1885
    @jhhatcher1885 2 года назад +1

    You are a great teacher, I really enjoy your training videos. Thank You!!!

  • @hlinaminyilal7540
    @hlinaminyilal7540 2 года назад +1

    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.

  • @TheKalipolis
    @TheKalipolis 2 года назад +1

    Reza, my hero. Again, this is exactly what I was looking for to solve a problem at work. Thanks!!!!

  • @franknielsen3219
    @franknielsen3219 5 месяцев назад +1

    Lookup columns is hard work. Thx for the great walk-through 👏👏👏👏

  • @matheusbarbosa745
    @matheusbarbosa745 2 года назад +1

    Man, you are the best! Continue to do the work you are doing, because you are helping so many people! Congratulations.

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Thank You for your kind words. I will keep trying my best.

  • @becky5687
    @becky5687 2 года назад +1

    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!

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Awesome! Thanks for watching and liking the video.

  • @idaeinjaw2139
    @idaeinjaw2139 Год назад +1

    wow most detailed sharepoint flow tutorial ever. thanks!

  • @culebradiver
    @culebradiver 20 дней назад +1

    Saved my butt again Reza... quick, concise, spot-on help. You Rock!

  • @CheapCheerful
    @CheapCheerful Месяц назад +2

    Reza, you are the Power Automate / Power Apps KING!

    • @RezaDorrani
      @RezaDorrani  Месяц назад +1

      Thank You so much.
      Content is 👑

  • @RobertDJolliffII
    @RobertDJolliffII Год назад

    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!!!!

    • @RezaDorrani
      @RezaDorrani  Год назад

      Glad to hear that! Thanks so much for watching.

  • @krishnabairi1581
    @krishnabairi1581 2 года назад +1

    Good stuff Reza... Single video with lot of use cases and expressions... Thank you

  • @WillCooper1
    @WillCooper1 11 месяцев назад +1

    Excellent information Reza. You have helped me learn so much. Appreciate all your long hours of time and effort making your videos. 🙂

    • @RezaDorrani
      @RezaDorrani  11 месяцев назад

      Most welcome and thanks so much for watching

  • @sksachingupta1
    @sksachingupta1 2 года назад +1

    really .its very good example to check duplicate /existing items and update status.

  • @god_hacker581
    @god_hacker581 2 года назад +1

    Great video as always. Lots of learning. Thanks for your efforts and time, very nice step-by-step presentation.

  • @alancave4117
    @alancave4117 Год назад +1

    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.

    • @RezaDorrani
      @RezaDorrani  Год назад

      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.

  • @jekyllhyde05
    @jekyllhyde05 5 месяцев назад +1

    Thank you for this awesome tutorial, Reza! You are awesome as per usual! ❤

    • @RezaDorrani
      @RezaDorrani  5 месяцев назад

      You're most welcome and thank you for watching

  • @anthonyleduc
    @anthonyleduc 2 года назад

    Wow. You covered a lot of subjects. Thank you for helping me to improve my skills

  • @nilotpal81
    @nilotpal81 Год назад +1

    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.

  • @raitup00
    @raitup00 Год назад +1

    Many topics were covered! Amazing video!

  • @akshaynm
    @akshaynm 4 месяца назад +1

    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
      @RezaDorrani  4 месяца назад +1

      Thanks so much for the appreciation Akshay

  • @renatoshimabukuro8037
    @renatoshimabukuro8037 7 месяцев назад +1

    What a lesson! Thank you so much for the video!

  • @alejandrorodriguezgarcia4534
    @alejandrorodriguezgarcia4534 Год назад +1

    You made my day! thanks for this great video Reza, greetings from Argentina😀

    • @RezaDorrani
      @RezaDorrani  Год назад

      Happy to hear that! Have a great day!

  • @bylaker
    @bylaker 2 года назад +1

    very good example! I am looking for this since yesterday! thank you!

  • @jamief3592
    @jamief3592 3 месяца назад

    Your videos are brilliant. Very helpful

  • @Summane
    @Summane 2 месяца назад

    Hello Reza,
    Your videos have been so helpful to build Power Apps & Power Automate. Thanks So much

  • @danielmartins5327
    @danielmartins5327 Год назад +1

    Reza you're the best!!!!! thanks a lot for this video.

  • @shaikhfirdos2723
    @shaikhfirdos2723 Год назад +1

    Most useful... special for Lookup and all type column... Thanks Reza..

  • @MohammadAli-ts2ev
    @MohammadAli-ts2ev 2 года назад +1

    A great video once again.. thank u so much Reza for the efforts you would have put in...

  • @anpesworld
    @anpesworld Год назад +1

    Thank you Reza. Always great tutorial and easy to follow

  • @josephj6356
    @josephj6356 2 года назад +1

    Was exactly what I was looking for. Thanks!

  • @Lyriks_
    @Lyriks_ 2 года назад +1

    Best tutorial on excel automation i've seen

  • @TanishaBates-cr8oq
    @TanishaBates-cr8oq Месяц назад +1

    Hi Reza, this is awesome and helped me immensely! You rock!

  • @angelicakabigting3903
    @angelicakabigting3903 Год назад +2

    Amazing tutorials! Thanks a lot!

  • @nelsickDranar
    @nelsickDranar Год назад

    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!

  • @carlw
    @carlw 2 года назад +1

    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.

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Thanks for the awesome feedback. You are most welcome!

  • @babukurapati80
    @babukurapati80 2 года назад +1

    Thank you for your time and really helpful Reza!!

  •  2 года назад +1

    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 🙏👍

    • @RezaDorrani
      @RezaDorrani  2 года назад +2

      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.

  • @Sunilprakashsabbithi
    @Sunilprakashsabbithi 3 месяца назад

    Awsome work and as i said for your earlier videos, you are my best mentor for Power platform...😀😀😀

  • @smaheen
    @smaheen Год назад +1

    Great tutorial. The best thing this is a professional tutorial.. Everything explain well.

    • @RezaDorrani
      @RezaDorrani  Год назад

      Glad you think so! Thanks so much for watching.

    • @smaheen
      @smaheen Год назад

      @@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
      @RezaDorrani  Год назад

      @@smaheen Honestly I do not remember:)
      Check playlists on my channel.

  • @adamshrinah2595
    @adamshrinah2595 Год назад +1

    As usual, super informative video. THANKS

  • @GiveAndTrustLove
    @GiveAndTrustLove 28 дней назад +1

    Nice informative video very helpful

  • @gelezinkelisnbb8561
    @gelezinkelisnbb8561 Год назад +1

    Thank you. This helped me. Exactly what I was looking for.

  • @TheMKTube
    @TheMKTube 2 года назад +1

    And there I was thinking oh I know how to do that before watching the video lol, amazing content Reza!

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Thanks for watching. I did a lot of research before making this video :)
      I wanted to ensure I cover all bases.

  • @chunweitan9133
    @chunweitan9133 4 месяца назад +1

    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.

    • @RezaDorrani
      @RezaDorrani  4 месяца назад +1

      Most welcome!
      I dont have a step by step video on that.

  • @19hebo89
    @19hebo89 Год назад +1

    Great video, which solved all of my problems. Well, at least all of my Power Automate problems. 😀

  • @paulbruen3108
    @paulbruen3108 10 месяцев назад +1

    Brilliant video - really useful - thanks for posting.

    • @RezaDorrani
      @RezaDorrani  10 месяцев назад

      Thanks for watching and liking

  • @neelamsoni1846
    @neelamsoni1846 Год назад +2

    Hi Reza, Your videos are always great and helpful. Could you please create a separate video for error handling? That would be really helpful.

    • @RezaDorrani
      @RezaDorrani  Год назад

      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.

  • @rajeshappu7922
    @rajeshappu7922 Год назад +1

    Amazing video, Thanks for the wonderful explanation

  • @gustavomonne4921
    @gustavomonne4921 2 года назад +1

    Great video Reza, you game me a lot of tips and ideas.

  • @dhofstra
    @dhofstra Год назад +2

    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.

  • @jahannathvarshan6529
    @jahannathvarshan6529 Год назад +1

    Very well explained and worked like charm

  • @laminepilor5754
    @laminepilor5754 2 года назад +1

    Thank you for your knowlege sharing! It lavarage our skills a lots

  • @operationsstaraviation4636
    @operationsstaraviation4636 Год назад +1

    Reza ! You are the best !

  • @sosinamezemir2612
    @sosinamezemir2612 2 года назад +1

    Thank You , Ready for March Demo

    • @RezaDorrani
      @RezaDorrani  2 года назад

      Absolutely! Ready for it 🔥

  • @javierbarrera4935
    @javierbarrera4935 2 года назад +1

    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!

    • @RezaDorrani
      @RezaDorrani  2 года назад

      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).

  • @tamimelzein7493
    @tamimelzein7493 Год назад +2

    Hey Reza. Amazing video for imports. thanks for all the educative content. I'm trying to import items from an excel into a list, but I'd like to set the "created date" in the list to something specific, not the actual date I'm doing the import. There seem to be some solution, but I can't seem to have them work. Would you be able to help with a tutorial? Thanks a LOT!

    • @RezaDorrani
      @RezaDorrani  Год назад

      You're most welcome.
      I believe there are SharePoint rest api endpoints which allow to set system columns like created date.
      I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

  • @dongduongphuong1241
    @dongduongphuong1241 2 года назад +1

    Awesome as usual Reza! Lots of helpful information. I'm still new to Power Apps / Power Automate and kind of developing an upload Excel file function for users to add / update the data using your flow. However, I just wonder the pros and cons of using Dataverse instead of SharePoint list as in the video. Not sure if I can apply all of your steps for Dataverse or any potential downsides.

    • @RezaDorrani
      @RezaDorrani  2 года назад +1

      There is no potential downsides. In fact Dataverse has dataflows which allow you to import data from almost any service to Dataverse.

  • @rddslt
    @rddslt Год назад +1

    This is excellent. Thank you!

  • @MenPoriyaalan
    @MenPoriyaalan 11 месяцев назад +1

    this is absolute brilliant work.. thank you so much for sharing it

  • @SamTheMan0319
    @SamTheMan0319 Год назад +1

    God bless you bro. You've helped me so much!

  • @shivabkumar7999
    @shivabkumar7999 8 месяцев назад +1

    top class video, Reza. Awesome, keep it going.!

  • @ion669
    @ion669 Год назад +1

    Thank you again for another excellent presentation.

    • @RezaDorrani
      @RezaDorrani  Год назад +1

      Most welcome

    • @ion669
      @ion669 Год назад

      @@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?

    • @RezaDorrani
      @RezaDorrani  Год назад +1

      @@ion669 Add multiple tables in multiple sheets. And then replicate the logic in flow.

  • @mahalakshmidevarajan6656
    @mahalakshmidevarajan6656 2 года назад +1

    I am learning always from your video😀

  • @geba3uer
    @geba3uer 2 года назад +1

    Reza you are the best, thanks

  • @robh2489
    @robh2489 Год назад +1

    Excellent video, much apprecaited.

  • @johng5295
    @johng5295 Год назад +1

    Thanks in a million.Great content.

  • @MrClux4
    @MrClux4 2 года назад +2

    Great video! I can't wait to employ this for my scenario. Is this the way you would migrate data that was being tracked in an excel spreadsheet if you wanted to convert to MS List for permanent tracking? If so, how would you handle date fields in Excel that autofill based on dates in other columns? Thank you!!

    • @RezaDorrani
      @RezaDorrani  2 года назад +1

      As long as the date fields that autofill based on other columns have the correct date format you should be able to apply this technique.

  • @gunasekaran4288
    @gunasekaran4288 2 года назад +1

    This is what expected few months.. great Reza. You are masterpiece in this industry...

  • @TheMattmulherin
    @TheMattmulherin 2 года назад +1

    Excellent work Thanks!

  • @shannonlisby7483
    @shannonlisby7483 Год назад +1

    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?

    • @RezaDorrani
      @RezaDorrani  Год назад

      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.

  • @saifkazi8504
    @saifkazi8504 2 года назад +1

    Outstanding video
    I have never seen such a thing before..

  • @izzieZii
    @izzieZii Год назад +1

    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!

    • @RezaDorrani
      @RezaDorrani  Год назад +1

      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

    • @izzieZii
      @izzieZii Год назад +1

      @@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.

  • @stevemonk2742
    @stevemonk2742 Год назад +1

    Simply spectacular! Is going to save me a bunch of time and energy. You have included multi-select columns (excellent!!) and also a Lookup Column (excellent!) - but there is one column type that I am struggling with that does not seem to be included here on this video (perhaps good for another video?) - and that is the combination of these two things - namely a Multi-Select Lookup Column. I have tried combining elements from both the multi-select column and the lookup column - but I seem to be failing..... Any chance of including one of those column types in this (or another video)?

    • @RezaDorrani
      @RezaDorrani  Год назад

      Thanks Steve for the appreciation on the video.
      I have no plans for a follow up video specific to multi select lookup columns. 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.

  • @Mimi-po2rj
    @Mimi-po2rj 2 года назад +1

    Very helpful 👌 thank you.

  • @vrundadanatkar1467
    @vrundadanatkar1467 2 года назад +1

    Really helpful 👍
    Thank you .

  • @charisseaustria4711
    @charisseaustria4711 11 месяцев назад +1

    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!

    • @RezaDorrani
      @RezaDorrani  11 месяцев назад

      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.

  • @sandeepcrush
    @sandeepcrush Год назад +1

    Welcome to Reza University on Power Platform :), these are immensely helpful

  • @janhogerwerf3427
    @janhogerwerf3427 Год назад

    Great! Have exactly the same solution in place here and works well.

  • @maheshgupte1495
    @maheshgupte1495 2 месяца назад +1

    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

    • @RezaDorrani
      @RezaDorrani  2 месяца назад

      Welcome!
      I dont remember doing a video on that.

  • @satyasaichaitanya1265
    @satyasaichaitanya1265 11 месяцев назад +1

    Asusual Reza You rocked it 🤗🤗