News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Filter forms

Power Apps - Building Power Apps

Answered

Filter forms

(0) Share

Report

Report

Posted on by Nogsthenog

23

Hello, I'm new to Powerapps and trying to work out how to filter.

I have several sharepoint lists but for this example I have 2 - ExportBookings and CountryInfo

1st app screen - Gallery listing all ExportBookings (with checkbox filter for 'today' and once i can work out how to do 2 filters together, a search on reference number as well)

2nd app screen - ExportBookings - detailed data related to the booking selected on screen1

3rd app screen - ExportBookings EHC field and CountryID field related to the booking selected on screen 1

and

CountryInfo All detail data from CountryInfo field relating to the country shown in the CountryID field above

I can't get the CountryInfo data to show with the following filter:

Filter(CountryInfo, Country = DataCardValue37.text) DataCardValue37 is the CountryID from ExportBookings

I've also tried it with putting the list field name in as well and i couldn't get that to work either.

Any assistant gratefully received.

Filter Issue Powe...

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

Nogsthenog 23 on at

Like (1)

Report

Re: Filter forms

Thank you very much for your help. Once you pointed me in the right direction I was able to get it to work with this:-
LookUp(CountryInfo,Country= DataCardValue37.Selected.Value)

Thank you
Verified answer

LaurensM 12,525 on at

Like (0)

Report
Re: Filter forms

Hi @Nogsthenog,

It looks like you are using a ViewForm to display the Country information. The Item property expects a single Record and not a table of records - which the Filter() function returns. Try to use a LookUp() function instead:

LookUp(CountryInfo, Country = DataCardValue37.text)

The DataSource property will need to be CountryInfo

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Give Back to the Community this Month

Quick Links

Leaderboard

#1

WarrenBelz 143,591

#2

RandyHayes 76,308

#3

Pstork1 64,090

Leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value

How to patch multiple records at once

Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans