Configuring Microsoft Power Automate Connector

Access the Planful Connector:

Prerequisites

You must have a Microsoft Power Automate account to access the Planful connector, along with access to the DLR used to load the data through Power Automate. 

Planful connector is now available in Microsoft Power Automate through which you can load the data into Planful.

• Log in to your Microsoft Power Automate account.
• Click Connectors in the side menu and search for Planful in the search bar.
• Click the Planful connector and refer to the See Documentation link to know the dependencies and requirements to use the connector, like How to Authenticate, Supported regions, or any limitations.

How to Create a New Planful Connection from your Power Automate Account?

To create a new connection from your Power Automate account, follow the steps below:

1. Click Connections > + New Connection. If you do not find the Connections option, click More in the left pane menu and search for Connections. You can pin the same to the left pane menu.
2. Search for the Planful connector in the search bar.
   
3. Click on the Microsoft-certified Planful connector and provide the Access ID, Access Key, and the URL of your Planful application.
   Note:

   You can generate the Access ID and Key from Planful. To learn more, click here.

   

4. Click Create to establish a connection between Power Automate and Planful.

You have to create a Flow to load the desired data through Power Automate into Planful. Refer to the Flow Documentation in Power Automate to create a Flow. 

Once you create a Flow, Turn On the Flow, and Power Automate will load the data into Planful automatically whenever the flow trigger criteria are met. 

Use Case

Here is a scenario where the data is loaded into Planful through a Power Automate connector. After creating a successful connection with Planful, the Flow created in this use case has a OneDrive link that contains the data in a CSV file that we have to load into Planful.

1. Create a new flow (for example, XYZ) from My Flows in Power Automate. While creating the new flow, authenticate the OneDrive account that you want to use as a source to upload the data and the Planful Connector.
   Following are some important settings that were used to create the Flow:
   1. The Flow triggers automatically when you add a new file in the OneDrive source folder mentioned in the Flow.
      
   2. Specify the following in the File Load section in their respective fields:
      1. Column Delimiter - Column delimiter value
      2. Data Load Rule Name - Name of the DLR in Planful used to load the data.
      3. The File - Select the File content option from the suggestions.
      4. The File (file name) - Select the File name option from the suggestions.
         
2. Open the OneDrive account that was authenticated in the XYZ flow, and upload the CSV file that contains the data to the folder mentioned in the flow created in Power Automate.
3. Click My Flows and open the XYZ flow. As you have just uploaded the CSV file, Power Automate triggers the flow automatically, and you should see the data upload status in the flow.
   Note:

   Ensure the Flow is Turned On in Power Automate before uploading the CSV file in OneDrive.

4. Once the upload is complete, you will receive the upload status in your email ID as specified in the XYZ Flow.
5. You can verify the same in Planful > Notifications section and view the details of the data load from there.