--- title: "Reports - Uboss Scheduled Reports and Microsoft Power Automate" slug: "uboss-scheduled-reports-and-microsoft-power-automate" updated: 2026-02-10T12:15:36Z published: 2026-02-10T12:15:36Z canonical: "docs.uboss.com/uboss-scheduled-reports-and-microsoft-power-automate" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.uboss.com/llms.txt > Use this file to discover all available pages before exploring further. # Reports - Uboss Scheduled Reports and Microsoft Power Automate This article will provide instructions on how to use Uboss scheduled reports and Microsoft Power Automate to get report data into Microsoft OneDrive. ## Uboss Setup Go to reports in the left menu. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(646).png) Go to scheduled reports in the list. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(647).png) From there add a new scheduled report instance and ensure you select SFTP as the export choice. Uboss will then present you with SFTP connection details for where to collect your scheduled report data. ## Microsoft Setup Please create a folder in your OneDrive where the files will be stored. Login to the Microsoft 365 control panel and find Power Automate. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(648).png) Go to the connections menu and create a new connection. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(654).png) Do a search for SFTP in the top right and select SFTP - SSH from the list. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(655).png) Using the SFTP connection details from Uboss fill in the relevant fields. You can see an example below. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(656).png) Once created I would then recommend editing the created instance and giving it a useful name. Make sure you enter the password and disable SSH key validation when clicking save. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(657).png) Go to my flows in the left menu. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(649).png) Create a new flow and select a scheduled cloud flow. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(650).png) Specify the frequency and then click create. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(651).png) You will be presented with a blank canvas and can start creating your automation flow. Click the plus icon to add a step. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(652).png) Do a search for SFTP and select the option list files in folder. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(653).png) Ensure the connection is set accordingly. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(658).png) Click the folder button and then select the SFTPWithSsh folder. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(659).png) You'll then see the folder is specified as / ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(660).png) Now add the next step. This time the action will be apply to each. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(661).png) Click the apply to each block and configure the necessary parameter. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(675).png) Go to the parameter option and type / and then select dynamic content. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(676).png) Then select the body from the previous step. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(677).png) Within your apply to each block add a new action. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(662).png) Do another search for sftp and then select get file content. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(663).png) Type a / and then select insert dynamic content. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(666).png) In the options which appear select path. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(667).png) Within your for each block now add another action. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(668).png) Do a search for create file and select the create file within the OneDrive for Business section. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(669).png) Browse to the folder in OneDrive where you would like the files to be created. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(670).png) For the file name add a / again and select dynamic content. Select the name attribute. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(671).png) For the file content select dynamic content again and then select the file content attribute. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(672).png) It should then look like below. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(673).png) Click save on the flow. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(674).png) You can now select to run the flow manually from the summary page. ![Image](https://cdn.document360.io/334a2c15-3e03-4702-a06b-0946461deedc/Images/Documentation/image(678).png)