Forum Discussion
Send daily email using a multi choice column in Sharepoint
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!