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

Поделиться
HTML-код
  • Опубликовано: 27 сен 2024

Комментарии • 43

  • @fireflecked
    @fireflecked Год назад +1

    Really, REALLY helpful. Thank you!

  • @sueamin2788
    @sueamin2788 Год назад +1

    This is very useful. Many Thanks!

  • @praveeng3921
    @praveeng3921 Год назад +1

    Amazing, actually i m looking for this. Thank you

    • @abm4975
      @abm4975  Год назад

      Most welcome Praveen😊

  • @GarryWatson111
    @GarryWatson111 2 года назад +1

    Good work, keep them coming.😀

    • @abm4975
      @abm4975  2 года назад

      Thanks Garry

  • @ayyappan2703
    @ayyappan2703 Год назад +1

    Thanks a lot helped in the correct time

    • @abm4975
      @abm4975  Год назад

      Thanks for the support.

  • @ShafikaNadia
    @ShafikaNadia 2 года назад +1

    IT works! thank you 👍

    • @abm4975
      @abm4975  2 года назад

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

  • @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.

  • @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 RUclips. You need an account first.
      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.

  • @himanshuppaghdal
    @himanshuppaghdal 3 месяца назад +1

    Is this condition can be use to trigger only specific column right?

    • @abm4975
      @abm4975  3 месяца назад

      Yes that's correct but you can extend this for multiple fields too.

  • @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

  • @sunilsexy86
    @sunilsexy86 Год назад +1

    how to trigger when multiple lines text column update

    • @abm4975
      @abm4975  Год назад

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

  • @palikaanusha3043
    @palikaanusha3043 Год назад +1

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

    • @abm4975
      @abm4975  Год назад

      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

  • @g_clsk8617
    @g_clsk8617 Год назад +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  Год назад

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