Answered

Powerapps ParseJson

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi guys,

I created a custom connector. Thanks to this connector, I am getting some data 3rd party application. It's okay I am getting but I couldn't show in the gallery. Here my collection.

When I clicked this collection, opening new page.

After I click again this page,

Finally my data is coming.
I used gallery to show them. But it didn't came. How to i solve this problem.
Gallery items is "nuc". I added label text to show status and I applied this formula : Text(First(Table(ParseJSON(ThisItem.data).yatakListesi)).Value.status). It giving an error which invalid argument type.

Also when I add a label text and after I applied formula like this : Text(Concat(ThisItem.data.yatakListesi.statu,statu,","))
I saw all of list item's statu.

I wanna use these formula : ThisItem.data.yatakListesi.statu but it giving an error " Expected text value".

Please help me.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous

Try this

First(ThisItem.data.yatakListesi).statu

(Or)

Text(First(ThisItem.data.yatakListesi).statu)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,
It's getting only 1 record. I wanna get all records in the table. I think I have to change my gallery items. What do you think about it ?

Was this reply helpful? Yes No
Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!
No need to change gallery item,

Text(ThisItem.data.yatakListesi.statu)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Gallery item is : nuc
Then I added a label text in gallery. I used your formula Text(First(ThisItem.data.yatakListesi).statu). It is only getting 1 record.
When I used this formula:Text(ThisItem.data.yatakListesi.statu)
it is giving an error.

I need your help 😞

Was this reply helpful? Yes No
Verified answer

Rajkumar_M 3,747 Moderator on at

Like (1)

Report
Copy link

Link copied!

Refer this blog's it helps you How to access nested collections/tables.

http://powerappsguide.com/blog/post/data---how-to-access-nested-collectionstables

https://powerusers.microsoft.com/t5/Building-Power-Apps/get-data-from-collection-array/td-p/316796

Thanks!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

It was good reference these links. I made it thank you 🙂

Was this reply helpful? Yes No