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. 😊
@DanielChristian193 жыл бұрын
Thanks for the compliment Shaik. Let's just say, I've made to many mistakes and now share with everyone what NOT to do. 🙂
@tMub3653 жыл бұрын
Would needs Netflix with you, Dan Thanks for another awesome one
@DanielChristian193 жыл бұрын
WOW! That is an ultimate compliment. Thanks Mubarak!
@morghancastorena87122 жыл бұрын
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!!
@DanielChristian192 жыл бұрын
Great to hear that and you are most welcome.
@RolandKritz2 жыл бұрын
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!
@DanielChristian192 жыл бұрын
Glad it helped!
@alzaimoor793 жыл бұрын
Great video, I think we need one step to keep tracking if record deleting from azure sql. Thanks for sharing.
@DanielChristian193 жыл бұрын
That's a great idea!
@madhurishirsat4912 жыл бұрын
Thank You So Much Daniel!! Very Helpful Content...
@DanielChristian192 жыл бұрын
Glad it was helpful!
@sundrapillay66683 жыл бұрын
Thanks Daniel excellent
@DanielChristian193 жыл бұрын
Glad you liked it!
@ajaychoudhary55963 жыл бұрын
Great video Daniel!!
@DanielChristian193 жыл бұрын
Glad you enjoyed it
@johng52952 жыл бұрын
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++
@DanielChristian192 жыл бұрын
Wow, thanks! You can always connect with me on LinkedIn.
@paolovr1970 Жыл бұрын
Thanks 🙏🙏🙏
@DanielChristian19 Жыл бұрын
You’re welcome 😊
@brianlaugesen Жыл бұрын
How do you convert Date Time Fields from SQL to SharePoint? Thanks for some great videos
@julien89792 жыл бұрын
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?
@DanielChristian192 жыл бұрын
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. kzbin.info/www/bejne/f6e3mnSXo6dmedU
@robarcy Жыл бұрын
nice!
@DanielChristian19 Жыл бұрын
Thanks tezzuka
@01bhavesh2 жыл бұрын
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?
@DanielChristian192 жыл бұрын
Thanks Bhavesh. In this video the trigger is manual, however, you can change that to add, edit and delete.
@rosariofalero98583 жыл бұрын
Thank you Daniel! Can the same approach be used for Excel to Sharepoint?
@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.
@FranciscoCamacho_fjcamachoj3 жыл бұрын
Great video Daniel!! I guess this process can be use for updating SAP HANA or any other DB?
@DanielChristian193 жыл бұрын
Thanks for the compliment. That is correct.
@FranciscoCamacho_fjcamachoj3 жыл бұрын
@@DanielChristian19 excellent!!!! Thanks for sharing your knowledge!!!
@FranciscoCamacho_fjcamachoj3 жыл бұрын
@@DanielChristian19 I think this is awesome because it will help reduce extra licensing costs!!!
@ajithanair19522 жыл бұрын
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?
@DanielChristian192 жыл бұрын
Yes you can! You can use a Power Automate flow to do all that using a combination of SharePoint Get Items, Condition and Update.
@ajithanair19522 жыл бұрын
@@DanielChristian19 Thank you- does any of your video have already covered this so that i can refer to it?
@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.
@HouseMusic17842 жыл бұрын
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
@DanielChristian192 жыл бұрын
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.
@HouseMusic17842 жыл бұрын
@@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