Forum Discussion
- HelloBenTeohBronze Contributor
Bd2023-b Can you provide some more information? Is there a reason why you want to create an app instead of running an automated flow?
- Bd2023-bBrass Contributor
HelloBenTeoh - Just checking different option . Want to build an app / workflow to create a monthly report from Sharepoint list and build a excel report each month and send it by email. The Sharepoint list get new data each day so just need to pull last month only each time it run monthly (schedule flow) and send it.
- HelloBenTeohBronze Contributor
Bd2023-b All good. It sounds like you're just looking for the solution and not necessarily the use of Power Apps vs Power Automate.
Power Automate will get you started. These links will help with creating an Excel doc, how to import from Lists and also how to filter your query by date. Good luck!
- Create a new Excel File in Power Automate and dynamically populate with a Table and Rows #Excel - YouTube
- Create & Populate Excel File Fast - Office Scripts without an Apply to Each #PowerAutomate #Excel - YouTube
- Solved: Filter Query on GetItems based on a date value - Power Platform Community (microsoft.com)