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

Filter Sharepoint Lookup field

I have a SharePoint List that stores Purchases by Guests during their stay.  I am creating a PowerApp so that I can add purchases for our Active Guests.  I had originally setup the SharePoint List ReservationNum Column to be a lookup field, but I am thinking that it would be better now to have the PowerApp do a lookup in our Reservations SharePoint List for Active Reservations (A Yes/No Column)

 

Can someone help me figure out the best way to structure this and setup that lookup please?

 

Thank you!!!

Tripp

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Filter Sharepoint Lookup field

Hi @TrippK,

 

I didn't see where are you trying to lookup to with Active Reservations column. You only mentioned one Reservations SharePoint List in your description. If you meant that you just what to filter this SP list with Active Reservations(YES/NO) column, then you could try to filter using 0 or 1 instead of true/false. I have tested it on my side and it is working. Example formula:

Filter(table, JobDone=0)

Filter(table, JobDone=1)

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Filter Sharepoint Lookup field

Hi @TrippK,

 

I didn't see where are you trying to lookup to with Active Reservations column. You only mentioned one Reservations SharePoint List in your description. If you meant that you just what to filter this SP list with Active Reservations(YES/NO) column, then you could try to filter using 0 or 1 instead of true/false. I have tested it on my side and it is working. Example formula:

Filter(table, JobDone=0)

Filter(table, JobDone=1)

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

TrippK
Level: Powered On

Re: Filter Sharepoint Lookup field

Thank you Mona for your help.  I guess I would say that I started in the middle of this project and was so excited by all the possibilities that I failed to lay a solid groundwork - so I am going backwards now to fix things.  I think your solution will do what I need - but should I have some additional needs or clarification I will be sure to follow up with you.

 

Thank you for your help and patience  ;o)

 

Tripp

 

Helpful resources

Announcements
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 (Last 30 Days)
Users online (5,003)