Convert collection to table rows

[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?

[StalinPonnusamy]

Hi @IncursioML1

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

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

Can you post how to collect the data?

[IncursioML1]

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},
            );

[StalinPonnusamy]

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

[IncursioML1]

Definitely returning a table instead of what you are showing.  

[IncursioML1]

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.

[IncursioML1]

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.

[StalinPonnusamy · Accepted solution]

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

[IncursioML1]

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

Thanks!