May 09 2022 11:37 PM
Hi, I'm developing a leave request system in the SharePoint site and Power Automate. From a SharePoint list, a report can be generated but how for HR to generate the monthly report for all the employees who use the SharePoint site to apply for leave on the SP list? What is the best way for it?
Thank you.
May 09 2022 11:50 PM
May 09 2022 11:53 PM
May 10 2022 12:00 AM
@anonymous9376 SharePoint is not good at reporting. You can export to Excel or build a flow in Power Automate with a recurrence schedule set to 1 month, get the relevant items using a filter query and create an HTML table which you could be emailed to HR. Easier just to export to Excel.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
May 10 2022 12:14 AM
May 10 2022 12:20 AM
@anonymous9376 no it's not difficult, but as I'm going offline now for at least 24 hours have a look at the video by RFeza Dorrani at https://www.youtube.com/watch?v=VnWg-Eox37Q
Rob
Los Gallardos
Microsoft Power Automate Community Super User