web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Help Skipping fields t...
Power Apps
Unanswered

Help Skipping fields that are empty in a form to send Email using power automate for a Subgrid Table

(0) ShareShare
ReportReport
Posted on by 56

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 )

I have the same question (0)
  • Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @Mayank_Yadav 

    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...

    Screenshot 2023-11-23 at 6.36.21 AM.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 802 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 332 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 273

Last 30 days Overall leaderboard