Answered

PowerApps Filter Problem

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Dear users,

I am trying to build a power app and I feel like I crash on a wall. The Use case is : I want to filter my source ('Master source' in this case a SharePoint list) by Project title and replacement project.

I want to fulfill also 4 scenarios,

If both drop-downs are empty
If dropdown1 is empty and dropdown2 has a value
If dropdown2 is empty and dropdown 1 has a value
If both dropdowns have value

And I want it also to filter some fields of my SharePoint list :

Type= "Application"
TargetDecision= "Migration"
Madrid_DB2 = " Madrid and Evonik"
Madrid_DB"= "Evonik Only"

My code is with blue underlined and looks like this:

Filter(
'Master Source';

If(
And(IsBlank(Dropdown1.SelectedText.Value);IsBlank(Dropdown2.SelectedText.Value));And(Type="Application"; TargetDecision.Value="Migration"; Or(Madrid_DB2.Value="Madrid and Evonik";Madrid_DB2.Value="Evonik only"));

If(
And(Not(IsBlank(Dropdown1.SelectedText.Value));Not(IsBlank(Dropdown2.SelectedText.Value)));And(Type="Application"; TargetDecision.Value="Migration";ReplacementTechnology.Value=Dropdown2.SelectedText.Value;ReplacementProject_PPM.Value=Dropdown1.SelectedText.Value; Or(Madrid_DB2.Value="Madrid and Evonik";Madrid_DB2.Value="Evonik only"));

If(
And(Not(IsBlank(Dropdown1.SelectedText.Value)); (IsBlank(Dropdown2.SelectedText.Value)));And(Type="Application"; TargetDecision.Value="Migration";ReplacementProject_PPM.Value=Dropdown1.SelectedText.Value; Or(Madrid_DB2.Value="Madrid and Evonik";Madrid_DB2.Value="Evonik only"));
And(Type="Application"; TargetDecision.Value="Migration";ReplacementTechnology.Value=Dropdown2.SelectedText.Value; Or(Madrid_DB2.Value="Madrid and Evonik";Madrid_DB2.Value="Evonik only"))

))))

I have attached a Pic just to visualize the app. If anyone can help me I would be grateful !!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Please try this code:
Filter('Master Source'; Type="Application" && TargetDecision.Value="Migration" && Or(Madrid_DB2.Value="Madrid and Evonik";Madrid_DB2.Value="Evonik only") && If(IsBlank(Dropdown1.SelectedText.Value); true; ReplacementProject_PPM.Value=Dropdown1.Selected.Value) && If(IsBlank(Dropdown2.SelectedText.Value); true; ReplacementTechnology.Value=Dropdown2.Selected.Value))
If this doesn't work, please post back the error screenshots of code, and the date type of these fields.
Best regards,
Sik

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-siky-msft

Thank you for replying to my post. The costumer decided to change a bit the User Story , so i need to filter the drop-downs in 2 screens. The error that i get is a blue line under the code before the IF Filter('Master Source'; Type="Application" && TargetDecision.Value="Migration" && Or(Madrid_DB2.Value="Madrid and Evonik";Madrid_DB2.Value="Evonik only") && If(IsBlank(Dropdown1.SelectedText.Value); true; ReplacementProject_PPM.Value=Dropdown1.SelectedText.Value))
as far i understand it tells me that my drop-downs are looking in a Table for Information, but it is a SharePoint list behind...

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous
Could you share the detailed error information with the formula?
What are the date types of 'ReplacementProject_PPM' and 'ReplacementTechnology' columns? Could you please share the Items property of Dropdown1?

This delegation error is seemly caused by the IF function inside the Filter function. So I suggest move the IF function out of the filter function, first to check if the dropdown is blank, and then filter the SP list. Please try this code:

If(IsBlank(Dropdown1.Selected.Value); Filter('Master Source'; Type="Application" && TargetDecision.Value="Migration" && Or(Madrid_DB2.Value="Madrid and Evonik";Madrid_DB2.Value="Evonik only")); Filter('Master Source'; Type="Application" && TargetDecision.Value="Migration" && Or(Madrid_DB2.Value="Madrid and Evonik";Madrid_DB2.Value="Evonik only") && ReplacementProject_PPM.Value=Dropdown1.Selected.Value))

Best regards,
Sik

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This Formula is working perfectly!! thank you very much!! My data Columns in SP are simple line of text and i Just added a Gallery and a Dropdown that takes the data from those columns and filter them (with other 3 Columns) and gives me the results. Thank you very much 🙂

Was this reply helpful? Yes No