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

Filter Data Between 2 SharePoint List

Hello,

 

I have 2 sharepoint list as "Offers" and "Products". Product list has Offer name in it to make relation. 

 

On my power app, i have started my application with Data Source as "Offers" and created 3 basic pages as , List, Detail and Add/Edit page. Now on my Detail Page what I want is with the offer details want to display list of products which are associated with this offer. For that I have added another data source of the offers on the application.

 

Now, on my detail page I have added new listbox control and apply formula to filters products and display on details page based on the offer selected. Formula I have written as "Filter([@Products],[@Products].OfferName = ThisItem.Title").Title" which ideally returns me the table of filtered product associated with the selected offer, but everytime it give me error at "="  sign in logical test area. I dont understand what I am making wrong hence this is not working. I am looking to display filtered products in the listbox.

3 REPLIES 3
Community Support Team
Community Support Team

Re: Filter Data Between 2 SharePoint List

Hi @manthan_upadhya,

 

Please try to insert the list box into the corresponding data card (by default the card is locked, we need to unlock it to insert controls), then we should be able to use the Thisitem function.

In addition, try to change the formula with the following format:

Filter([@Products],ThisItem.Title in [@Products].OfferName)

Add a screenshot for reference:

53.PNG

This gives no error, but the result is not always right, using "=" seems not working for the title field in SharePoint list.

I will try some more testing from my side.

In addition, take a try with the search function, this should work:

Search('Testing list',ThisItem.Title,"Change")

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
manthan_upadhya
Level: Powered On

Re: Filter Data Between 2 SharePoint List

Hi,,

 

I have OfferName as look up field in Products List with single value selection. On my offer Details Page, I have added new data Card and inserted Listbox. Now when I have added formula suggested by you it still not returns me the result and display readline below the thisitem.title.

 

Also, I have tried in other way, Now I have added ProductsName as Lookup field in OffersList and tried with single selection/ Multiple selection option but still it didnt shows me the result. I have tried with Search and Filter both the option.

Offer List structure:

 

ID
Open ID sort and filter menu
OfferName
Open OfferName sort and filter menu

 

Location
Open Location sort and filter menu
OfferOwner
Open OfferOwner sort and filter menu
DateAdded
Open DateAdded sort and filter menu
DateExpires
Open DateExpires sort and filter menu
OfferPrice
Open OfferPrice sort and filter menu
Verticals

 

AssociateProducts
 

 

 

 

Community Support Team
Community Support Team

Re: Filter Data Between 2 SharePoint List

Hi @manthan_upadhya,

 

There is no need to add an additional datacard.

Datacards are the building blocks of the Edit form and Display form controls. The form represents the entire record, and each card represents a single field of that record.

See: Understand Data cards.

By the way, could you please show me the screenshot of your added data card?

In addition, please also take a look of the known issues when using SharePoint list:

Connect from Microsoft PowerApps to SharePoint

Regards

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

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 423 members 5,067 guests
Please welcome our newest community members: