Gallery filter works in studio but not in app

[CAlvy]

In my canvas app I have three 'dashboard' screens which are set up the same but using different data. The galleries use a Filter function and that references a few combo boxes and two check boxes per screen. There are no delegation warnings.

In Studio, all filters work fine. In the published app only the combo box filters work on two screens. Selecting the check boxes should still display records but no records appear. However, on one of the screens, one of the checkboxes does work.

Also, it worked for a period of time yesterday in the app.

I haven't got any preview or experimental features turned on. Is there anything else I can try?

I do have warnings that I have too many controls on each screen. Could that be it?

[FLMike]

@CAlvy 

Hey my car stops doing its thing, can you tell me why 🙂 no because I have no details on the car.

Please add code and pictures.

Item properties

Filters

Screenshots, you name it.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[CAlvy]

True! 🙂

Item for gallery:

SortByColumns(Filter(colProjectDashboard,
And(
Or(
IsBlank(ComboBox_Approver_3.Selected.Value),
IsEmpty(ComboBox_Approver_3.SelectedItems),
'Approver Name' in ComboBox_Approver_3.SelectedItems),
Or(
IsBlank(ComboBox_Checker_3.Selected.Value),
IsEmpty(ComboBox_Checker_3.SelectedItems),
'Checker Name' in ComboBox_Checker_3.SelectedItems),
Or(
IsBlank(ComboBox_DocOwner_11.Selected.Value),
IsEmpty(ComboBox_DocOwner_11.SelectedItems),
'Originator Name' in ComboBox_DocOwner_11.SelectedItems),
Or(
IsBlank(ComboBox_CTR_7.Selected.Value),
IsEmpty(ComboBox_CTR_7.SelectedItems),
'Package Number' in ComboBox_CTR_7.SelectedItems),
Or(
IsBlank(ComboBox_MilestoneOwner_3.Selected.Value),
IsEmpty(ComboBox_MilestoneOwner_3.SelectedItems),
'Linked_Deliverable: Owner'.Value in ComboBox_MilestoneOwner_3.SelectedItems),
Or( 
IsBlank(ComboBox_Receiver_3.Selected.Value),
IsEmpty(ComboBox_Receiver_3.SelectedItems),
ComboBox_Receiver_3.Selected.Value in Concat('Linked Interface:ReceiverName_Text', Value, "; ")),
Or(
IsBlank(ComboBox_Sender_3.Selected.Value),
IsEmpty(ComboBox_Sender_3.SelectedItems),
ComboBox_Sender_3.Selected.Value in Concat('Linked Interface:SenderName_Text', Value, "; ")),
Or(
IsBlank(ComboBox_DocStatus_3.Selected.Value),
IsEmpty(ComboBox_DocStatus_3.SelectedItems),
ComboBox_DocStatus_3.Selected.Value in 'Late-Due'),  
Or(
IsBlank(ComboBox_MilestoneStatus_3.Selected.Value),
IsEmpty(ComboBox_MilestoneStatus_3.SelectedItems),
ComboBox_MilestoneStatus_3.Selected.Value in 'Linked_Deliverable: Status'.Value),
Or(
IsBlank(ComboBox_InterfaceStatus_3.Selected.Value),
IsEmpty(ComboBox_InterfaceStatus_3.SelectedItems),
ComboBox_InterfaceStatus_3.Selected.Value in 'Linked Interface:Status'.Value),
Switch(Checkbox_Milestones_3.Value, true, !(IsBlank(Linked_Deliverable.Value)), Checkbox_Interfaces_3.Value, true, !(IsEmpty('Linked Interface'))), 
Component_SearchBox_5.SearchValue in 'Document Title' ||
Component_SearchBox_5.SearchValue in 'Primary Document Number' ||
Component_SearchBox_5.SearchValue in Linked_Deliverable.Value ||
Component_SearchBox_5.SearchValue in Concat('Linked Interface', Value, "; ") ||
Component_SearchBox_5.SearchValue in Concat('Linked Interface:Status', Value, "; ")))
,"DaysLateNumber" , SortOrder.Descending)

It's this Switch which isn't working properly

Switch(Checkbox_Milestones.Value, true, !(IsBlank(Linked_Deliverable.Value)), Checkbox_Interfaces.Value, true, !(IsEmpty('Linked Interface')))

Screenshot of app failing:

Issue I'm getting in the app checker: Too many controls on a screen. Complexity is 367 where the maximum threshold recommended is 300

Hope that helps.

[FLMike]

@CAlvy 

Thanks!! let me look at it now, much better btw truly appreciate you being a good sport 🙂 My old man eyes thank you too hehe

[FLMike]

Hi @CAlvy 

Clarifying questions

1. when you say it works in Studio, I am assuming you mean when you are testing it? So in that case you are probably an admin in that environment and possibly an admin on the data?

2. When the others test it, or if you also mean it doesnt work for you when Published. Does it point to the same location?

Usually when filters etc fail its for 3 reasons

1. You have a bug and are lucky it works in Dev

2. You have a data issue in the environment that the app points too when Not in dev

3. You have a permissions / security / Auth / AuthX / Role / Environmental Config etc issue where you dont see it in Dev because you are using Dev data and its all nicely popluated

As long as you mean, I publish and then I run the published app and it doesn't work

While I review, please do this.

Step 1. Close your App (stop it running)
Step 2. Go to the Apps list in your environment
Step 3. Find your App and click the 3 ... to get the popup menu

Step 3b. Click on Run monitor
Step 4. Once Monitor is running in its own tab, Click the button that says Play Published Version/App
Step 5. Go to the place in your app, but don't trigger the issue yet, or even if it already did the second you got to the screen ignore it.

Step 5b. Go to Monitor and Choose Clear Data in the Top Left Corner
Step 6. Cause the Issue to happen, but only click the one check box

Step 7. Go to the Monitor and Filter (top right) based on Error, or key word. Go to the line or lines that match this
Step 8. Look at the Response Tab and you will have to expand the Body > and the Header >. Then look at the body to see more details on the error
Do this for each line you find

Now if there are no errors, then do a Filter on your query, so a name of a control or the items property or the name of the control

And walk through all the Lines of course it does

Just to make sure you aren't hitting some weird permission issue.

=================================================================

Next, if this is a different environment, then verify that you have data in that environment that would actually meet your criteria.

I will keep looking at your Filter, especially since I now have the details of it.

[FLMike]

Sorry for the spam. When you say its not working

Can you tell me which Contols are tied to that?

[FLMike]

Hi @CAlvy 

I am trying to determine what you were trying to get out of this

Switch(Checkbox_Milestones_3.Value, 
    true, 
        !(IsBlank(Linked_Deliverable.Value)), 
    Checkbox_Interfaces_3.Value, 
        true, 
    !(IsEmpty('Linked Interface'))
), 

So if CheckBox_milestones_3.value

When true

return the boolean value of Linked XXXX

When XXXInterfaces is true,

    return true

and

Isempty bla bla returns a boolea

But what are you using the boolean for to compare against other than its just true or false?

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[CAlvy]

Hi @FLMike , thanks for having a look and providing some help.

Yes, that's right. It's the same for me and other users when testing in the app. I don't think it's to do with environment or data permissions. The data source is SharePoint. I should have also pointed out that this all used to work fine - the checkboxes used to display the items for myself and users.

I used the Monitor but no errors came up and there wasn't anything unusual with the controls. There are lookups that occurred and warnings which are just 'Formula not delegated' and advising how many rows are scanned but nothing else that looks like a problem. I also tried it with the checkbox that did display items. The only difference was more lookups.

In terms of the Switch function, it might not have been the best way of doing this but I couldn't find another way. Essentially my gallery items data has two lookup columns - one links to 'milestone' data in another SharePoint list and the other to 'interface' data also in SharePoint. When the user selects the Milestone checkbox, they should be able to see on the dashboard all the items which have a lookup to a milestone. The same for the Interface checkbox. If selecting both, they should see items where there is a lookup to milestone and interface. Perhaps there's a better way I can write this into the formula?

[FLMike]

How @CAlvy  about this

Yeah the issue I see though is that just having a boolean value, provides no value to the query.

 meaning

Filter('source', a = b, true) doesn't do anything and based on where your ( ) are, thats all your providing is the word true or false.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[CAlvy]

Yes, I think it's actually excluding the linked records from the gallery. I added a count of records to the dashboard. On one of the dashboards I only had 1 record linked (to both a milestone and interface). Although I have 97 records, it was only displaying 96 without any filters. I linked another record and it displayed 95. However, if I search for the linked record, it will display it and then the checkboxes do work. 

I will remove the Switch and test again to see if that is the cause of the issue.