Im experiencing some odd behaviour with power automate and i dont know if its something im doing or its just pants.
i have set up a flow to mark files with yes/no in a SharePoint library as job files by analysing their location in the full file path allowing me to then filter in a canvas app on that column and give me a list of jobs and not the directories before or the sub folders after - its working well. the expression is length(split(triggerOutputs()?['body/{FullPath}'], '/')) 'is equal to' 4
however inherently I'm creating an infinite trigger loop
When a file is created or modified (properties only) > condition is the file location at x position in file path > yes > mark yes > no >mark no
so because I'm then modifying the yes/no its ending up in an infinite loop
the obvious and common method is to add another helper yes/no column to check if the flow has been run on it and new condition after the trigger to detect it but when i do this it stops pulling in the custom fields i have created and makes the other condition have "no input" - im stumped
🙄
