
We have a need to send notifications for a set of people to read a certain document.
This notification should be sent on user action. so the user should select the document and start the flow.
The document is in a document library and the set of people are in a SharePoint list.
The reason for being in a SharePoint list has to do with the fact that there additional information like department, if user is active, and role within the company.
We are able to create the flow if we only had to use Sharepoint users for sending the notification. However we have the need for example to filter for specific department(s), specific role(s) or/and for active users.
We have found a workaround using SharePoint framework with Power Automate but it involves additional licensing and more complex development.
Do you know if there is a another way to do this?