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


Report
All responses (
Answers (