Power Automate - SharePoint Trigger When particular column is entered & stop further update triggers

Поділитися
Вставка
  • Опубліковано 27 січ 2025

КОМЕНТАРІ • 41

  • @sueamin2788
    @sueamin2788 Рік тому +1

    This is very useful. Many Thanks!

  • @fireflecked
    @fireflecked Рік тому +1

    Really, REALLY helpful. Thank you!

  • @praveeng3921
    @praveeng3921 2 роки тому +1

    Amazing, actually i m looking for this. Thank you

    • @abm4975
      @abm4975  2 роки тому

      Most welcome Praveen😊

  • @GarryWatson111
    @GarryWatson111 2 роки тому +1

    Good work, keep them coming.😀

  • @ayyappan2703
    @ayyappan2703 Рік тому +1

    Thanks a lot helped in the correct time

    • @abm4975
      @abm4975  Рік тому

      Thanks for the support.

  • @architpamecha6688
    @architpamecha6688 2 роки тому +1

    Hi
    Thank you for sharing this informative video. Really helpful.
    I wanted to check something else.
    For an employee onboarding workflow
    I get the input from MS forms. (Candidate details, hire date etc)
    And then the next set of actions are lined up basis the information received.
    How and where should I add a condition if a candidate backs out, the flow should stop there.
    I hope I was able to explain my query clearly

    • @abm4975
      @abm4975  2 роки тому

      Hi Archit
      You could add the IF condition to check whether user has submitted the relevant values or not. If you want to stop the flow immediately then use Terminate action step.
      Thanks

  • @rockingstar454
    @rockingstar454 Рік тому +1

    Thank you.
    My flow should trigger only once if change column value from abc100 to abc300, also I have other choise columns same conditions, flow should trigger only once that column choise value change from 1 to 2...can you please share a video or any link

    • @abm4975
      @abm4975  Рік тому

      I already explained this in my video by adding a trigger condition.

  • @ShafikaNadia
    @ShafikaNadia 2 роки тому +1

    IT works! thank you 👍

    • @abm4975
      @abm4975  2 роки тому

      Hi Shafika
      Glad it was useful. Thanks for your valuable comment.

  • @thewanderingcouple8378
    @thewanderingcouple8378 Рік тому +1

    I am facing error by using same syntex .. I have a choice column which is numbers in choice, default no is 1.
    I am updating the choice coloumn 1 to 2 and made other field update as well. And trigger should not happen if number field value is 2 . But still I am getting trigger

    • @abm4975
      @abm4975  Рік тому

      Hi
      I need to see your flow and offer you a screenshare help. Check my channel about contact section and connect me via teams.
      Thanks

    • @thewanderingcouple8378
      @thewanderingcouple8378 Рік тому +1

      @@abm4975 I did not find your email id in channel details..
      Could you please provide me your email id ..

    • @abm4975
      @abm4975  Рік тому

      Go to my Channel > Click About > Scroll down > Details > For business inquiries: View email address. Click here

    • @thewanderingcouple8378
      @thewanderingcouple8378 Рік тому +1

      @@abm4975 trust me there is no option is showing for business details

    • @abm4975
      @abm4975  Рік тому

      Hi
      Did you logged on to UA-cam. You need an account first.
      Thanks

  • @thewanderingcouple8378
    @thewanderingcouple8378 Рік тому +1

    Hi It is awesome.. Thanks for sharing this.
    I need to connect with you.
    Do we have any option to connect with you?
    Do you have any platform where you are teaching power automate? If yes I want to join your class

    • @abm4975
      @abm4975  Рік тому

      Hi
      Thanks for your support and query. Please have a look at my channel contact section and connect me via teams or email.
      Thanks

  • @g_clsk8617
    @g_clsk8617 2 роки тому +1

    Thanks for video! Question: if this sharepoint column was a choice field, how would you type code?
    @not(equals(triggerOutputs()?['body/ProjectNumber/Value'], null))
    or still same
    @not(equals(triggerOutputs()?['body/ProjectNumber'], null))

    • @abm4975
      @abm4975  2 роки тому

      Hi
      Hope you resolved your issue. If you still need help please let me know. Catching up after holidays.
      Thanks

  • @bossd7276
    @bossd7276 2 роки тому +1

    Thank you so much! It worked for me as well. Now I need the flow to just trigger other actions as values are added to other columns in the list. Can I add multiple stop start trigger conditions?

    • @abm4975
      @abm4975  2 роки тому

      Hi Boss
      Under the trigger conditions you can click the Add button and extend the conditions.

  • @sunilsexy86
    @sunilsexy86 2 роки тому +1

    how to trigger when multiple lines text column update

    • @abm4975
      @abm4975  2 роки тому

      Hi Sunil
      Use the same techniques and condition. Extend the condition with other fields and OR condition.
      Thanks

  • @palikaanusha3043
    @palikaanusha3043 2 роки тому +1

    Very helpful, thanks for the video, can you tell how to send an email to created by for overdue

    • @abm4975
      @abm4975  2 роки тому

      Hi
      Created by column schema name is called Author and it has other properties attached to it. If you want to extract the email then use
      @{items('Apply_to_each')?['Author']?['Email']}
      Above the expression I was using Get items and next action step add a compose and add the expression which I mentioned above.
      Thanks

  • @monishalakshmegowda4684
    @monishalakshmegowda4684 2 роки тому +2

    This flow is going into Infinite loop. How to avoid that

    • @abm4975
      @abm4975  2 роки тому

      Hi Monisha
      I have explained in my video about this.
      @not(equals(triggerOutputs()?['body/ProjectNumber'], null))
      @not(equals(triggerOutputs()?['body/ProjectNumberEntered'], true))
      So above as you can see there are two fields I am using for this. Once the value is entered then update true will stop for the next trigger.

  • @TheRealHouji
    @TheRealHouji 2 роки тому +1

    How to do trigger when the column project number is updated? Example. I change thr prj100 to prj1000. I want the flow to trigger

    • @abm4975
      @abm4975  2 роки тому +1

      There is an action step called 'Get changes for an item or a file (properties only)'. Add this action step after the item is created or modified. This way you can keep track on what was changed or not.

    • @yakem226
      @yakem226 2 роки тому +1

      @@abm4975 can you explain on this? where would we add this into the flow and what would we put in the field boxes?

    • @abm4975
      @abm4975  2 роки тому

      Hi Jacob
      You looking to trigger every time when the value is changed? Is this a list item or document library?
      Thanks

    • @yakem226
      @yakem226 2 роки тому +1

      @@abm4975 thank you, but I learned another way to do it without using flow just using conditional statements in the created column

    • @abm4975
      @abm4975  2 роки тому

      Hi Jacob
      Thanks for your reply. Its good to know that you found a solution. If you need further help let me know.
      Thanks