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. 😊
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!!
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?
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. ruclips.net/video/IvTiAanB3Cs/видео.html
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++
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?
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?
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?
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 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
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. 😊
Thanks for the compliment Shaik. Let's just say, I've made to many mistakes and now share with everyone what NOT to do. 🙂
Thanks so much Daniel, it was exactly what I needed..
Glad it helped!
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!!
Great to hear that and you are most welcome.
Great video, I think we need one step to keep tracking if record deleting from azure sql. Thanks for sharing.
That's a great idea!
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!
Glad it helped!
Great fantastic video. Top Top Top! Thank u
Many thanks!
Would needs Netflix with you, Dan
Thanks for another awesome one
WOW! That is an ultimate compliment. Thanks Mubarak!
Thank You So Much Daniel!! Very Helpful Content...
Glad it was helpful!
How do you convert Date Time Fields from SQL to SharePoint?
Thanks for some great videos
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?
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.
ruclips.net/video/IvTiAanB3Cs/видео.html
Great video Daniel!!
Glad you enjoyed it
Thank you Daniel! Can the same approach be used for Excel to Sharepoint?
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++
Wow, thanks!
You can always connect with me on LinkedIn.
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?
Thanks Bhavesh.
In this video the trigger is manual, however, you can change that to add, edit and delete.
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?
Your welcome Mohammed.
I would recommend using a Power Automate flow for this as well with a scheduled trigger.
Thanks Daniel excellent
Glad you liked it!
Great video Daniel!! I guess this process can be use for updating SAP HANA or any other DB?
Thanks for the compliment. That is correct.
@@DanielChristian19 excellent!!!! Thanks for sharing your knowledge!!!
@@DanielChristian19 I think this is awesome because it will help reduce extra licensing costs!!!
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?
Yes you can! You can use a Power Automate flow to do all that using a combination of SharePoint Get Items, Condition and Update.
@@DanielChristian19 Thank you- does any of your video have already covered this so that i can refer to it?
Hi Daniel. Will this work for a Power Automate free version (part of O365 E3 license), even though the SQL connectors are marked Premium?
Hi Awesome Short!
It will not. If you are using data sources such as SQL or Oracle then premium licenses will be needed.
Thanks 🙏🙏🙏
You’re welcome 😊
nice!
Thanks tezzuka
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
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.
@@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