Forum Discussion
Automatic Report from SharePoint List - Office 365
Hi, I am new to SharePointonline. I need to create a report (excel/ other format) which need to capture today's new data from a list and send to manager through email on daily basis. Could anyone hel...
Dr_A_Wells personally I think it's much easier to use a scheduled flow in Power Automate which would take less than 5 minutes to prepare and test.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliott I have only started to use power automate recently. Mainly for approval process flows. For me that powershell script took only a few minutes because i was just grabbing together parts of other scripts i have already written. I would be less familiar doing string manipulation, and formatting the excel file.
There is a good module for excel
Get-Module -Name ImportExcel -ListAvailable
Get-Module -Name ImportExcel
There are often many ways to do the same thing.
Alex