Dear Community,
I did a desktop flow to web scrap a post office website from their store locator section, built with Google Map and embedded in their website.
In the action "Extract data from web page", I have selected store data as "Variable".
Then I passed it onto the Output Variable.
Back in the Cloud flow, I called the Desktop flow and response came back in the BranchLocations variable.
The data are csv like with three columns, no headers. For example
Post Office Name 1, Address, Distance
Post Office Name 2, Address, Distance
Post Office Name 3, Address, Distance
Post Office Name 4, Address, Distance
.
.
.
My trouble is, now I don't know what to do with it.
My goal is to extract three more variables for Name, Address and Distance so I could pass them back to PVA.
I tried to parse it but it's not in JSON format so it didn't work.
The Output variables may contain many rows of the returned locations.
I only need to pick the top three rows (sorted based on the distance) and ignore the rest.
I am thinking maybe I need to format them as JSON like so I could these parameters separately when I return them back to PVA as adaptive card.
"PostOffice1": {
"Name": "",
"Address": "",
"Distance": ""
},
"PostOffice2": {
"Name": "",
"Address": "",
"Distance": ""
},
Any suggestions on how I can manipulate the output variables in the cloud flow?
Thanks.
