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

Full screen.png

Intern - button o...

Intern - gallery ...

I have the same question (0)

All responses (5)

Answers (0)

v-bofeng-msft on at

Like (0)

Report
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 (0)

Report

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 on at

Like (1)

Report
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 (0)

Report

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 (0)

Report

Hi @v-bofeng-msft ,

Do you have a solution for this? 😊

Was this reply helpful? Yes No