CANVAS APP HELP

[rhsood]

Hi 

I have some fields that needs to be filtered based on null value. I also have contact type = provider that needs to be filter.

I have the code written below but its not working. 

Sort(Sort(If(_searchflag = "yes",
If(IsBlank(tbName) && IsBlank(tbZip) && IsBlank('Specialty Dropdown'.Selected.Value) && IsBlank('FA Dropdown'.Selected.Value) && IsBlank('Gender Dropdown'.Selected),
Filter(Contacts = 'Contact Type (Contacts)'.Provider),

If(IsBlank('Specialty Dropdown'.Selected.Value) && IsBlank('FA Dropdown'.Selected.Value) && IsBlank('Gender Dropdown'.Selected.Value),
Filter('Contacts = 'Contact Type (Contacts)'.Provider,"Provider" in 'Contact Type'.Value,tbName.Text in Title, tbZip.Text in 'Zip Code Label'),

If(IsBlank('Specialty Dropdown'.Selected.Value) && IsBlank('FA Dropdown'.Selected.Value),
Filter(Contacts = 'Contact Type (Contacts)'.Provider,tbName.Text in Title, tbZip.Text in 'Zip Code Label','Gender Dropdown'.Selected.Value = 'Gender (gendercode)'),

If(IsBlank('Specialty Dropdown'.Selected.Value) && IsBlank('Gender Dropdown'.Selected.Value),
Filter(Contacts = 'Contact Type (Contacts)'.Provider,tbName.Text in Title, tbZip.Text in 'Zip Code Label','FA Dropdown'.Selected.Value in 'Financial Assistance'),

If(IsBlank('FA Dropdown'.Selected.Value) && IsBlank('Gender Dropdown'.Selected.Value),
Filter(Contacts = 'Contact Type (Contacts)'.Providere,tbName.Text in Title, tbZip.Text in 'Zip Code Label','Specialty Dropdown'.Selected.Value in 'Provider Specialty'.Value),

If(IsBlank('Specialty Dropdown'.Selected.Value),
Filter(Contacts = 'Contact Type (Contacts)'.Provider,tbName.Text in Title, tbZip.Text in 'Zip Code Label','Gender Dropdown'.Selected.Value = 'Gender (gendercode)','FA Dropdown'.Selected.Value in 'Financial Assistance'),

If(IsBlank('FA Dropdown'.Selected.Value),
Filter('Contacts = 'Contact Type (Contacts)'.Provider,tbName.Text in Title, tbZip.Text in 'Zip Code Label','Gender Dropdown'.Selected.Value = 'Gender (gendercode)','Specialty Dropdown'.Selected.Value),

If(IsBlank('Gender Dropdown'.Selected.Value),
Filter(Contacts = 'Contact Type (Contacts)'.Provider,tbName.Text in Title, tbZip.Text in 'Zip Code Label','FA Dropdown'.Selected.Value in 'Financial Assistance','Specialty Dropdown'.Selected.Value in 'Provider Specialty'.Value),

Filter(Contacts = 'Contact Type (Contacts)'.Provider,tbName.Text in Title, tbZip.Text in 'Zip Code Label','FA Dropdown'.Selected.Value in 'Financial Assistance','Specialty Dropdown'.Selected.Value in 'Provider Specialty'.Value,'Gender Dropdown'.Selected.Value = 'Gender (gendercode)'))))))))),

Filter(Contacts = 'Contact Type (Contacts)'.Provider)),'Last Reference',Descending),Miles,Descending)

[v-jefferni]

Hi @rhsood ,

Formula is too complicated to find the issue, could you please consider to provide the App screen with those controls? 

One thing to note, the syntax of Filter function should be as below however you missed data sources in your formula:

Filter(Table, Formula1 [, Formula2, ... ] )

Please refer to the doc below to know more about Filter function:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[rhsood]

Hi, 

I need help filtering the following fields that is currently in dataverse under contacts entity.

I have Specialty Dropdown ( optionset), Gender (optionset), FA (optionset)

This is my current code that I have in the APP. 

I want to do a filter when the value is null for either name, zip,specialty, FA, or gender. I have tried all crazy types of commands and codes as seen before. 

Can someone please assist. 

[v-jefferni · Accepted solution]

Hi @rhsood ,

First of all, you need to know that in function is non-delegable, please refer to the delegation document:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

So, in this case, you'd better use the StartsWith function for those text search boxes:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-startswith#descripti...

I tried to rewrite your formula, please modify my my code with your own table name and column names:

Sort(
     Sort(
          Filter(
                 Filter(
                        Filter(
                               Contacts,'Contact Type'= Contact Type'.Provider
                        ),
                        StartsWith(Title, tbName.Text) && StartsWith('Zip Code Label', tbZip.Text
                 ),
                 IsBlank('Gender Dropdown'.Selected.Value) Or 'Gender(gendercode)'.Value = 'Gender Dropdown'.Selected.Value,
                 IsBlank('Specialty Dropdown'.Selected.Value) Or 'Provider Specialty'.Value = 'Specialty Dropdown'.Selected.Value,
                 IsBlank('FA Dropdown'.Selected.Value) Or 'Financial Assistance'.Value = 'FA Dropdown'.Selected.Value
           ),
           Last Reference',
           Descending
     ),
     Miles,
     Descending
)

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.