web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Gallery - drop ...

Power Apps

Answered

Filter Gallery - drop down and calendar

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi

I need help with the formula, I'm having difficulty adapting a formula.

First, the data source is in Sharepoint (List), there are 5 columns, it's called CHP.

Imagem 1.png

And PowerApps, has a calendar, gallery and form.

Imagem 2.png

I am trying formula with the gallery, I managed to filter the list by date, the formula is:

SortByColumns(Filter(CHP;Text('Data do Inicio';DateTimeFormat.ShortDate) = Text(_dateSelected;DateTimeFormat.ShortDate)); "Data_x0020_do_x0020_Inicio")

I am also trying 1 more filter for dropdown, which is name list, wanted to filter by name to see the list.

SortByColumns(Filter(CHP;Text('Data do Inicio';DateTimeFormat.ShortDate) = Text(_dateSelected;DateTimeFormat.ShortDate)); "Data_x0020_do_x0020_Inicio");; Filter(CHP; ‘Usuários’ = dropdown2.Selected.Value)

Appeared as an error, could you help me how to filter the dated hold?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Help

Was this reply helpful? Yes No
Verified answer

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

What is the column type of Usuários?

If it's a text column, then the formula should be:

SortByColumns(Filter(CHP;Text('Data do Inicio';DateTimeFormat.ShortDate) = Text(_dateSelected;DateTimeFormat.ShortDate);‘Usuários’ = dropdown2.Selected.Value); "Data_x0020_do_x0020_Inicio")

If it's a person and group column, then the formula should be:

SortByColumns(Filter(CHP;Text('Data do Inicio';DateTimeFormat.ShortDate) = Text(_dateSelected;DateTimeFormat.ShortDate);‘Usuários’.DisplayName = dropdown2.Selected.Value); "Data_x0020_do_x0020_Inicio")

Regards,

Mona

Was this reply helpful? Yes No

Join the conversation