Unanswered

Combining two collection into one with both record data type

(0) Share

Report

Posted on by nagestiada

504

ClearCollect(
 colCombine2d,
 colDIDList,
 Filter(colDIDRecommend, !(colDIDRecommend.Product in colDIDList.Product))
)

Hey guys, I am getting an error with the Product as both product are record column type.

The error says:

Cant convert this data type. Power Apps can't convert this Table to a Record.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@nagestiada
Yes, because you are comparing records...you can't compare records in PowerApps.

Please consider changing your Formula to the following:

ClearCollect( colCombine2d, colDIDList, Filter(colDIDRecommend, !(Product in colDIDList.Product) ) )

I hope this is helpful for you.

Was this reply helpful? Yes No
nagestiada 504 on at

Like (0)

Report

Hello @RandyHayes,

I am now getting this error
Invalid argument Type. Expecting a Record value, but of a different schema.
Missing column. Your formula is missing a column 'Product' with a type of 'Record.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@nagestiada

What kind of column is Product?

Was this reply helpful? Yes No
nagestiada 504 on at

Like (0)

Report
@RandyHayes The Product is record column type on both collection.

If not possible, I tried a new solution where I grouped the Product, the code below does the job however, I want to add and show more fields that are not grouped by Like the Product Name which is the same column name on both collection but has different values so I will just show it
With( { outputTable: Ungroup( Table(/* Create the table with child tables. If you want to join more tables, add more items to this table and the formula will work the same way*/ {tableObject: colDIDRecommend}, {tableObject: colDIDList} ), "tableObject" )/* Merges all the tables into a single one, but no duplicates removed */ }, ShowColumns( GroupBy(AddColumns(outputTable, "Products",Product.Value),"Products","Grp"), "Products") )
The addcolumns is inside the groupby to solve the record issue

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@nagestiada

Yes, I would recommend this without a bunch of duplicated collections anyway - so, a better approach.

Is it working as you need now or is there still an issue?

Was this reply helpful? Yes No
nagestiada 504 on at

Like (0)

Report

@RandyHayes, It's working properly, however I want to get the ProductName that is outside the GroupBy.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@nagestiada

Okay, so then why are your grouping the table??

Was this reply helpful? Yes No
nagestiada 504 on at

Like (0)

Report

@RandyHayes

colDIDRecommend
ProductName Product
New Product GLA
New Product TPA

colDIDList
ProductName Product
Current Year Product GLA
Current Year Product IRA

Gallery (OUTPUT)
ProductName Product
Current Year Product GLA
Current Year Product IRA
New Product TPA

So it's like merging two collection into 1 gallery and the product and productname are both record (choice column from sharepoint list)

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@nagestiada

Okay, if there is no concern over the "winning" column value (meaning you are assuming that both tables would have the same product in them), then the following formula can be used:

ForAll( GroupBy( AddColumns( Ungroup(Table({{tableObject: colDIDRecommend}, {tableObject: colDIDList}), "tableObject"), "Products",Product.Value ), "Products","Grp" ) Ass _item, Patch(_item, First(Grp)) )

This will give you a Distinct list with all the columns from the record as well (the first one - again, the assumption is they are all the same).

Was this reply helpful? Yes No