cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

How to separate one table into two in email

Hi all, i'm stuck and hope you'll help me

 

I need PowerApp to separate one table into two in email based on column "Quality Status" - please see example of source table below (table and PowerApp code will be attached in excel).

Oseme_0-1600267509834.png

I can send single table via mail using this logic:

Oseme_1-1600267547831.png

It works well and sends following message:

Oseme_2-1600267637953.png

 

What i'm trying to achieve is to filter output message based on field "Quality Status"

There are 3 possible scenarios:

1) Column "Quality Status" has both attributes - "Overdue" and "Check"(see example below) 

Oseme_3-1600267743064.png

Then output should look like this

Oseme_4-1600267790109.png

 

 

2) Column "Quality Status" has attribute "Overdue" only(see example below):

Oseme_5-1600267861062.png

Then output message should look like this:

Oseme_6-1600267883872.png

 

 

3) Column "Quality Status" has attribute "Check" only (see example below):

Oseme_7-1600267929010.png

Then output message should look like this:

Oseme_8-1600267959397.png

 

How should i modify PowerApp logic to achieve this?

 

Many thanks in advance!

 

Regards,

Oleh

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Users online (4,265)