web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Not able to fetch data...

Power Apps

Answered

Not able to fetch data from collections tables because its taking column header's data type as Table not text.

(0) Share

Report

Report

Posted on by ashishraog

I used custom collector for fetching data fro rest api and the using ClearCollect command i stored data into collections.

Here data stored has two tables inside it (data,schema). Inside data there is table which has 15 columns and every column has data stored in it. So when I fetch first row of this data into a text box, I use( First(results).data.column_name) but it shows column_name has datatype as table and gives error. Can anyone please suggest the changes to fix this.

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ashishraog :

Could you tell me:

What is the formula for defining Result? I want to determine the data type of "data".

From your description, I think the data type of "data" should be "table" instead of "record".

Firstly,let me explain why you encounted this problem.

The key is that the data type does not match.The value of First(results).data.column_name is a table with one column.

Secondly,please try this code:

First(First(results).data).column_name

Best Regards,

Bof

Join the conversation