Тёмный

Power Automate: Infinite Trigger Loops 

John Day Q&A
Подписаться 4 тыс.
Просмотров 8 тыс.
50% 1

Ever had a Power Automate Flow trigger itself and run on and on and on? Annoying isn’t it?
Here I will show you a couple of methods you can try to break the loop, how to build trigger condition expressions with the intellisense tools, and how to manage some of your flows with a service account “without paying a monthly subscription.”
In this video
-------------------
01:53 Trigger Conditions
03:45 Create a Flow with a Service Account
07:35 Check how soon the trigger was from the last update
Expression to check Editor
------------------------------------------
@not(equals(triggerOutputs()?[‘body/Editor/Claims’],’i.0#.f|membership|user@domain.com’))
Change user@domain.com to the account you are using to manage the flow flow
Change Claims to Email and remove the i.0#.f|membership| if you want to use the email address.
Expression to Check Date/Time
---------------------------------------------------
@not(lessOrEquals(ticks(triggerBody()?['Modified']),ticks(addMinutes(triggerBody()?['Processed'],1))))
Change Processed to the name of your Date/Time Column
Change the addMinutes to addSeconds if you want a shorter time
Change the number at the end to the time gap you want to check. The bigger the number, the longer it has to be before a user updates it.
IMPORTANT: If you also included a delay following the "File locked for shared use" solution ( • Power Automate: Error ... ), the "1" at the end of the above trigger condition, needs to be larger than the delay time you set. At least 6 minutes is recommended, but I would start at around 10 and work down until it stops working.
NOTE: Take a look at SharePointPro's video for an alternative look at this problem: • Preventing Infinite Lo...

Опубликовано:

 

14 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 8   
@davidmorrigan7170
@davidmorrigan7170 3 года назад
Excellent. That has saved me some stress. It only seems to be with the Excel Online CDS that I experience this problem.
@JohnDayQA
@JohnDayQA 3 года назад
Yes, an Excel Table object is not greatest place to store data to be manipulated like this, and power users commonly advised against using it for measures like this, but for some older structures of data it's the only means until you have a new system in place.
@sharepointpro7900
@sharepointpro7900 2 года назад
Nice video. I created one on the same topic, but you're one is more detailed.
@JohnDayQA
@JohnDayQA 2 года назад
I'll be sure to add your channel name to the description. It's always good to give the viewers an alternative reference. They may follow yours better.
@fatihdagdelen9247
@fatihdagdelen9247 7 месяцев назад
Thanks a lot. It is wonderful!
@Firebus1122
@Firebus1122 3 года назад
The trigger condition does not work on document libraries that has content approval set to Yes/activated. The trigger works on the typical document library. Any suggestions?
@JohnDayQA
@JohnDayQA 3 года назад
So you will need to add a trigger condition that checks the Approval Status value before it executes. You can do this if your trigger is a SharePoint one that pulls in the file properties like the "when a file/item created or modified." For example if you want to run the flow only after the document was approved you would add the following condition. @equals(triggerOutputs()?['body/{ModerationStatus}'],'Approved')
@Firebus1122
@Firebus1122 3 года назад
@@JohnDayQA thanks, I got this to trigger when owner permissions were given to the service account thats running the workflow.
Далее
Run a flow when a SharePoint column is modified
9:58
Просмотров 130 тыс.
Break Infinite Trigger Loop in Power Automate
8:38
Просмотров 11 тыс.
Power Automate: How To Create Trigger Condition
12:01