I'm using a 3 Comboboxes top of a page and trying to show a gallery filter based on selected value of combobox.
At initial load of the screen, the gallery should show all of the items available in the datasource(SQL). So I'm using this condition.
When the screen loads for the first time, this condition is not working at all, it is giving null. So I thought of using IsBlank or IsEmpty function for the same Combobox selected items property. But IsBlank and IsEmpty are workly perfectly for initial load but not working if we clear the Combobox back to no.
Can anyone suggest ?
This is used in Gallery items. for ex: Gallery Items is
But my actual combo box is 3.
Hi @balaji :
I've made a test:
When the comboxbox control is empty——
Therefore, I suggest you try this formula:
Check out new user group experience and if you are a leader please create your group
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.