@SionHuws
Considering the flow will run on a daily basis, you can use the recurrence/time based trigger in the flow
- Click on +new step to add "GET ITEMS"(sharepoint) action, in this action card after selecting the site address and list name click on show advanced options and you will find an option (limit columns by view) to select the view. Select the desired view of your choice.
-> Click on +new step and select CREATE HTML TABLE action, in the from set it to value, and columns you can leave as automatic or if you want you can set them manually.
-> After this add SEND EMAIL action and enter the email address of the user to whom you want to send the email and select the output of CREATE HTML TABLE action.
If you want to configure for multiple users in the same flow, then after the trigger add a parallel branch and repeat the same steps.
the completed flow for one user will look as below
If the information shared helps you, please consider giving a thumbs up 👍 and mark solution as resolved.
