You’re offline. This is a read only version of the page.
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.
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.
Share
Report
All responses (
Answers (
552
