Call Power Automate actions only on when Specific SharePoint Column Value Changed

preview_player
Показать описание
During this video we will learn how we can call Power Automate Flow only when Specific column values are changed. Sometimes we have a requirement when we want to send an email notification only when specific column value is updated. During this video, I will show you a trick using you can achieve this. Here, in Power Automate we have action for SharePoint Get changes for Item or File. This action will provide boolean value for each column whose value is changed. Based on that we can write our own business solution.

Key Takeaways:
1. SharePoint - Get Changes for Item or File
2. Call Power Automate actions only on when Specific SharePoint Column Value Changed
3. Power Automate to trigger flow only when specific column values are changed

Chapters:
00:00 Start
00:27 Requirements
02:18 Get Changes for Item or File
03:37 Get List of which Column Values are changed in SharePoint List?
04:23 Check which column values are changed
05:37 Add Condition
08:56 Change Status for testing
09:43 Subscribe!

Follow Dhruvin on Social Media:
Follow my other channel for short content: @DigitalDhruvin

Follow me on Instagram:

Looking for Consultancy? Connect Here!

Follow me on all social Media Handles:

#powerautomate #sharepoint #PowerAutomateTricks #PowerPlatform #poweraddicts #DigitalDhruvin #DhruvinShah
Рекомендации по теме
Комментарии
Автор

OMG thank you, I have been messing with this flow for like 2 days and I couldnt figure it out!

tiffanyjimenez
Автор

Wow! I need something like this a few days ago. Thank you for making this video.

ibitoyeolarewaju
Автор

Great i really need this in my project. Thank you for this video

sonalijain
Автор

Thanks Dhruvin, this flow worked and solved the problem, I was facing.

apurbochakraborty
Автор

Amazing, thank you so much! :) It was really very helpful!

sujiths
Автор

Thank you Sir, Love you.
Subscription added.

abbasthegreat
Автор

Thank you so much! Super helpful! I've been struggling with that for quite some time now. Oh, and I noticed that you actually don't need the complicated formula in the condition. I just added a condition and put "Has column changed: my column name" is equal to true. And that's all.
Nevertheless - great video. Thank you!

MartinaEngert
Автор

Namaste! This was super helpful, thank you so much. ChatGPT had me doing JSON and nothing even close to as simple and logical as this. Thank you sir.

DoitNXS
Автор

Thank you very much you helped me alot :)

mariosudar
Автор

This is great thank you! But is there a way to prevent the flow from running everytime a field is changed in the list?

marie-andreefurlong
Автор

Great video. Can you also add here what if once I update the value to 'In Progress', how can I fetch its relevant values from another SharePoint List. Lets say, the other SP List has 2 or more columns of data against 'In Progress' and I would like to fetch it here in the Master SP List once it changes

shubhabratadey
Автор

Hi, this was very helpful. Is there a way to add an action for when a NEW item is added to the same sharepoint list and notify the owner of that item?

nicolecalhoun
Автор

Thanks.. It helped me. I saw someone sent money to you.. How do i do that?

NitinIndia-mxyr
Автор

Hi Dhruvin, Thanks for creating such a informative video. Actually I need your help in order to create a flow for one of my project wherein I have created a SharePoint site which contains multiple folders and added a column name with "Delivery Status". Now I need a flow which will send reminder email to users until the "delivery status" updated to "Delivered". Could you please help me with that?
Thanks

k.ishtiyaque
Автор

Thanks for the video. However, what if my column data are date values? I tried using this flow and it seems not working....

florantesandiego
Автор

Your videos are very good my friend. Can I contact you directly for projects and teaching?

CashCowz
Автор

Is it going to effect the creation operation?

manishkumarsingh
Автор

Make a video on Reports in Model Driven App

azharsyed
Автор

Hi driving, I also have similar kond of requirement but when I am trying my flow is not working, my scenario is when an Approval status changes to either approve or reject then I have another SharePoint list with mail ids, so al those members should be notified, can you suggest me the flow

shaliniakepati
Автор

Hello Dhruvin, nice and very informative video. How would you handle, let say, I have status value, new, pending, hold and Completed, flow should run on status value Completed, a user finished his/her task and mark status to Completed, but then realized task was not completed, so changed back to pending, so 1st email went out as Completed, but task is pending, now when task finally Completed, second email would go out, which means, there two emails went out for one task, how overcome this issue? Hope I did not confuse you, appreciate it.

RyanSmith-mhlj