I am wondering if someone can help me with the power automate flow. I have a flow "When an item is modified/created" --> get Item --> condition 1 when the BU response is approved, email send. Condition 2(Parallel) when the BU response is appeal. Email send. There is an issue, whenever the sharepoint item is modified, email will send again. What step I should be adding to avoid multiple emails send. only focus on sharepoint fields BU response.
I tried chatgpt and suggested to use Get changes for an item, however the condition is skipped.
Suggest you create a new column in your SharePoint list and use this new column to determine what to do. For example, you could name this column as FlowStatus and then update its value to for example: BU Approved, email sent etc... for when the email sent. Then you would check this status before sending an email etc...