On Power Apps load Gallery not showing data

[AshwiniBhandari]

Hello,

I have two galleries on a Screen.

Gallery1 :

Displays SharePoint title values: All, In Progress, Completed.

Gallery2 :

Connected to SharePoint List to show list items filtered based on a value selected from Gallery1.

Issue Statement: On App load I want to display All items and by default select the value All in Gallery1. How can I achieve this? Any help would be appreciated.  

[eka24]

Can you show the code for the collection or items property of Gallery 1.

Also give details on the code on the items property of Gallery 2

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[PatilChetan]

@AshwiniBhandari 

Try below code to select default value as All in Gallery1

For more details refer: https://powerusers.microsoft.com/t5/Building-Power-Apps/Gallery-Default-Selected-Item/td-p/490256#:~... 

Regards,

Chetan

[AshwiniBhandari]

@eka24 

• Gallery1 items property: StatusType (SharePoint List with Title values: All, In Progress, Completed)
• Gallery1 Label Text property: ThisItem.Title
• Gallery1 Label OnSelect property:

If(
ThisItem.Title = "All",
UpdateContext({type: "All"}),
If(
ThisItem.Title = "In Progress",
UpdateContext({type: "In Progress"}),
If(
ThisItem.Title = "Completed",
UpdateContext({type: "Completed"}),
)
)
)

• Gallery2 items property:

If(
type = "All",
'SharePoint List',
If(
type = "In Progress",
Filter(
'SharePoint List',
Status.Value = "In Progress"
),
If(
type = "Completed",
Filter(
'SharePoint List',
Status.Value = "Completed"
)
)
)
)

[InfoUCS]

Try this and let me know if it works:

Gallery2 set the Default property to "All"

Gallery2 set the Items property:

If(Gallery1.Selected.<title name of the column> = "All", SharePoint List, Filter(SharePoint List, <column title name> = Gallery1.Selected.<title name of the column>))

[AshwiniBhandari]

Thanks for the solution Chetan. But my use case is different and in terms of two different galleries on the same screen. Where Gallery2 items are filtered based on a value selected in Gallery1. And it works fine when I select a value in Gallery1 after the app loads. But by default Gallery2 loads as blank on App start.

[eka24]

In the Default of Gallery1:

LookUp(StatusType, Status.Value ="All")

Then in the Items property of the Gallery2:

Filter (SharePointList, Type = Gallery1.Selected.Title)

That is replace the If formula on the Gallery2.

Also remove the formula in the OnSelect of the Label in Gallery 1 as you stated above. You put ThisItem.Title or ThisItem.Title.Value depending on whether the column type is a choice column.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[eka24 · Accepted solution]

In addition to my reply, this tutorial uses same approach but uses a collection for Gallery1. By April Dunnam https://youtu.be/o1muoWFxIO4

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[AshwiniBhandari · Accepted solution]

Thank you @eka24 .

I have followed the approach of using direct values instead of SP list for Gallery1 and it works fine for me with the tweaks on item property of both the galleries. The below solution worked for me.

Gallery1 - items property : ["All","In Progress","Completed"]

Gallery1 - Label property : ThisItem.Value

Gallery2 - items property:

If(
Gallery1.Selected.Value = "All",
'SharePoint List',
Filter(
'SharePoint List',
Status.Value = Gallery1.Selected.Value
)
)