Answered

How to Display JSON Results in Vertical Gallery

(1) Share

Report

Posted on by affanain

How to parse this output to show in 2 different columns in a power app gallery.

This output is generated by:
ClearCollect(
PredictionResults,
tasks_estimator.predicttask({
base_item_code: Concat(FilteredDataTable, ProductCode & ":"),
customer: customername,
offering_category: ProjectTypeDropdown.Selected.Value
})
);

I'm using these formulas in my labels of vertical gallery :

First(ThisItem.predicted_task_names).Value

But I want all the predictions. Whenever I change my formulas, it gives this type of errors:

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Sunil Kumar Pashikanti 2,338 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @affanain,

Why are you using First function, it always gives the first item from the collection.

First(ThisItem.predicted_task_names).Value - Use this only if you need to display the first item from the collection.

Can you try with below code?

ThisItem.predicted_task_names.Value

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Sunil Pashikanti - Tech Blog: PowerApps
affanain 20 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SunilPashikanti,
Thanks for the reply. I just showed the results of First(ThisItem.predicted_task_names).Value, that this is working fine. However, when I'm trying to use
ThisItem.predicted_task_names.Value
I get the error:
Verified answer

royg on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @affanain,
Based on the inputs you provided, you have an array of objects (in your example there's 1 item in that array), the items have 2 properties: predictedTaskHours and predecitedTaskNames which are both nested arrays.
It seems like you want to display a nested gallery inside the top gallery that displays 2 columns side by side with the data in the 2 nested arrays (taskNames/predictedHours).
If both arrays have the exact same number of items, you could do something like this to display the nested gallery with 2 columns, set the nested gallery Items property to:
ForAll(Sequence(CountRows(ThisItem.predicted_task_names)), { TaskName: Index(ThisItem.predicted_task_names, Value).Value, PredictedHours: Index(ThisItem.predicted_task_hours, Value).Value })
Let me know if that helps