cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

How to retain selection in Gallery + Form on DB refresh

I am using CDS & have a screen with a Gallery & Form. The selected gallery item populates the form & the form can be edited.

My problem is however, that the gallery selection gets lost when I execute Refresh(Database).

Is there a way either to retain the gallery selection when a form is submitted, or to re-select the previous item after a form has been edited (and the database refreshed)?

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper II
Helper II

Hi @Medoomi,

 

What you can do for the OnSelect() of your Refresh Button is something like this:

Set(varSelectedItemID, Gallery1.Selected.Id);
Refresh(Database)

 

Now on the Default() of you Gallery you can do something like this:

LookUp(Database, Id = varSelectedItemID)

 

Hope this helps.

View solution in original post

4 REPLIES 4
Highlighted
Super User III
Super User III

Try these steps:
1. OnVisible of the screen put: 

UpdateContext({GallerySelected:!GallerySelected})
 
2. Insert another Gallery say Gallery4 and on its items put:
Form1.LastSubmit ....(Form1 to your actual form name)
 
3.Finally on the Item of the Form1 put:

If(GallerySelected,Gallery4.Selected,If(!GallerySelected,Gallery2.Selected))

Change Gallery2 to your existing Gallery connected to the form

 

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

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.

Highlighted
Helper II
Helper II

Hi @Medoomi,

 

What you can do for the OnSelect() of your Refresh Button is something like this:

Set(varSelectedItemID, Gallery1.Selected.Id);
Refresh(Database)

 

Now on the Default() of you Gallery you can do something like this:

LookUp(Database, Id = varSelectedItemID)

 

Hope this helps.

View solution in original post

Highlighted

@eka24 

Thanks so much for your answer. I'm trying to understand the process. Am I correct thinking that Gallery4 would become a kind of "holding place" for the previously submitted form... So in practice, once the form was submitted, while Gallery2 might become de-selected, the form selection would remain?

Highlighted

The idea is to be able to choose from either Gallery2  which holds the existing record and Gallery 4 which holds the latest submitted item. 

You have a choice of selection between the two at any point in time.

 

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

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.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,825)