Hi,
I'm looping through a list to find rows with multiple conditions
If Stage = Blue AND Blue Start Date = today
OR
If Stage = Red AND Red Start Date = today
OR
If Stage = Orange AND Orange Start Date = today
I'm sending the results of this to an Append to Array variable:
{"Title": @{items('Apply_to_each')?['Title']},
"ID": @{items('Apply_to_each')?['ID']},
"Blue Start Date": @{items('Apply_to_each')?['BlueStart']},
"Red Start Date": @{items('Apply_to_each')?['RedStart']},
"Orange Start Date": @{items('Apply_to_each')?['OrangeStart']}
}
I'm then creating an HTML table and sending that via an email. That all works grand.
Title | ID | Blue Start Date | Red Start Start | Orange Start Date |
title 1 | 660 | 2017-08-01 | 2020-06-24 | |
title 2 | 697 | 2020-06-24 | 2020-11-30 | 2021-01-31 |
title 2 | 698 | | | 2020-06-24 |
The info that the user receiving the email is interested in is the fields where the date is = today (in this case, 2020-06-24. I'd like to either remove the dates that are not today's date, or highlight the fields where the date IS equal to today.
Is there any way to do this? I feel like I should be able to add an if statement somewhere to do this, but I'm not sure where or how.
Any hints appreciated!
Thanks!
