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

Report
All responses (
Answers (