Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Gallery .selected and Set(var, ThisItem) not working?



I've been doing the Gallery.selected and set(var,ThisItem) for most of my implementations but for this one project that I have, it doesn't seem to work. My objective is to be able to edit the selected item in the edit screen. I passed the Gallery.Selected data to a variable (see below my steps)


  1. Main Menu Screen

    001 - Main Menu.png


  2. Details Screen

    Note here that I created a Gallery to list down the Selected item and it is displaying correctly (I only displayed the ID and name just to test it ou)
    002 - Details Screen.png


  3. Edit Screen

    Note here as well that the Edit SYS-1002 Test with Integrations is working but doesn't seem to get the form data
    003 - Edit Screen.png

    Even if the label was able to get the data, the Form doesn't. Also, my Form is in Edit mode. Not sure if it should be in New mode, but otherwise, let me know.


Hope someone can chime in on this concern. Thanks!


Accepted Solutions
Not applicable

@hexarthrius watching that video I think I can see the error. Your form gets the data then gets reset (see pics)


Gets data (approx 8sec mark):


 Then gets reset (approx 9sec onwards)



My guess is that the OnVisible of the screen is resetting the Form to New mode ... or some other function is doing that. You could also have a check on the Default property of the form to see if that is causing the issue.


View solution in original post

Super User
Super User

Hello @hexarthrius ,

I have had some interesting issues in the past trying to use a variable as the source of a data set which I then want to interact directly with the data source or refer to it as you are for another set.

This does probably not answer your question, but as the source of all my selection galleries are all collections, I always use

Lookup(DataSource, ID = Gallery.Selected.ID)

for the Item of the form as you are then placing the actual record on the form for reference. I am sure others may have something to contribute as well.


I will tag a few of my knowledgeable colleagues @mdevaney , @Anonymous and @PowerAddict 

Hi @WarrenBelz,


I appreciate the response and will await other people's feedback on this as well. It's just that I wonder what is different on what I do here now against the other apps I made with the same logic. Also, based on your code snippet, I assume that's not yet the full code to get the record since it's just ID, right? It's like you're making a collection and looking up the ID to reference the collection?



Yes @hexarthrius ,

I do all my filtering, sorting and "distincting" for my initial gallery and also all DropDown/ComboBox content in a bunch of Collections at App OnStart. I am fortunate that we do not require any working sets over 2000 items (larger sets are filtered with delegable queries), so all delegation issues instantly disappear, meaning Date, Not, In and other problem queries simply work. As well, the dropdown response and gallery search speed is very good.

The gallery set collected is from the reference list, using ShowColumns to grab only the fields I need to display and together with Concurrent collection loads very fast, even on mobile devices and as you have queried, always includes the ID of the list item. Then for the form I only have to grab one record matching the ID of what is selected in the gallery.


Not applicable

@WarrenBelz thanks for the tag, I will try to help.



Two things that I can offer as solutions:

1. Is the 1st gallery's Items a collection or directly from your data source? If a collection, there maybe some type / data mis-matching going on.


2. And this is what I think is likely happening, your 'Edit' button should explicitly set the form to EditMode even though the default is Edit. At some point it may have been set to NewMode and may still be in that mode? You can check this using a simple label boolean check eg Form1.Mode = FormMode.New in a label

To explicitly set your Edit button, use EditForm(yourFormName); Navigate(...)


A least likely solution could be that you have removed and added new Form controls (eg added in combo boxes where there were previously textinput fields) and these haven't been setup correctly?


Anyway, try these things and let me know how you get on.

Community Support
Community Support

Hi @hexarthrius ,

Could you tell me

1)the gallery's Items in Main Menu Screen?

2)the form's data source in Edit Screen?

You need to make sure that these two properties are the same table.

You need to set the edit form's Item: gblGalSystemsSelected

Also, set the edit button's OnSelect in Details Screen:

EditForm(formname in edit screen);Navigate('System Edit Screen')

//make sure the form's mode is edit

If the problem still exists, try to set  the edit form's Item:

Lookup(DataSource, ID = gblGalSystemsSelected.ID)
//filter the item that has the var's same ID

 Or you could consider not using variable.

You could use "Galleryname.Selected" to represent the selected item in the gallery directly.

Just need to set the the edit form's Item:

//please replace with the gallery name in Main Menu Screen



Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

Hi @hexarthrius 

What data source are you using? If you're using SQL Server or the CDS, and if you've enabled explicit column selection, this can result in this type of behaviour.



Hi All, 


I have tried suggestions from @Anonymous and @v-yutliu-msft, but it seems that it's doing the same thing even when I set these recommendations on setting it as variable and not setting it as a variable.


Here's a video of how it looks like when going to the edit form:


I also tried the lookup function and while it did get the data when I was editing the formula, simulating it has the same results as the one above. I'm not sure what I'm doing wrong at this point, since I've been doing this setup for my previous apps. 


@timl, my data source is SharePoint. 

Hi @hexarthrius ,

Have you set the "edit" button's OnSelect in Details Screen  like this:

EditForm(formname in edit screen);Navigate('System Edit Screen')

Please replace with your edit form's name.

This will make the form's mode to be Edit.

Also, could you tell me how many records in your sharepoint list?

Do you have delegation warning, which will lead to some problems too?

If your problem still exists, could you show me all your settings about the edit form?



Best regards,


Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not applicable

@hexarthrius watching that video I think I can see the error. Your form gets the data then gets reset (see pics)


Gets data (approx 8sec mark):


 Then gets reset (approx 9sec onwards)



My guess is that the OnVisible of the screen is resetting the Form to New mode ... or some other function is doing that. You could also have a check on the Default property of the form to see if that is causing the issue.


Helpful resources


Power Platform Connections - Episode 7 | March 30, 2023

Episode Seven of Power Platform Connections sees David Warner and Hugo Bernier talk to Dian Taylor, alongside the latest news, product reviews, and community blogs.     Use the hashtag #PowerPlatformConnects on social media for a chance to have your work featured on the show.     

Announcing | Super Users - 2023 Season 1

Super Users – 2023 Season 1    We are excited to kick off the Power Users Super User Program for 2023 - Season 1.  The Power Platform Super Users have done an amazing job in keeping the Power Platform communities helpful, accurate and responsive. We would like to send these amazing folks a big THANK YOU for their efforts.      Super User Season 1 | Contributions July 1, 2022 – December 31, 2022  Super User Season 2 | Contributions January 1, 2023 – June 30, 2023    Curious what a Super User is? Super Users are especially active community members who are eager to help others with their community questions. There are 2 Super User seasons in a year, and we monitor the community for new potential Super Users at the end of each season. Super Users are recognized in the community with both a rank name and icon next to their username, and a seasonal badge on their profile.    Power Apps  Power Automate  Power Virtual Agents  Power Pages  Pstork1*  Pstork1*  Pstork1*  OliverRodrigues  BCBuizer  Expiscornovus*  Expiscornovus*  ragavanrajan  AhmedSalih  grantjenkins  renatoromao    Mira_Ghaly*  Mira_Ghaly*      Sundeep_Malik*  Sundeep_Malik*      SudeepGhatakNZ*  SudeepGhatakNZ*      StretchFredrik*  StretchFredrik*      365-Assist*  365-Assist*      cha_cha  ekarim2020      timl  Hardesh15      iAm_ManCat  annajhaveri      SebS  Rhiassuring      LaurensM  abm      TheRobRush  Ankesh_49      WiZey  lbendlin      Nogueira1306  Kaif_Siddique      victorcp  RobElliott      dpoggemann  srduval      SBax  CFernandes      Roverandom  schwibach      Akser  CraigStewart      PowerRanger  MichaelAnnis      subsguts  David_MA      EricRegnier  edgonzales      zmansuri  GeorgiosG      ChrisPiasecki  ryule      AmDev  fchopo      phipps0218  tom_riha      theapurva  takolota     Akash17  momlo     BCLS776  Shuvam-rpa     rampprakash  ScottShearer     Rusk  ChristianAbata     cchannon  Koen5     a33ik   Heartholme     AaronKnox        Matren        Alex_10        Jeff_Thorpe        poweractivate        Ramole        DianaBirkelbach        DavidZoon        AJ_Z        PriyankaGeethik        BrianS        StalinPonnusamy        HamidBee        CNT        Anonymous_Hippo        Anchov        KeithAtherton        alaabitar        Tolu_Victor        KRider        sperry1625        IPC_ahaas      zuurg    rubin_boer   cwebb365   Dorrinda   G1124   Gabibalaban   Manan-Malhotra   jcfDaniel   WarrenBelz   Waegemma      If an * is at the end of a user's name this means they are a Multi Super User, in more than one community. Please note this is not the final list, as we are pending a few acceptances.  Once they are received the list will be updated. 

Microsoft Power Platform Conference | Registration Open | Oct. 3-5 2023

We are so excited to see you for the Microsoft Power Platform Conference in Las Vegas October 3-5 2023! But first, let's take a look back at some fun moments and the best community in tech from MPPC 2022 in Orlando, Florida.   Featuring guest speakers such as Charles Lamanna, Heather Cook, Julie Strauss, Nirav Shah, Ryan Cunningham, Sangya Singh, Stephen Siciliano, Hugo Bernier and many more.   Register today:   

Check out the new Power Platform Communities Front Door Experience!

We are excited to share the ‘Power Platform Communities Front Door’ experience with you!   Front Door brings together content from all the Power Platform communities into a single place for our community members, customers and low-code, no-code enthusiasts to learn, share and engage with peers, advocates, community program managers and our product team members. There are a host of features and new capabilities now available on Power Platform Communities Front Door to make content more discoverable for all power product community users which includes ForumsUser GroupsEventsCommunity highlightsCommunity by numbersLinks to all communities Users can see top discussions from across all the Power Platform communities and easily navigate to the latest or trending posts for further interaction. Additionally, they can filter to individual products as well.       Users can filter and browse the user group events from all power platform products with feature parity to existing community user group experience and added filtering capabilities.     Users can now explore user groups on the Power Platform Front Door landing page with capability to view all products in Power Platform.    Explore Power Platform Communities Front Door today. Visit Power Platform Community Front door to easily navigate to the different product communities, view a roll up of user groups, events and forums.

Welcome to the Power Apps Community

Welcome! Congratulations on joining the Microsoft Power Apps community! You are now a part of a vibrant group of peers and industry experts who are here to network, share knowledge, and even have a little fun! Now that you are a member, you can enjoy the following resources:   The Microsoft Power Apps Community Forums If you are looking for support with any part of Microsoft Power Apps, our forums are the place to go. They are titled "Get Help with Microsoft Power Apps " and there you will find thousands of technical professionals with years of experience who are ready and eager to answer your questions. You now have the ability to post, reply and give "kudos" on the Power Apps community forums! Make sure you conduct a quick search before creating a new post because your question may have already been asked and answered!   Microsoft Power Apps IdeasDo you have an idea to improve the Microsoft Power Apps experience, or a feature request for future product updates? Then the "Power Apps Ideas" section is where you can contribute your suggestions and vote for ideas posted by other community members. We constantly look to the most voted Ideas when planning updates, so your suggestions and votes will always make a difference.   Community Blog & NewsOver the years, more than 600 Power Apps Community Blog Articles have been written and published by our thriving community. Our community members have learned some excellent tips and have keen insights on building Power Apps. On the Power Apps Community Blog, read the latest Power Apps related posts from our community blog authors around the world. Let us know if you would like to become an author and contribute your own writing — everything Power Apps related is welcome!   Power Apps Samples, Learning and Videos GalleriesOur galleries have a little bit of everything to do with Power Apps. Our galleries are great for finding inspiration for your next app or component. You can view, comment and kudo the apps and component gallery to see what others have created! Or share Power Apps that you have created with other Power Apps enthusiasts. Along with all of that awesome content, there is the Power Apps Community Video & MBAS gallery where you can watch tutorials and demos by Microsoft staff, partners, and community gurus in our community video gallery.   Again, we are excited to welcome you to the Microsoft Power Apps community family! Whether you are brand new to the world of process automation or you are a seasoned Power Apps veteran. Our goal is to shape the community to be your ‘go to’ for support, networking, education, inspiration and encouragement as we enjoy this adventure together!   Let us know in the Community Feedback if you have any questions or comments about your community experience.To learn more about the community and your account be sure to visit our Community Support Area boards to learn more! We look forward to seeing you in the Power Apps Community!The Power Apps Team

Top Solution Authors
Top Kudoed Authors
Users online (4,864)