Dec 05 2022 08:29 AM
Hi,
I am trying to create a flow that would send a daily email with the following conditions:
1. A column named "follow-up", with a multi-choice that consists of people name and different comittees that I would have a follow-up to do regarding the item.
2. For every item that "follow-up" is not empty, the email would list by "follow-up" choice, which item I would have to follow-up.
3. The "follow-up" choices are not static; from time to time I need to add a new choice so in the flow it can't be filtered with pre-determined choices.
4. Some items have a "due date", which would be included in the email
Example:
Email: "Daily follow-up elements"
Follow-up choice 1
Item 1
Item 2 due 2022-12-05
Item 5 due 2023-01-08
Follow-up choice 2
Item 2 due 2022-12-05
Item 4
Follow-up choice 3
Item 1
Etc...
I read a lot on the subject but wasn't able to find something that would solve what I need to do.
Thank you!
Dec 07 2022 06:29 AM
Hi @Hellmat , I think the best solution would be to embed an adaptive card into an email and then process the selections using a 'When a HTTP request is received' action. I built a solution after watching this helpful video: https://www.youtube.com/watch?v=ZiQ6tHGwNVg