Unanswered

How to filter and collect specific columns only from Sharepoint list to an existing Collection

(0) Share

Report

Posted on by raizanicolem

I need to filter a Sharepoint list by an ID and then collect those items with the same ID to an existing collection. I also want to only collect specific columns since not all of the columns in the list is part of the Collection's columns.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @raizanicolem ,

Please try:

Collect(CollectionName,ShowColumns(Filter(Bof2,ID in [1,2,3,4]),"Column1","Column2","Column3"))

Best Regards,
Bof

Was this reply helpful? Yes No
raizanicolem 70 on at

Like (0)

Report
Copy link

Link copied!
Hello @v-bofeng-msft ,
Thank you for answering.
I tried doing your solution,
Collect(existingCollName, ShowColumns(Filter('SP List','ID No.' = _itemSelected.'ID No.'), "Col1","Col2","Col3", "Col4", "Col5")));
But I got this error, "The collect cant contain values of this type."

This is what I did if I only have to get 1 item with the selected ID, but I don't really know how to collect the other items.

Collect( existingColName, { Col1: _itemSelected.Col1, Col2: _itemSelected.Col2, Col3: {Value: _itemSelected.Col3}, Col4: _itemSelected.Col4,, Col5: {Value: Int(_itemSelected.Col5)} } )

Was this reply helpful? Yes No