web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filtering lookup colum...

Power Apps

Answered

Filtering lookup column is not saved

(0) Share

Report

Report

Posted on by Purman0

35

Hi All,

I'm trying to set a filter on my lookup column on a SharePoint list form.

The formula is the following:

Filter(Classifications, Category in "Availability").Title

The filtering is working, but when I click to save, nothing happens in the lookup field, the old value remains there.

What should I change to make it work?

Thank you

Categories:

Building Power Apps

All responses Img

All responses (5)

Answers Img

Answers (1)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Purman0 Try this,
Filter(Choices(Classifications.Category), Value="Availability")
Purman0 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @CNT , unfortunately it gives an error:
Should I change something?
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Purman0 It looks like the Column Name "Category" is wrong. Could you check that. If yous till get an error please let me what error it is.
Purman0 35 on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT

Please find below the field properties (from the Classifications list):
@CNT wrote:
@Purman0 It looks like the Column Name "Category" is wrong. Could you check that. If yous till get an error please let me what error it is.
Verified answer

Purman0 35 on at

Like
a
(2)

Report
Copy link

Link copied!

I found the solution, the items property for the lookup dropdown is the following:
Filter(Classifications, Category = "Availability")

While the Update property of the datacard had to be changed to the following from DataCardValue17.Selected to the following formula:
If(
!IsBlank(DataCardValue17),
(
{
'@odata.type': "Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id:DataCardValue17.Selected.ID,
Value: DataCardValue17.Selected.Classification}))

Join the conversation