Power Automate SharePoint list items to update all at once!

[@Dougie_Wood]

HELP ME‼️🌳 Grow the channel by sharing the LOVE from as little as £0.99p! 💖 Click here: kzbin.info/door/bl8QtLtzfnv6jPoc8gPqFQjoin

[@jessefavela3694]

Good job. Awesome stuff. I'm making a Timecard Punch system in PowerApps and have a "Last Clocked Action" Field that needs to be reset every night. Now, users will always start the day in a "clocked out" state. Thank you for your service and keep up the great vids!

[@Dougie_Wood]

Hey, I am just launching my channel membership, including priority responses to messages, exclusive training courses and a chance for a live chat in a Q&A drop in! 💖 I would really appreciate those that want to contribute to the content creation process with ideas sign up. I thought you would be interested. You can sign up here: kzbin.info/door/bl8QtLtzfnv6jPoc8gPqFQjoin

[@Dougie_Wood]

You would benefit from my channel membership, including, exclusive training courses and a chance for a live chat in a Q&A drop in! 💖 More details: kzbin.info/door/bl8QtLtzfnv6jPoc8gPqFQjoin

[@stephenapenkwah]

Thank you for this. As usual you made it look simple. Please upload more of Power Automate stuff that can help in flow of information on SharePoint.

[@Dougie_Wood]

Sure no problem, what kind of things are you interested in?

[@Dougie_Wood]

Hey, I am just launching my channel membership, including priority responses to messages, exclusive training courses and a chance for a live chat in a Q&A drop in! 💖 I would really appreciate those that want to contribute to the content creation process with ideas sign up. I thought you would be interested. You can sign up here: kzbin.info/door/bl8QtLtzfnv6jPoc8gPqFQjoin

[@Dougie_Wood]

You would benefit from my channel membership, including, exclusive training courses and a chance for a live chat in a Q&A drop in! 💖 More details: kzbin.info/door/bl8QtLtzfnv6jPoc8gPqFQjoin

[@FlorianRemy]

Thank you for the video, I learnt a lot! What I was trying to achieve when I clicked on your video was to update the values of one field of my Sharepoint List A, from the info in a second Sharepoint List B. The reason why I, and other people who commented below, want to do this is that it is easy to create a new Sharepoint List from an Excel file. I start to think that the way to do this is to put a second Get Items with conditions in the Filter Query inside of the Apply to Each loop.

[@Dougie_Wood]

If you just want to get details from another list then use a lookup column when creating your list 👍

[@FlorianRemy]

@@Dougie_Wood Thank you for your answer. Indeed I can use a lookup column, but the column which is used as the "ID" for the lookup needs to be populated for the lookup to work. This can be done manually for small lists, but when you have hundreds or thousands of values, it takes too much time. I would need at least to be able to copy the content of my "Title" column into this Lookup column, assuming that I use the "Title" for the lookup.

[@DarylGriffiths]

Interesting video, thx. Also, it's useful sometimes to see your workings and debugs in real time as in this vid. Not necessary every time, but for a quick worked example like this, taken from a real life scenario, all very useful... Adds to the sum of knowledge!

[@Dougie_Wood]

Thank you for your feedback. I have taken that on aboard and I will include that in some videos as I think it also shows the reality of the situation is even the experts do not get things right first time 😂

[@Dougie_Wood]

Hey, I am just launching my channel membership, including priority responses to messages, exclusive training courses and a chance for a live chat in a Q&A drop in! 💖 I would really appreciate those that want to contribute to the content creation process with ideas sign up. I thought you would be interested. You can sign up here: kzbin.info/door/bl8QtLtzfnv6jPoc8gPqFQjoin

[@Ankkush_Gupta]

thank you so much, you have solved a big problem for me.

[@Dougie_Wood]

Please support me and my channel, content I create and support I provide by sharing the love with as little as £0.99p! 💖 More details: kzbin.info/door/bl8QtLtzfnv6jPoc8gPqFQjoin

[@shubhabratadey]

Thanks for this video. Can you also show us how can we do a LOOKUP based on a column fetching values from another List? I am not talking about normal lookup feature we have in SP but based on the static values we have. Example: In your case looking up values based on Test1, Test 2 etc.

[@Dougie_Wood]

Can you give explain your example?

[@shubhabratadey]

@@Dougie_Wood I have 2 lists. In the 1st list lets say I have columns A, B and C. In the 2nd list I have C, D, E & F. The 1st list gets information from a MS Form and the 2nd list is a static list. My requirement is when the 1st list gets populated automatically using Power Automate, its relevant value from 2nd list should get fetched based on col C which is common both the lists. I tried with the Lookup function in a column but the issue is I have to manually select the col C in the 1st list and then only the relevant info gets fetched but my need is as soon as C column gets automatically filled, it should fetch its relevant values from the 2nd list.

[@Frederiktoday]

1. This is not updating all at once, it is updating items one by one in a loop (and is very slow in huge SharePoint lists) 2. Also, instead of using a condition inside the loop, use the ODATA filter in the Get Items, you will returns less data and only the data that needs to be updated. This way you loop is smaller and your flow less deep,

[@Dougie_Wood]

This video is aimed at complete beginners looking for the easiest solution 👍

[@tshepoernest9988]

Is it possible to create an automatic flow that refreshes a specific column in a Sharepoint list?

[@Dougie_Wood]

What do you mean refresh? As in update data of all items in the list but just a column?

[@rostykam1876]

How can we update the records in list A from list b as vlookup in excel?

[@Dougie_Wood]

Hey, sounds more like an excel question, not my area of specialty.

[@Dougie_Wood]

Are you trying to achieve something similar with power automate?

[@Dougie_Wood]

Please support me in creating more content you will love from as little as £0.99p! Please share the LOVE! 💖 More details: kzbin.info/door/bl8QtLtzfnv6jPoc8gPqFQjoin

[@rostykam1876]

@@Dougie_Wood Hey, I have list A and List B. In list A i have multiple records of the same employee and i want to update an unique key from list B against the employee available in list A without lookup column or choose function. Example:- List A Employee Name. Unique key Rosty. ABC123 Rosty. ABC123 Rosty. ABC123 Rosty. ABC123 List B Employee Unique key Rosty. ABC1234 I want the records like the above example. I hope you understand my concern.

[@rostykam1876]

Avoid unnecessary loop

[@Ynnj_]

I'm having a hard time in automating my files because it keeps connecting. How to fix it?

[@Dougie_Wood]

I’ve not seen that issue

[@ahoumauricettelaurearmellekoua]

Bonjour Mr, j'ai un message d'erreur au niveau de mon branchement. Je veux récupé rer la réponse d'une approbation dans ma liste sharepoint en cliquant sur mon bouton power apps

[@Dougie_Wood]

je ne parle pas français désolé 👎

[@ahoumauricettelaurearmellekoua]

@@Dougie_Wood ok. Thanks a lot

[@Dougie_Wood]

You would benefit from my channel membership, including, exclusive training courses and a chance for a live chat in a Q&A drop in! 💖 More details: kzbin.info/door/bl8QtLtzfnv6jPoc8gPqFQjoin

[@achrafhebi2632]

Some youtubers when they talk tss aaah tsss aaaah so better mute the video

[@Dougie_Wood]

Sounds like the start of this 😂kzbin.info/www/bejne/b3qpY56oaLJ3oqMsi=LadxHFzbH5k65sGm