Hi. I am struggling to connect two dropdown panel to the gallery to work properly
My first dropdown Items code is
Sort(Distinct(IB_Input; Coverage); Result; Ascending)
My second dropdown Items code is
Sort(Distinct(IB_Input; Sales_Play); Result; Ascending)
I am trying the following code in the Gallery Items, but the gallery shows empty box
Any suggestions would be really helpful as this is the last thing to do for this app.
Solved! Go to Solution.
@Ashwin7104 Thanks for the prompt response.
It works, but the exclamation marks appears in a sign. When testing the app, only some rows appear after dropdown option selection, not all.
Am I doing the cascading dropdown right like this? I saw some YT tutorials and some advices here and a lot of people are using isblank formula in the gallery items section, which is very different from what I've done.
@TCop93 - We must apply the delegation idea so that data is filtered in the data source and then fed into PowerApps. What's is the data type for Coverage and Sales Play? Is SharePoint being utilised as a data source?
@Ashwin7104 Unfortunatelly not SharePoint, but Excel... I am now moving to Sharepoint with all the data as, according to information I've found, PowerApps do not treat Excel as delegatable. Thus, the migration process is in place. It should work smoothly on SharePoint now.
Thank you for your support.
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!