Author Details

avatar-teacher

Evolvous

We are a team of tech enthusiast and this section is where we love to share our experience and our knowledge. We try our best to help you understand technical topics by giving you live instances of how-to’s, guides, tips, FAQ’s and troubleshoots.

If you like it or have questions, do share your feedback in the comments section below.

Data Table from Power Automate Desktop to Power Automate Flow using JSON Object

“Robotic Process Automation”  

RPA is an advanced form of business process automation that can record tasks performed by a human on their computer, then perform those same tasks without human intervention. Essentially, it is a virtual robot copycat.”   RPA can be achieved by using Power Automate Desktop Flow which can record the task that is needed to be performed on the computer, or We can create a New Desktop flow and add actions that should perform on the computer or Webpage.   

Sometimes there are business needs where we want to extract the data from a web page using Power Automate Desktop flow, and the extracted data is to be sent to Power Automate flow for further Operations. In such a scenario, we can schedule a Power Automate Flow that will run once a day. This flow will call another Power Automate Desktop flow. The Power Automate Desktop flow will extract the data from the Webpage and store the data in the physical machine either in the form of excel or in the form of a Data Table.  

The challenge in this process is to send the data to the Power Automate Flow from Power Automate Desktop Flow. Since the Power Automate Desktop flow runs on the Physical machine, it will process the data and store the data on the physical machine.   

Microsoft Power Automate Desktop can convert a custom object’s property with a data table in it straight into JSON, and this JSON can be set as the Output property of the PAD Flow and can be utilized in the Power Automate Flow. To achieve this, we need to follow the following steps.  

In the first step

  • We need to create the Custom object. In the below example, I have named it “NewVar”. 

%NewVar% = % {{ }}%    

With years of experience, Ubedur has extensive knowledge of developing canvas applications and customized list forms with Microsoft Power Apps. Automating mundane business processes with Microsoft Power Automate is another field of his expertise. Building Power BI reports and using other 3rd party tools gives him an extra edge. He has demonstrated a history of working in SharePoint Online OOTB features - Evolvous

In the second step

  • We need to create a new property. The data table that extracted from the Webpage assigned to this property. In the below example, I have created the property using the name “ExtractedData” and assigned it the Data table “Extractedinform.”   

%NewVar[‘ExtractedData’]% = %Extractedinform%  

Power Automate Desktop to Power Automate Flow - Evolvous    

In the third step

  • We can create the output variable. We can convert the custom object to JSON with the action ‘Convert a custom object to JSON.’ In the below example, I have created the output variable by the name “JSONOutput”  

 

  

The action performed in the Microsoft Power Automate Desktop flow will look like this,  

 

The Automate Output named ” JSONoutput ” can use in Power Automate Flow, and then we can do further processing on it as per the requirement.   

Conclusion:   

Thus, we can easily migrate the data table from the Power Automate Desktop to Power Automate Flow using the JSON and following the above blog’s steps.

=====

Plus read

QuickBook in Power Automate using a custom connector