How to select te right Excel column

(0) Share

Report

Posted on by Boelebroer

141

Hello,

I am making an aircraft app and I have 3 pages in my app which almost all work fine, however;

When I click on the navigate button on the Airlines page (photo 1) it links to the Aircraft page (which is good) But it gives me all the aircraft data of that Country instead of ONLY the data/aircraft connected to the selected Airline.

What formula should I use so that it only gives me the aircraft of that specific Airline

My Excel has three tabs: Country, Airlines and Aircraft.

CountryID Country

1. Guernsey

2. Mauritius

AirlinesID Airlines

1 Guernsey Bizjets

2. Guernsey Private

Aircraft Tab is in the screenshots

I have attached 3 screenshots to clarify it a little bit 😉

Tnx in advance,

Rene

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (4)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Hi @Boelebroer

No Screenshot. Please attach the screenshot.

Is the user selecting the country from the dropdown?

Was this reply helpful? Yes No
Boelebroer 141 on at

Like (0)

Report

Hello Stalin,

On my first page the countries are below each other automaticlly.

Maybe my Excel layout is not logical..

I hope the screenshots are now attached

2.jpg

1.jpg

3.jpg

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @Boelebroer

When you filter Aircraft it should be
SortByColumns( Filter([@AirCraft], Airlines = selectedID), "AirCraft")

Was this reply helpful? Yes No
Verified answer

Boelebroer 141 on at

Like (0)

Report

I'm getting no aircraft data at all. On the right it says data source Airlines, is that correct? The data I want on the Aircraft page is from the Aircraft Tab (Sorry I'm a newbie)

4.jpg

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
DataSource is AirCraft. Here is the example

What's your selectedID? This Id/Name should exist on the Aircraft sheet with the column name that we are trying to filter

Was this reply helpful? Yes No
Boelebroer 141 on at

Like (0)

Report

I have attached a Excel screenshot of my Aircraft Tab. The name of the column is Airlines.

If I click in my app on the Airlines page on a specific airlines, I want to display only the aircraft from that airline on my Airlines page.

Maybe my Excel formatting of three tabs is wrong and I need to put all the data in one tab?

Screenshot attached with your code and which says datasource Airlines and anotherone from my Excel.

Tnx for your time

Schermafbeelding ...

1.jpg

Was this reply helpful? Yes No
Verified answer

Boelebroer 141 on at

Like (0)

Report

Great support from Anthony!! Problem is solved Tnx

Was this reply helpful? Yes No