Can we filter SharePoint Lookup field based on a Yes/NO field

(0) Share

Report

Posted on by johnjohn123

3,506

I have 2 lists inside our SharePoint online site:-

1) Devices

2) MobileSubmissions

now the Devices has these fields:-

and the MobileSubmission has a lookup field to the Devices list, as follow:-

now i created a new PowerApp Canvas and i defined the MobileSubmission as the source >> then inside the Canvase app i added a new form and i defined the MobileSubmission as the source >> now for the Lookup field, which have the following settings:-

can i only show the Devices items which has IsAvailable =Yes?instead of showing all the Devices's list items? thanks in advance for any help.

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (0)

StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @johnjohn123

Corrected One

Filter(MobileSubmission,IsAvailable).Title

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report
Copy link

Link copied!

@StalinPonnusamy thanks for the reply,, but where i need to add this formula inside the Lookup's items?

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Yes, Set the Items property of the DevicesLookup (Combo Box) Which displays the available devices.

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report
Copy link

Link copied!

@StalinPonnusamy ok will try it and let you know who thing will work.. thanks

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report
Copy link

Link copied!

@StalinPonnusamy i tried the following:-

but i got an error that Filter has some invalid arguments.. any advice?

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report
Copy link

Link copied!

@StalinPonnusamy i also tried the following:-

where i did not get any error >> but when i submit the form the lookup field will not get populated... any advice?

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @johnjohn123

1. Set the Combobox Items Property to
Filter(Devices,IsAvailable)

2. Set the field to Title for the combobox to display and search
3. On the Patch command
Patch( MobileSubmissions, If( EditForm1.Mode = FormMode.New, Defaults(MobileSubmissions), LookUp( MobileSubmissions, ID = BrowseGallery1.Selected.ID ) ), { Deviceslookup: { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: Combobox1.Selected.ID, Value: Combobox1.Selected.Title } } )

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report
Copy link

Link copied!

@StalinPonnusamy but where i need to add the Patch command?can you advice more please?

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Patch command is OnSelect of "Save button"

It should Create or Update.

Note: You may need to add other required fields (Like Title is required by default on SP List)

Was this reply helpful? Yes No
johnjohn123 3,506 on at

Like (0)

Report
Copy link

Link copied!

@StalinPonnusamythe list i am planning to build will have around 50 fields, the current fields are just a sample .. so can i use the Patch field to update the lookup value only while the other fields to be updated by the submit form command?

Was this reply helpful? Yes No