Share
Report
174Hi,
I have a powerapp which users fill out some hazard information and take a photo if necessary,
When the user fills out the app and marks the hazard as complete the infomation is added to the Hazards list and no follow on is required,
If the user marks the information as "incomplete" or "reassigned" in the status column of the app it creates a row in the Hazard List and in the Actions List, in this list is also a person column (Actionee) who the user assigns the incomplete Hazard too. The Actions lists has a status column that is marked as "New"
If the user uploads an image the image infomation is uploaded to a temporary Image List and the file stored in a document folder,
List1 the Hazard list contains all the information
List2 the Actions list also contains most of the information if the user marks the status column as "incomplete" or "reassigned"
List3 the Image list contains the images information
All lists have a unique ID in the row that can be used to match the data accross the lists.
I want to create a system in which if the user marks the status column as "incomplete" or "reassigned" in the app the Actionee gets an email informing them to take action on this hazard.
The three flows im having issues with currently work and do match the unique IDs accross the lists, adding the image list links and hazard list item link to the actions list however this causes one of my flows to be run several times and i get several emails.
Currently my three flows perform the following tasks
Flow1 Triggers from the image list (item is created or modified), ie checks for images, matches the ID and adds an image link to Hazard List and The Actions List
Flow2 Triggers from the Hazards list (item is created or modified), checks the Actions list matches the ID and adds the Hazard Items Link to the Actions List
Flow3 Triggers from the Actions list (item is created or modified) and splits into two conditions, 1) one checks the status of the actions list if the status column says "new" it sends an email to the Actionee with a link to the Hazards List, Link to the Image, Link to the Actions List. 2) if the status column in the actions list is changed to complete the Hazard list is updated to say complete.
All this works however i get multiple emails from Flow3 as if or when Flow 1 and Flow2 run they retrigger Flow3 and im stuck onto how to make this all into one Flow or at least make it only send one email.
Could someone help me?
All responses (
Answers (
