Answered

Filter Lookup Field Not Saving

(0) Share

Report

Posted on by Ellaboomin

Hi All,

I'm trying to set a filter on my lookup column on a SharePoint list from the child list name IssyeType. The Parent list is name Support Request.

The formula for the filter is the following:

Filter(IssueType, AT2 = Dropdown1.Selected.Value)

The filtering is working, but when I click to save, nothing happens in the lookup field, the Issue Type from the parent list doesn't reflect the dropdown selected.

I've also updated the Update field to as following

If(
!IsBlank(IssueType),
(
{
'@odata.type': "Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id:Dropdown5.Selected.Title,
Value: 'Support Request'.'Issue Type'}))

What should I change to make it work?

Thank you

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ellaboomin ,

From the code mentioned are you using the Parent list directly in the dropdown which you used of the lookup ?
Ellaboomin 6 on at

Like
a
(0)

Report
Copy link

Link copied!

No Im using the child list for the dropdown box am I supposed to use the parent lookup field.?
Verified answer

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Ellaboomin ,

Could you try with Parent lookup field if possible and update the code as below ?
{ '@odata.type': "Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id:Dropdown5.Selected.Id, Value: Dropdown5.Selected.'Issue Type'}))
Ellaboomin 6 on at

Like
a
(0)

Report
Copy link

Link copied!

I do the parent lookup for the dropdown but can't get the filter to work.?
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ellaboomin ,

In that case would you mind looking up value in the Parent list for Value and ID pair of the child patch ?