Unanswered

Filter two dropdowns and two textboxes

(0) Share

Report

Posted on by YdR

Hi all,

Hope you can help me with the following problem. I want to filter the galleries from each phase. When no filter is applied, each bucket/phase (Ideation, Conceptualisation, Realisation and Implementation) should display all records that are applicable to that bucket/phase. However, I also want to filter on:

Responsible (input: textbox)
Innovation name (input: textbox)
Guild (input: combobox)
Chapter (input: combobox)

Can someone please help me with the formula that each gallery should have to enable these options? Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @YdR :

You could try something like:

Filter( YourDataSouce, (IsBlank(ResponsibleTextbox.Text)||Responsible=ResponsibleTextbox.Text)&& (IsBlank(InnovationNameTextbox.Text)||'Innovation name'=InnovationNameTextbox.Text)&& (IsBlank(GuildComboBox.Selected)||Guild=GuildComboBox.Selected.Value)&& (IsBlank(ChapterComboBox.Selected)||Chapter=ChapterComboBox.Selected.Value) )

Best Regards,

Bof

Was this reply helpful? Yes No
YdR 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi powerapp sharing process

Thank you for your reply.
I am using Dataverse and the table name is "Innovations".

I couldn't find the solution I was looking for in the document you sent, do you maybe know how to seal the deal here? Could it be a problem that column "Guild" is a choices column? If so, how do I resolve this issue?

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @YdR :

Please try:

Filter( YourDataSouce, (IsBlank(ResponsibleTextbox.Text)||Responsible=ResponsibleTextbox.Text)&& (IsBlank(InnovationNameTextbox.Text)||'Innovation name'=InnovationNameTextbox.Text)&& (IsBlank(GuildComboBox.Selected)||Guild.Value=GuildComboBox.Selected.Value)&& (IsBlank(ChapterComboBox.Selected)||Chapter=ChapterComboBox.Selected.Value) )

or

Filter( YourDataSouce, (IsBlank(ResponsibleTextbox.Text)||Responsible=ResponsibleTextbox.Text)&& (IsBlank(InnovationNameTextbox.Text)||'Innovation name'=InnovationNameTextbox.Text)&& (IsBlank(GuildComboBox.Selected)||Text(Guild.Value)=Text(GuildComboBox.Selected.Value))&& (IsBlank(ChapterComboBox.Selected)||Chapter=ChapterComboBox.Selected.Value) )

Best Regards,

Bof

Was this reply helpful? Yes No
YdR 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Bof,

Thank you for the quick reply. There still is an error unfortunately. The error message states: we expect a text or number in this phase of the formula.

Was this reply helpful? Yes No
YdR 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,

Do you have a solution for this? 😊

Was this reply helpful? Yes No