Gallery Issue Delegation

[johnm_]

Hi,

Thanks in advance for the help 🙂 At first my app was working then the gallery module from sharepoint list stop working now.

I got this error below

Can someone help what does means?

Here's the code for this

On left gallery On items (filter)

Sort(
      Filter(
              Visitors_Master_List,IsBlank('Checkout Datetime'
                                    )
      ),'Name (Title)', SortOrder.Descending
)

This pull names of users that haven't check out on the app

On the right is name information on visible

!IsEmpty(
         Filter(
                Visitors_Master_List,IsBlank(
                                             'Checkout Datetime'
                                     )
         )
)

Can someone help why it stop working? Thank you! Sharepoint list entry is now on 505 items if that helps.

It's not pulling and showing info from sharepoint list now with all the issue icon (issue is reference above this post) (see below)

[johnm_]

Hi @BCLS776 

It worked for a bit then it came back when I restored the deleted items and items are now on 509 count, weird. 

heres my visible code if I need to change anything here

  !IsEmpty(
         Filter(
                Visitors_Master_List,IsBlank(
                                             'Checkout Datetime'
                                     )
         )
)

Heres the error

Is there another solution for this? Thanks!

[johnm_]

I think has something to do with the visible, when I refresh app and go to checkout it shows the sorted list for a bit then it disappears 😞 

Do I need to change anything here? 

Visible

!IsEmpty(
         Filter(
                Visitors_Master_List,IsBlank(
                                             'Checkout Datetime'
                                     )
         )
)

[BCLS776]

Yes, let's make that delegable too.

Please replace that code with:

LookUp(Visitors_Master_List, 'Checkout Datetime' = Blank(), true)

That will make the control Visible if there are any blank entries in the Checkout Datetime column

Bryan

[johnm_]

Great thanks! 

[johnm_ · Accepted solution]

@BCLS776 

Also, can you help how to show this (see below) when there are no checked in visitors?

Right now

visible

LookUp(Visitors_Master_List, 'Checkout Datetime' = Blank(), false)

Thank you! 

[johnm_]

@BCLS776 right now when i change value to true it overlaps the rest. I only need to show this when there is NO blank for 'Checkout Datetime'

[BCLS776 · Accepted solution]

Try this for the Visible property of your "no visitors" message:

IsBlank(LookUp(Visitors_Master_List, 'Checkout Datetime' = Blank()))

This code will return true if it finds any item with a blank Checkout Datetime, and will return false if no items have a blank Checkout Datetime.

Make sense?

[johnm_]

Thank you so much!!!