Answered

Update filtered Lookup field in canvas app form

(1) Share

Report

Posted on by senna

217 Season of Giving Solutions 2025

I have a canvas app using a form, one of the fields on the form is a lookup to a Sections SP list which needs to be filtered based on an "Active" field in that list, i have my items field as below and works as it should.

Items

Filter( Sections, Active = true)

My issue is when i submit the form it is not updating my list, this is the update for the lookup field on the list

Update

{
Value:DataCardValue5.Selected.Sections,
Id:LookUp(Sections,Title = DataCardValue5.Selected.Sections).ID
}I just cannot see what the issue could be with this update code, can anyone see why this would not work? Thank you in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @senna,

Please try below:

{ Id:DataCardValue5.Selected.ID, Value:DataCardValue5.Selected.Sections }

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No
senna 217 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @Kalathiya but that is same result, the item does not update, I have another field using same method as i posted above and it works fine so I cannot understand what is different with this field

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @senna,

You are referring to Sections twice (both the field name and the list name) - so are they the same (a very bad practice) or are you displaying the Title column in your Combo Box (what is in the DisplayFields of the Combo Box) ?

So do you need

{ Value: DataCardValue5.Selected.Title, Id: LookUp( Sections, Title = DataCardValue5.Selected.Title ).ID }

or
{ Value: DataCardValue5.Selected.Sections, Id: LookUp( Sections, Sections = DataCardValue5.Selected.Sections ).ID }

or have you renamed the Title field to Sections ?

Also you do not need the true (but this is not related to your issue)
Filter( Sections, Active )

I am also assuming here that both the lookup field and the Combo Box are single choices

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
Hello @senna,

Else you can do just like this make update property as it's.

Item Property:

RenameColumns(ShowColumns(Filter(Sections,Active),ID,Title),ID,Id,Title,Value) //If you want to show any other column instead of title. Just replace it with.

Data Card Update Property:

DataCardValue5.Selected

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

1 people found this reply helpful.

Was this reply helpful? Yes No
senna 217 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @WarrenBelz

The name of the field (on this form) is "Section" and the name of the list is "Sections" and Title field has not been renamed in the Sections list.

Possibly I am referring to the field/list in the wrong place?

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @senna,

That is what I was referring to - the point is that you need to refer to the field name in your DisplayFields in DataCardValue5.Selected.FieldName and the same actual field name in the field referred to in the filter - so to answer the actual correction of the code in your post (assuming Section is your DiusplayFields )
{ Value: DataCardValue5.Selected.Section, Id: LookUp( Sections, Section = DataCardValue5.Selected.Section ).ID }

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

1 people found this reply helpful.

Was this reply helpful? Yes No