Add additional Filter to code not working

[Dorinda]

I have a gallery that has this on the items property 

SortByColumns(
Filter(
CRM_Docs,
'Folder path' = varFolderPathCurrent,
'Folder path' = varFolderPathCurrent

),
"{IsFolder}",
SortOrder.Descending,
"{Name}",
SortOrder.Ascending
)

I need to add an additional filter to only show documents for the varCustomerName.  The code above works great but shows everyones documents.

I have tried every possible combonation to try to get this to work as expected

SortByColumns(
    Filter(
        CRM_Docs,
        And(
            'Folder path' = varFolderPath,
            Doc_Account.Value = varCompanyName
        )
    ),
    "{IsFolder}",
    SortOrder.Descending,
    "{Name}",
    SortOrder.Ascending
)

No matter what I do, it breaks the code nothing shows and it is not filtering, I cannot figure out why this is not working
Here is what it should look like when with the original code 

this is what it looks like no matter what I add to the code 

what am i doing wrong, any help would be appreciated!!

[BCBuizer]

Hi @Dorinda ,

You seem to be mixing up names a bit:

- varCustomerName vs. varCompanyName vs. varCompanyName.Account

- Doc_Account vs. Account 

Perhaps the below works:

SortByColumns(
	Filter(
		CRM_Docs,
		'Folder path' = varFolderPathCurrent,
		Doc_Account = varCompanyName.Account
	),
	"{IsFolder}",
	SortOrder.Descending,
	"{Name}",
	SortOrder.Ascending
)

If this doesn't work, please confirm the name of the column you wish to filter for and the schema of the variable.

[Dorinda]

Yes you are right i have confused this a bit here is the revised code of yours 

SortByColumns(
Filter(
CRM_Docs,
'Folder path' = varFolderPathCurrent,
Account = varCompanyName.Account
),
"{IsFolder}",
SortOrder.Descending,
"{Name}",
SortOrder.Ascending
)

I stopped using the Doc_Account because it was a lookup column and it was causin even more of a mess.  Account is a single line of text inthe CRM_Docs library.  The varCompanyName is the correct variable I am using.

That all being said No Joy still not showing anything.

[BCBuizer]

Hi @Dorinda ,

THanks for clarifying. Can you please share the schema of the variable and perhaps some sample data for both the library and the variable?

[Dorinda]

on the select on Combobox1 I have this 
Set(varCompanyName, First( ComboBox1.SelectedItems));

this is on the items property of that combobox
Sort(
Filter('LPS Accounts', Status.Value = "Current"),
Account,
SortOrder.Ascending
)

[Dorinda]

This is not solved and I really could use some help!! @RandyHayes 

[BCBuizer]

Hi @Dorinda ,

Please share an example with screenshots of a value for varCompanyName. I'm sure there's a mismatch somewhere.

[Dorinda]

The sharepoint list is called LPS Accounts i am using the Title field to store the Account name

I have also added a single line of text field in the CRM Docs to see if that makes a difference it didnt 

I have tried matching the Title on both sides of the Code the lookup everything nothing is working 

SortByColumns(
Filter(
CRM_Docs,
'Folder path' = varFolderPathCurrent,

Account = varCompanyName.Title

),
"{IsFolder}",
SortOrder.Descending,
"{Name}",
SortOrder.Ascending
)

If I just do a straight filter like this it works just fine

Filter( CRM_Docs, varCompanyName.Account= Account) 

Please ignore the labels one is for Doc_Accounts and the other it just Account. When I add back in the Folder Path piece is where it falls apart.

[BCBuizer]

Hi @Dorinda ,

Isn't 'Folder Path' a system field? Those are not delegable, so that may be a thing to look into: https://learn.microsoft.com/en-us/connectors/sharepointonline/#delegation-notes

[Dorinda]

I saw this 

but it is not a large data set so I didnt think it was applicable.

[cwebb365]

If the dataset has more than 500 records total (or 2000 if you change setting) it will be a problem.