SIte arborescence from Excel framework

Like (0) Share

Report

Posted on 7 Nov 2022 14:48:25 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:

Connectors

All responses (2)

Answers (1)

Gwen78 5 on 18 Nov 2022 at 13:39:26

Like (0)

Report

Re: SIte arborescence from Excel framework

Thank you ! It's very helpful 😀
Verified answer

v-chengfen-msft on 09 Nov 2022 at 07:05:44

Like (1)

Report

Re: SIte arborescence from Excel framework

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