Good day,
I am trying to build a flow (or rather 2) that will send some information from Sharepoint list A to Sharepoint list B and different information from Sharepoint list B to Sharepoint list A. The fields are different. I am having a problem with an infinite loop because I use when an item is created or modified as my trigger and this is what happens :
Flow A sends information to Sharepoint List B, but since some information are modified or added to Sharepoint list B, it triggers Flow B, causing a loop because Flow B sends information to Sharepoint List A. I also tried using a flag to set UpdatedByFlowA to "Yes" to my Sharepoint List A, but it switches to Yes, then No after the update item is ran, it causes the trigger when an item is created or modified, so the flow triggers itself, creating a circular loop.
Here is a screenshot :
The condition is :
length(body('Get_items_Sharepoint_list_B')?['value']) is greater than 0. When I create an item in Sharepoint list A and if it doesn't exist in Sharepoint list B, it will create that item.
I am a bit confused how or even if it is possible to fix my infinite loop problem either by Flow A and Flow B triggering each other on item modified, or Flow A or Flow B triggering themselves when the flag is changed from Yes to No.
Thank you for the kind help.
