Hi
I have built a SharePoint List which has Status choice field of New and Completed. When adding a new item, the row automatically adds New to the status field.
I wanted to be able to modify the list item without triggering a flow that I have built so I have added another column which is a text field which is then via a flow is updated to the same as the Status field.
I have built another flow which is triggered by the 2 status columns not matching using 'When an item or file is modified' trigger and then adding a trigger condition that states when the 2 columns don't match. this works perfectly until I add attachment to the item list and then the flow triggers. I don't want it to trigger until only when the Status column changes as I need to send email to a colleague with the Item Attachment.
Can anyone help at all how stop this from happening as Attachments will be added frequently.
Cheers
Hi, I want to make sure I understand your setup, so I have a couple of questions.
First, from reading your write up, you have two flows:
Flow #1 - triggers when a new item is created
Flow #2 - triggers when an existing item is modified and the Status != Status2
Is it that you don't want a certain portion of Flow #2 to trigger when an attachment is added? Could you use a condition statement and branching to handle the case where you need to send the attachment email but not take the additional action.
For instance,
1. When an item or file is modified (Trigger condition: status != status2)
2. Condition, if Has Attachment is equal to true, send email.
OR
2. Condition, if Status column changes, take needed action that you don't want to trigger when there is an attachment.
Is it possible to provide a picture of your flow or provide more details of your logic? Do you still need the attachment to be send if the status column changes to match the second column?