Forum Discussion
How to have users subscribe to an email distribution list/group on Sharepoint
Hi sbutter,
Have you considered a "sign up" list where members indicate what their interests are and then the Flow runs against the "sign up" list and checks against the "filter criteria"? The daily digest could also include a link back to the "sign up" list where they can manage their interests.
I hope this helps.
Norm
Hi Norman Young,
That sounds like something that could really help me.
However I am very new to MS Flow, what would be the best approach to set something like this up?
Thanks for thinking along!
Regards,
Sjoerd
Hi sbutter,
The "sign-up" list should include:
- User as a person column.
- Interests as a choice column that allows multiple selections; the choices should reflect the document library "filter criteria".
The Flow trigger will be "Recurrence" and will make use of the "Get items", "Create HTML table" and "Get files (properties only)" actions.
"Get items" retrieves the rows in the "sign-up" list.
"Get files (properties only)" retrieves the file information from the document library including "filter criteria". Note the filter query - "Filter" is my site column name.
"Create HTML list" will store results.
Here is an example Flow that will hopefully get you started.
My example is simple. A more elegant Flow should be created to handle the "filter criteria" that your document library and users may have.
I hope this helps.
Norm
