Power Automate: Add and update data in bulk

Рет қаралды 48,089

Күн бұрын

Power Automate: Add and update data in bulk
Hey Everyone,
This video walks you through how to add and update items in bulk in a SharePoint list or rows in a SQL table using Power Automate flows. The example walks you through how you can create a new flow that can take rows from a SQL table and first add them as new items in a SharePoint list. Then you modify the flow to also update existing items and create new ones.
Table of contents:
Introduction (0:00)
Overview of the SQL table (0:41)
Create a SharePoint list (01:57)
Build the initial flow to create new items (5:10)
Run the flow (8:27)
Update the flow to create and modify items (10:55)
Modify the SQL table (21:17)
Run the flow (23:13)
Update the flow trigger (26:05)
Update the SQL table flow (27:56)
Conclusion (30:03)
#PowerAutomate #SharePoint #AzureSQL

Пікірлер: 44

@tMub365 3 жыл бұрын

Would needs Netflix with you, Dan Thanks for another awesome one

@DanielChristian19 3 жыл бұрын

WOW! That is an ultimate compliment. Thanks Mubarak!

@morghancastorena8712 2 жыл бұрын

Amazing video, Daniel. Not only did it help me in my current use-case, but it also answered questions and cleared up things I wasn't sure of generally in SP all at the same time. Thank you for the awesome content and keep it up!!

@DanielChristian19 2 жыл бұрын

Great to hear that and you are most welcome.

@shaiksamad1562 3 жыл бұрын

Daniel .. The way how you create list column and later modify list column name, this simple trick shows your expertise and grip on the subject. You are just awesome.. Daniel.. This bulk update is the common scenario which we commonly face and you made our life easy. 😊

@DanielChristian19 3 жыл бұрын

Thanks for the compliment Shaik. Let's just say, I've made to many mistakes and now share with everyone what NOT to do. 🙂

@madhurishirsat491 2 жыл бұрын

Thank You So Much Daniel!! Very Helpful Content...

@DanielChristian19 2 жыл бұрын

Glad it was helpful!

@RolandKritz 2 жыл бұрын

Thank you very much Daniel - the ODATA query to select only the row needed is exactly what i was missing and was causing me lots of trouble!

@DanielChristian19 2 жыл бұрын

Glad it helped!

@ajaychoudhary5596 3 жыл бұрын

Great video Daniel!!

@DanielChristian19 3 жыл бұрын

Glad you enjoyed it

@sundrapillay6668 3 жыл бұрын

Thanks Daniel excellent

@DanielChristian19 3 жыл бұрын

Glad you liked it!

@alzaimoor79 3 жыл бұрын

Great video, I think we need one step to keep tracking if record deleting from azure sql. Thanks for sharing.

@DanielChristian19 3 жыл бұрын

That's a great idea!

@paolovr1970 Жыл бұрын

Thanks 🙏🙏🙏

@DanielChristian19 Жыл бұрын

You’re welcome 😊

@robarcy Жыл бұрын

nice!

@DanielChristian19 Жыл бұрын

Thanks tezzuka

@johng5295 Жыл бұрын

Daniel, thanks in a million. You have earned my admiration and respect. HANDS DOWN. You have won The Noble Price in Microsoft as The MVP --just as The Most Valuable Prayer in NBA basketball. I have watched your stuffs just the past week, thanks in a million this content. It is second to none! Very well explained, and easy to follow--step by step. Awesome. HOW CAN I GET IN TOUCH WITH YOU? Grade: A++

@DanielChristian19 Жыл бұрын

Wow, thanks! You can always connect with me on LinkedIn.

@rosariofalero9858 2 жыл бұрын

Thank you Daniel! Can the same approach be used for Excel to Sharepoint?

@brianlaugesen 11 ай бұрын

How do you convert Date Time Fields from SQL to SharePoint? Thanks for some great videos

@julien8979 2 жыл бұрын

Thanks for sharing Daniel. Do you have any similar video to perform a bulk batch update for more than 100K records designed in a way that the flow does not take a lot of time?

@DanielChristian19 2 жыл бұрын

Hi Julien, I do not have a walk-through video. The one I posted in 2020 was about Power Apps performance with large data sets with 44K+ rows/items. I then tested functions & the results pleasantly surprised me. I'm confident this will clear some doubts & concerns you might have. kzfaq.info/get/bejne/f9yEnKSS06iXc6c.html

@awesomeshorts7937 Жыл бұрын

Hi Daniel. Will this work for a Power Automate free version (part of O365 E3 license), even though the SQL connectors are marked Premium?

@DanielChristian19 Жыл бұрын

Hi Awesome Short! It will not. If you are using data sources such as SQL or Oracle then premium licenses will be needed.

@01bhavesh 2 жыл бұрын

This is a great video with details explanation. One question that I have here. If we try to create/update/delete data in the SharePoint list will those changes be getting reflected in SQL DB too ? Or is there any other alternative to this?

@DanielChristian19 2 жыл бұрын

Thanks Bhavesh. In this video the trigger is manual, however, you can change that to add, edit and delete.

@FranciscoCamacho_fjcamachoj 3 жыл бұрын

Great video Daniel!! I guess this process can be use for updating SAP HANA or any other DB?

@DanielChristian19 3 жыл бұрын

Thanks for the compliment. That is correct.

@FranciscoCamacho_fjcamachoj 3 жыл бұрын

@@DanielChristian19 excellent!!!! Thanks for sharing your knowledge!!!

@FranciscoCamacho_fjcamachoj 3 жыл бұрын

@@DanielChristian19 I think this is awesome because it will help reduce extra licensing costs!!!

@ajithanair1952 2 жыл бұрын

thanks for sharing this insight - quick question - Is there a way we can add image to each items in sharepoint list based on their names or id's from image gallery or from personal folder?

@DanielChristian19 2 жыл бұрын

Yes you can! You can use a Power Automate flow to do all that using a combination of SharePoint Get Items, Condition and Update.

@ajithanair1952 2 жыл бұрын

@@DanielChristian19 Thank you- does any of your video have already covered this so that i can refer to it?

@HouseMusic1784 2 жыл бұрын

Hi Daniel, i tried this flow is working good with updating but when creating always the condition gives false and not adding the row? any idea what is my mistake

@DanielChristian19 2 жыл бұрын

This happens with your column is not providing the value you need for the condition to apply. Add the value to a compose action and see what you get.

@HouseMusic1784 2 жыл бұрын

@@DanielChristian19 thanks for your reply .. for the length expression when i select Body error the language function length expected its parameter to be an array or a string the provided value is of type object .. plz advise note the sqlid is number and sharepointid is number as well

@PowerPlatformDiv Жыл бұрын

Daniel thanks work for me Thanks, I wanted Only SQL to Sp list. one thing we want more, Data every 5 minutes SQL to Sp list which is the fast way to achieve it?

@DanielChristian19 Жыл бұрын

Your welcome Mohammed. I would recommend using a Power Automate flow for this as well with a scheduled trigger.