cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
duncant
Level: Powered On

Gallery Setup (Group by select data)

My application is a survey of several stores.  Some of the surveyors may take a survey for the same stores as another surveyor.

 

I would like my Gallery to first group by the store, when a user a selected the store, the next screen will open another gallery, this time it will list all of the surveys completed for the select store.    

7 REPLIES 7
Super User
Super User

Re: Gallery Setup (Group by select data)

@duncant 

Here's a short mini-tutorial for you.  All of this takes place on a single screen.

 

#1  Put this code in your App's OnStart property.

Set(showGalleryStores,false);
Set(showGallerySurveys,false);

 

#2  Create a gallery named gal_stores.  Use this code in the following properties:

Items: Distinct(your_datasource_name,'Store Name')
Visible: showGalleryStores
OnSelect: Set(showGallerySurveys,true);Set(showGalleryStores,false);

 

#3.  Create another gallery named gal_surveys.  Use this code in the following properties

Items: Filter(your_datasource_name,'Store Name': gal_stores.Selected.'Store Name')
Visible: showGallerySurveys

 

#4  Finally you will want to create a back button so the user can return to the Stores Gallery.  Put this code the in a back icon or button.

OnSelect: Set(showGalleryStores,false);Set(showGallerySurveys,true);
Visible: showGallerySurveys

 

Let me know what questions you have.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

duncant
Level: Powered On

Re: Gallery Setup (Group by select data)

In the first option, do you mean OnSelect?

Super User
Super User

Re: Gallery Setup (Group by select data)

@duncant 

No for #1 I mean this...

 

imgX.png

duncant
Level: Powered On

Re: Gallery Setup (Group by select data)

For some reason the colon is being seen as an error. 

Super User
Super User

Re: Gallery Setup (Group by select data)

@duncant 

What step is error happening in?  Screenshot please.

 

Syntax can be different depending on the web browser's language.  I am using United States English?  What is your language setting.

duncant
Level: Powered On

Re: Gallery Setup (Group by select data)

@mdevaney 

 

Step 3

cruise filter.PNG

 

Super User
Super User

Re: Gallery Setup (Group by select data)

@duncant 

You'll want to do this...

Filter(Passengers,'Cruise ID': gal_stores.Selected.'Cruise ID')

 

If my suggestion does not work please send a screenshot of the complete error message.

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,156)