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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Compare filtred lists ...
Power Automate
Unanswered

Compare filtred lists and send HTML table results

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I have a list of everyone who can work remotely. They fill out a Powerapps form that gets saved in another Sharepoint list. Flow sends Email to president at 5:30 every morning of everyone who have filled out the form with their status filtered for the day (WFH, On Premise or On Holiday). Works flawlessly.

 

Now, he asked me to send a list of everyone, even the ones that haven't filled out the form. This is where it gets complicated for me. I want to add the names of the one that have not filled out to my HTML table. Names are stored in a Sharepoint list and the Powerapps forms reponses are stored in another Sharepoint list.

But I am stuck here, I can compare the names from 2 selections from 2 Get Items as seen here : 

yanni991_0-1609788041603.png

1. IF Yes Output is the names I need but, 36 times each.

2. IF No Output is the names I already have from Powerapps form Sharepoint list.

* Excel Add row as nothing to do with that, it's just for checking output from Apply to each

 

This is where I am stuck, I want to add the names in an HTML table not included in the Powerapps Sharepoint List. 

 

 

 

 

Categories:
I have the same question (0)
  • PrasadAthalye Profile Picture
    on at

    You can use Append to string variable by creating 2 variables. First one will be used in Yes section to get the names who would like to work remotely and 2nd variable will store names who did not sign. 

     

    Finally you can use these 2 variables in 1 email action and send it.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 505

#2
Haque Profile Picture

Haque 446

#3
Valantis Profile Picture

Valantis 395

Last 30 days Overall leaderboard