Forum Discussion
anonymous9376
May 10, 2022Brass Contributor
Generate a report in Sharepoint
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 employ...
anonymous9376
May 10, 2022Brass Contributor
Hi jcgonzalezmartin, what if HR doesn't have that licenses?
RobElliott
May 10, 2022Silver Contributor
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)
- anonymous9376May 10, 2022Brass ContributorRobElliott To build the flow and the result is an HTML table, right? Is it complicated to do that?
- RobElliottMay 10, 2022Silver Contributor
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- anonymous9376May 10, 2022Brass ContributorOkay, thank you for that link.