Filter forms

(0) Share

Report

Posted on by Nogsthenog

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.

Categories:

Building Power Apps

Filter Issue Powe...

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

LaurensM 12,516 Moderator 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!

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No