Return json to powerapps from flow

(1) Share

Report

Posted on by xecho

102

Hi,

I am having trouble return a JSON from flow back to Powerapps.

My flow is sending the following data back to Powerapps:

However, when I use the following in Powerapps:

ClearCollect(myEmailList, GetPowerappUsers.Run());

I get only one record with Value of true, rather than a collection with the email addresses.

What am I missing?

Thanks,

Bart

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@xecho

You are missing a function that will parse json back into a table. Unfortunately, there is no such function!

In other words, you cannot do what you are looking to do that easily.

In order to convert the JSON back to a table of records, you will need to parse the JSON text yourself in the app.

I hope this is helpful for you.

Was this reply helpful? Yes No
xecho 102 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Randy,

Thanks for the answer. But the response to Powerapps is also not a string value when I try to get it with:
Set(myJSONString, GetPowerappUsers.Run());

Thanks,
Bart

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@xecho

Bart,

I notice that you have a "Response" step in your flow. This IS actually a way to return a table to PowerApps. However, you need to make sure you have a valid table returned in it.

AND...keep in mind that the Response action is a Premium action. ALL of your App users will need a Premium license to use your app.

I didn't notice that initially in your post as most people opt NOT to use that action because of the premium costs.

SO...with that in mind, if you are good with the premium licenses, then yes, what you are trying to do should work.

If you are not good with the premium licenses costs, then you will want to return your table as JSON and then parse it in your app.

Was this reply helpful? Yes No
xecho 102 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Randy,

I will change to parsing the JSON within Powerapps then :-).

Would have been nice to do it directly in the flow.

Thanks!
Bart

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@xecho

Well...you can, but at a cost!!

And the way licensing works, if you have a flow that you app calls which includes premium licenses, then your app requires it too.

From the looks of what you are returning from the flow in your initial picture, it should be pretty easy to parse that in the app.

Good luck on it and feel free to throw out questions if you run into problems.

Was this reply helpful? Yes No