Filter Collection based on specific ID from a SharePoint List

(0) Share

Report

Posted on by ctedesco3307

711

Trying to create a collections based on a specific field value

Galdcp selects a specific record from a SharePoint list

I want to create a collection from a "child" SharePoint list that has Galdcp ID as one of its field values. looks like I'm referencing the ID correctly but the Goal filed is bulling in all the rows, not just the one for the selected ID. What am I missing?

ClearCollect(colfaitems,KYOJDCPFocusAreas;{DCP:galdcp.Selected.ID,Goal:KYOJDCPFocusAreas.Goal});

All I should be getting are the bottom 3

Thx

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

JohnM86 590 on at

Like (0)

Report
Copy link

Link copied!

It looks like you are using the semicolon (;) to separate the two arguments of the ClearCollect function, which is causing the second argument ({DCP:galdcp.Selected.ID,Goal:KYOJDCPFocusAreas.Goal}) to be interpreted as a separate statement instead of an additional record to include in the collection.
To fix this, you can use the comma (,) instead to separate the two arguments, and then use the Filter function to retrieve only the items from the child SharePoint list that have the selected Galdcp ID:

ClearCollect( colfaitems, Filter( KYOJDCPFocusAreas, DCP = galdcp.Selected.ID ) );

This should create a collection called "colfaitems" that includes all items from the "KYOJDCPFocusAreas" SharePoint list where the "DCP" field matches the ID of the selected item in the "galdcp" gallery. The "Goal" field of each item should be included in the collection as well.

Was this reply helpful? Yes No
ctedesco3307 711 on at

Like (0)

Report
Copy link

Link copied!

@JohnM86 Thanks - closer - but now I get an error at the = sign - Incompatible types for comparison These values can't be compared Record number

DCP in KYOJDCPFocusAreas is a lookup field. I'll mess around with it a bit. thx
ClearCollect(colfaitems,Filter(KYOJDCPFocusAreas, DCP = galdcp.Selected.ID));

Was this reply helpful? Yes No
JohnM86 590 on at

Like (0)

Report
Copy link

Link copied!

To fix this issue, you could try using the Value function to get the underlying value of the lookup field. Here's an example of how you could modify your formula to do this:

ClearCollect(colfaitems, Filter(KYOJDCPFocusAreas, Value(DCP) = Value(galdcp.Selected.ID)))

The Value function returns the underlying value of the lookup field, which should allow you to compare the two values without any issues.

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,535 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @ctedesco3307 ,

Instead of using the Value function, select the Value column for the DCP record:

ClearCollect(colfaitems,Filter(KYOJDCPFocusAreas, DCP.Value = galdcp.Selected.ID));

Was this reply helpful? Yes No
ctedesco3307 711 on at

Like (0)

Report
Copy link

Link copied!

@BCBuizer - that worked! Thank you

Was this reply helpful? Yes No