web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Gallery not displaying...

Power Apps

Answered

Gallery not displaying data whilst using Search, Date Picker and Dropdown

(0) Share

Report

Report

Posted on by michael_91

58

Hi all

I have a Gallery which i need to show the data from my source " 'bi tac dashboard'", but i cant seem to get it to display results when i have my Search feature, my Date Picker and my Dropdowns added. The code is below, and the last part i added was the Drop down. Prior to adding this, the code worked.

Search(

Filter(

Filter(

'[dbo].[bi_tac_dashboard]',

valuedate = DatePicker.SelectedDate),

Dropdown1.Selected.KPI_Code),

SearchInput1.Text,

ACentity,

KPI_Code

)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @michael_91 ,

Looks like your dropdown filter is missing a condition that it should evaluate ?

Can you perhaps try this

Search( Filter( '[dbo].[bi_tac_dashboard]', valuedate = DatePicker.SelectedDate && // Filter by KPI code selected in Dropdown KPI_CodeColumn = Dropdown1.Selected.KPI_Code //replace KPI_CodeColumn with the correct column ), SearchInput1.Text, ACentity, KPI_Code )

Cheers !

Was this reply helpful? Yes No
michael_91 58 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous_Hippo
That was the missing part i needed, thank you!
KPI_CodeColumn = Dropdown1.Selected.KPI_Code

Was this reply helpful? Yes No

Join the conversation