
Announcements
I am making a Model driven App where I have a BPF and send email at different stages of a BPF,
I have a table named Approvals added to the main form in a new tab as a grid.
Before every next stage movement of the BPF a User makes an entry into the Grid table and then I send the email thru power automate having the necessary data of the grid TABLE when the BPF stage changes.
NOW the problem is , the flow is working if the Grid table has only 1 entry as the flow reads the data entered in the grid but if no data is added then the flow gives an error.
In the BPF I have 5 stages and before every stage a user makes a entry into the grid table whose values are subsequently read in the email sent,
If I make the flow with the future entries in mind then the flow sends an error as no data has been entered by that user as the BPF has still not reached that stage.
For separate BPF stages segregation I use Switch Condition and map it with the Stage Id .
Please tell how to incorporate the above scenario in the flow without it sending error( I don't want to make different flows to send emails at each stage )
Could you trigger the flow on the record being added to the table specifically using the Dataverse flow automated triggers? This way it will only execute the flow when the record is added and you shouldn't have the condition you are explaining above...