Answered

Convert collection to table rows

(0) Share

Report

Posted on by IncursioML1

I have 3 collections in which when I created in which I ended up combining into a single collection (Collection Combined).

How do I actually display this in a data table?

When you put this into a Data Table's Items, you end up with the [object Object]. How do you actually unmerge these into records to show in the table?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @IncursioML1

Each column looks table, so we can't bind to the data table. Either

Need to change the way it is collected
Transform combined collection to other collection which has Raw data

Can you post how to collect the data?

Was this reply helpful? Yes No
IncursioML1 97 on at

Like (0)

Report
The data is originally sourced from multiple SharePoint list, in which was used to create 3 collections.
The SharePoint list goes beyond the delegation, hence I put it into a collection in the beginning on app start to work around.
I then merged those 3 collections into 1, by doing the below on a text box 'OnChange' event to filter the data in the collects to something like the below.
ClearCollect( CollectionCombined, {OrderNumber: SumofPurchase.OrderNumber,AccountName: SumofPurchase.AccountName}, {OrderNumber: SumofUsage.OrderNumber,AccountName: SumofUsage.AccountName}, );

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Hi @IncursioML1

Based on the collection is supposed to be a single column but it's showing as a table for you.

Can you make sure "SumofPurchase.OrderNumber,AccountName" returns a single column instead of a table? you may use First() if needed

My Testing

Was this reply helpful? Yes No
IncursioML1 97 on at

Like (0)

Report

Definitely returning a table instead of what you are showing.

Was this reply helpful? Yes No
IncursioML1 97 on at

Like (0)

Report

I see your point on here where the expectation is to have records when you use the collection.

I think the problem I had is when I filtered on the collection, that was created from SharePoint, it has other fields in it that make it a table. i.e. like Author and User etc. that has a table of metadata.
Let me see if I can filter the table, but only bring back certain columns that are just records, into the collection and see if that solves it.

Was this reply helpful? Yes No
IncursioML1 97 on at

Like (0)

Report

No dice - I'm not sure how to do this other than maybe extracting only the columns in each collection in a forall statement, then appending those by doing something like collect(A,B,C) where all the collections line up with the same column names in same order.

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @IncursioML1

Each one shows as a table. If we are sure each one is only one row then we can use
First(SumofPurchase.OrderNumber).AccountName
to extract as a string or int.

Please click on the column(s) on the collection to verify the data inside. So that we can extract accordingly

Was this reply helpful? Yes No
IncursioML1 97 on at

Like (0)

Report

This was it, I had 1 record back so the First function worked out as you mentioned.
Thanks!

Was this reply helpful? Yes No