Hello,
I have 2 SharePoint lists (Transaction Tracker and Job Requisition Create). Each item is in both lists and has a specific Form ID. When the status of a specific item is updated in the Job Requisition Create SharePoint List the flow will update the status for the same item (based on Form ID) in the Transaction Tracker SharePoint List. The flow is constantly running and therefore has slow performance. How can I adjust the flow so that it only runs when the item is actually created for modified instead of continuously?
I have the same type of flows for other lists and they work just fine. However, there is another flow associated with the Job Requisition Create SharePoint list with the same trigger (When an item is created or modified) that has a condition where when the status column of an item is marked "Completed" and the Modified by flow column is marked "No" it sends an automated email and updates the Modified by flow value to "Yes" (in order to prevent looping and the automated emails being sent out over and over again. Might this have something to do with it? I have screenshots of both of the flows below. Any help is appreciated!