SIte arborescence from Excel framework

(0) Share

Report

Posted on by Gwen78

Hello,

I am trying to create a Power apps form and I want to connect an Excel framework. For example :

France	Paris	Books
France	Paris	DVD
France	Lyon	Books
France	Lyon	Music
Belgium	Bruxelles	DVD
Belgium	Liege	Books
Belgium	Liege	Music
Belgium	Bruges	DVD

I want to have a dropdown with the countries. If I click on Blegium, I want to see a dropdown with the Cities. If I click on Liege I want to see a dropdown with Books and Music. If I click on books, I want to open a form.
Can you tell me if it's possible or not ? And if it's possible, how to do this ?

Gwen,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-chengfen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Gwen78 ,
Here is a test for your reference:
Here is Excel table:

Here is app:
Set Dropdown1 ‘s items: Distinct(Table1_2,countries)
Set Dropdown2 ‘s items: Distinct(Filter(Table1_2, countries = Dropdown1.Selected.Result),Cities)
Set Dropdown3 ‘s items: Distinct(Filter(Table1_2, Cities = Dropdown2.Selected.Result),'Books and Music')

Set Form’s DataSource: Table1_2
Set Form’s item: LookUp(Table1_2,countries=Dropdown1.SelectedText.Value && Cities=Dropdown2.SelectedText.Value&&'Books and Music'=Dropdown3.SelectedText.Value)

Here is result:

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Gwen78 5 on at

Like (0)

Report
Copy link

Link copied!

Thank you ! It's very helpful 😀

Was this reply helpful? Yes No