cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MaruthiKiran
Level: Powered On

Filter Powerapps lookup column based on status column = "Active"

I have a two SharePoint list: List 1 and List 2. List 1 has a Lookup column.

List1 lookup column name is "Event".

Lookup column data source is List2.

 

Ex: List 2 Looks like below


Title       Status

Event1     Active

Event2     Completed

 

So in List1 Lookup field I need only Event1 In the Drop down (Where Status is "Active" only those values I need in the Drop down) How to apply formula for this in Powerapps?

I was trying formula like below:

List2.Event;Choices(Filter[@'List2'], Status = "Active"))

 

Appreciate your help.

10 REPLIES 10
WarrenBelz
Level 8

Re: Filter Powerapps lookup column based on status column = "Active"

Hi @MaruthiKiran ,

When you refer to Lookup columns, I have assumed it is a SharePoint lookup (so the actual value would exist in List1 pulled from List 2?) Unless you have renamed it, it would be something like Event:Status. If I am wrong, you can disregard the following.

Try drop-down value
Filter('List 1',Event:Status.Value="Active",Event)

There may be some delegation issue as I believe a lookup column result is not delegable.

It is for this (and many other reasons) I totally avoid SharePoint Lookups as you can do the same query in PowerApps across two tables far easier. They also present challenges when writing back data other than a straight submit form from a choices list (I mention this as you will need to save it using the #Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference) .

 

kbilakanti
Level 8

Re: Filter Powerapps lookup column based on status column = "Active"

@MaruthiKiran I have attached screenshots for your requirement which parent, child list and powerapps screen with Dropdown and forumla. Please let me know if that works.

 

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

WarrenBelz
Level 8

Re: Filter Powerapps lookup column based on status column = "Active"

Thanks @kbilakanti ,

I seem to be on the wrong track if this is a simple PowerApps lookup

kbilakanti
Level 8

Re: Filter Powerapps lookup column based on status column = "Active"

@WarrenBelz  Welcome. If this solution resolves your issue. Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

MaruthiKiran
Level: Powered On

Re: Filter Powerapps lookup column based on status column = "Active"

Hi WarrenBelz, 

Yes, its not a sharepoint lookup column.It lookup (Event) created using power apps.

MaruthiKiran
Level: Powered On

Re: Filter Powerapps lookup column based on status column = "Active"

Hi WarrenBelz, Yes, its not a sharepoint lookup column.It is a lookup (Event) created using power apps.

MaruthiKiran
Level: Powered On

Re: Filter Powerapps lookup column based on status column = "Active"

WarrenBelz
Level 8

Re: Filter Powerapps lookup column based on status column = "Active"

Hi @MaruthiKiran 
So I assume @kbilakanti 's responce is what you needed?

MaruthiKiran
Level: Powered On

Re: Filter Powerapps lookup column based on status column = "Active"

kbilakanti's solution using SharePoint lookup column.But  i want to implement using power apps lookup column. https://www.youtube.com/watch?v=43ekj5MlNJU.

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,138)