web

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

News and Announcements icon

Power Platform CommunityForums Power Apps LookUp SharePoint list...

Power Apps

Answered

LookUp SharePoint list based on Collection value

(0) Share

Report

Report

Posted on by JimmyW

2,567

I'm trying to Filter a SharePoint list based on a Collection i have and at the end Patch all the Items that was filtered.

My collection contains the following information.

Id = Id of the item
Value = The TicketID

LookUp(SharePointList, TicketID = (How can i make it check the collection without delegation warning and without saying wrong type)

TicketID is a Single line of text column.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

JimmyW 2,567 on at

Like
a
(0)

Report
Copy link

Link copied!
ClearCollect( TestCol, Concatenate(RelatedTicketsCol6.Value, "")); ClearCollect(HelloTest, ForAll(TestCol, LookUp(SharePointList, TicketID = Result)));
Seems like the above works, using Concatenate i can then Filter or LookUp using the Result.
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JimmyWork ,

Could you tell me:
Do you want to find the intersection between a collection and a SP list? (For example: If the value of a record in the collection is “xxx” and the value of the TicketID column in the list is also “xxx”, you need this record.)

If my assumption is correct, I've made a test for your reference:

1\ This is my list.

2\ This is my collection “TestCol”.
ClearCollect(TestCol,{Id:"ss",Value:"111"},{Id:"ssd",Value:"333"},{Id:"gg",Value:"555"},{Id:"sse",Value:"777"})

3\ Add a button control and set its onselect property to:
ClearCollect(HelloTest,ForAll(TestCol,LookUp(LIST49,TicketID=Value)))

4\ Add a gallery control and set its Items property to:
HelloTest

5\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Join the conversation