In this article, you will learn how to transfer data from ApartmentIQ into your OneDrive using Microsoft Power Automate.
- Sign in to Power Automate: Open your web browser and navigate to the Power Automate website (https://make.powerautomate.com/). Sign in using your Microsoft account.
- Create a new flow: Click on the "My Flows" tab in the left navigation menu and then click on the "New Scheduled Cloud Flow" button to create a new flow.
Creating a new Scheduled Cloud Flow
- Set the schedule: Choose how often this flow should run by specifying the frequency and interval. For example, you can choose to run the flow every day at a specific time. Once selected, click “Create.”
Choosing when and how often the flow runs.
- Add an HTTP action: Click on the "+" button below the recurrence trigger and search for the "HTTP" action. Select the "HTTP" action to add it to your flow.
- Configure the HTTP action: In the HTTP action configuration, specify the method as "GET" and enter the ApartmentIQ data transfer URL.
- Add a OneDrive action: Click on the "+" button below the HTTP action and search for the "OneDrive" action. Select the "Create file" action to add it to your flow.
- Connect to OneDrive: If you haven't connected Power Automate to your OneDrive account before, you will be prompted to sign in and authorize the connection.
- Configure the OneDrive action: In the OneDrive action configuration, select the desired OneDrive folder where you want to upload the CSV file. Provide a name for the file and choose the appropriate file content from the dynamic content generated by the HTTP action.
Note: To include the current date in the File Name, click on the field, choose “Add Dynamic Content,” then “Expression,” and select the expression “utcNow().”
- File name: Be sure that characters at the very end of the file name end with “.csv”
- Save and test the flow: Click on the "Save" button to save the flow. You can then click on the "Test" button to run a test of the flow. Ensure that the CSV file is successfully retrieved and uploaded to the specified OneDrive folder.
- Enable the scheduled flow: Once you have tested the flow successfully, click on the "Enable" button to activate the scheduled flow. It will now run automatically based on the recurrence pattern you defined.
That's it! You have created a scheduled flow in Power Automate that retrieves the data transfer file from ApartmentIQ and uploads it to a OneDrive folder. The flow will run at the specified intervals and save the CSV file in the designated OneDrive folder.