Unanswered

Error.(JSON parsing error, expected 'string' but got 'object') - AzureVM.VirtualMachineGet

(0) Share

Report

Posted on by adrianallan

I use the provided connector in power automate and in power app but I get the same issue, I cannot address the returned data in a dot notation.

the data comes back in a JSON looking string, I've done things like Set(variable, JSON(returnoutput)), I've tried ParseJSON as well, I just can't seem to get it where I can type in variable.name / id etc etc.

I know this is simple problem but I can't seem to get it figured. sorry I can't cut and paste the information here i.e. result of connector (cut/copy/paste is disabled in my environment)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Manish Solanki 15,169 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @adrianallan

Pls check the below sample.

The power automate flow return the json object as string:

In app, on button click, I have used ParseJSON function to convert output parameter of flow in JSON object and store in a variable. After that you could easily access the property value by using dot notation.

Set(output,ParseJSON(testjsonoutput.Run().output));
Notify(output.Name)

It shows the value of property 'Name' when button is clicked:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
adrianallan 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, I did, what I thought was the same thing in two steps
Set(vmInfo, GetVMInfo.Run());
Set(jsonInfo, ParseJSON(vmInfo.output))
But I was not getting the dot notation response just the string. Thanks, I don't know why what I was doing didn't work but I'll say its my newbie problem.

Was this reply helpful? Yes No
FeierCiprian 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Set your response from Power Automate as STRING (using expressions)
then in Power Apps you will receive the string of data and you can transform it and store data into collection with the help of this video.
Send Array/JSON Response from Power Automate Flow to Power Apps

Hope it helps.

Was this reply helpful? Yes No
Manish Solanki 15,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @adrianallan

Try this way. Collect the string return by flow in a variable and then apply function:

Set(vmInfo, GetVMInfo.Run().output);
Set(jsonInfo, ParseJSON(vmInfo))

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No