Filter SharePoint Lookup field Choice

(0) Share

Report

Posted on by crmr298

I have the following SharePoint lists:

Locations (location - single line of text)
Areas (area - Single line of text0
Location Areas (location - lookup, area - lookup)
Log (Location - lookup, Area - lookup, date, responsible party - single line of text)

I'm editing the form for Log in PowerApps and when a user selects a Location, I want the Areas combo box to filter down to just those areas available at that location (eg in Location Areas).

Here is my formula for item in Area:

Filter(Choices(Log.Area), Value in Filter('Location Areas', Location.Value = DataCardValue2.Selected.Value).Area

DataCardValue2 is my Location data card.

I'm getting an error on the first "Value":

Can't convert this data type. Power Apps can't convert this Text to a Record.

Any ideas here?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @crmr298 ,

Regarding the formula that you mentioned, I think there is something wrong with it. The first "Value" in your Filter function return a text value, but the Filter('Location Areas', Location.Value = DataCardValue2.Selected.Value).Area formula returns a Table value. You could not compare a Text value with a Table value directly.

Please consider modify your formula as below:

Filter( Choices(Log.Area), Value in Concat( Filter( 'Location Areas', Location.Value = DataCardValue2.Selected.Value ), Area.Value & ";" ) )

Please consider try above solution, hope it could solve your problem.

Regards,

Was this reply helpful? Yes No
crmr298 21 on at

Like
a
(0)

Report
Copy link

Link copied!

This solved my problem. Thank you!

Was this reply helpful? Yes No