web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Issue in creating casc...
Power Apps
Unanswered

Issue in creating cascading dropdowns using sharepoint (excel online) in Power Apps

(0) ShareShare
ReportReport
Posted on by 8

Hi All,

I am new to power apps specifically power platform I am doing power apps and power bi integration.I have 5 fields ID,Region,Country,State,City.When I select any Region it should show the Country related to specific Region.Similarly When I select any State it should show the City related to specific State by using sharepoint(excel online) inside form control.Region and Country is dependent on each other.State and City is dependent on each other.So either State or City is not related to either Region or Country. So 2 parent control(one is Region and other is State)The sample datset is like this:

ID    Region               Country      State             City                  Period          

1     Asia                     India           Karnataka    Paris                  

2     Europe                 Italy              Bihar          Allahabad

3    Europe                  Latvia           UP              Brisbane

4    Asia                      China            Bologna      Capetown

5    Europe                  Poland          HP               Havana

6    Asia                       Indonesia      Hungary     Johannesburg

 

Is it possible to do it like this using sharepoint (excel online) inside form control.If so please show the power FX formula and steps  to achieve the things.

2nd Issue

Inside the Period column there will be dropdowns available but it is not prefilled in the datsource if the user clicks on dropdown of period then only we can select some option until then it will not be prefilled. So is it possible to get this kind of column into power apps and do integration with power BI.Please give some solutions I am struck in this from the past 1 week.

 

3rd Issue 

Say for example Using simple dropdowns I have created power apps and integrated with power apps whren it was developed it was working fine but now we tried opening the power apps inside power BI  the first page is completely blank it is showing loading data since there is no problem in the network speed.Please give some suggestions for all these issues.All suggestions are welcome.Thank you in advance!!

Regards,

Anony_mous

 

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 94

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard