I'm trying to send a flow which reads a list, parses it against a document library and sends an email based on the criteria in that list.
Basically,
1. When a new item is created in the list the flow is triggered.
2. The list then matches the state (multiple yes/no columns, Aust so only 7 columns) against a single column in the document library and then attaches that information. There could be multiple states selected.
3. The email then only attaches the states which have been selected
4. the flow updates the sharepoint list with "in progress"
Not sure which way to do it - filter array or if expressions. Any help please!!