Power Apps Reset a Gallery and varRecord instead of Selected 

^Thinks about everywhere he uses gallery.Selected... Starts to cry...

Time, and time, and time AGAIN, I have found Shane describes things in common-sense ways that really "get the job done"! This video was a "life saver" for me this weekend!

Started using varRecord a bit over a year ago because of you, absolutely love it. Thanks for spreading the knowledge out there Sensei

Realized my morning before work has become learning something new from you Shane!

I've been setting a variable on select for some time, but I never even thought of using it like that. Way awesome idea!

Thanks Shane, varRecord fixed an issue I had that meant the edit form wasn't populating. Brilliant, as usual. Thanks mate.

One other way this helped is I have 2 galleries on one screen (respectively filtered by 1 of 2 status types) and they alternate their visibility based on a toggle switch, THEN the selected gallery item shows on a connected form on that same screen. With this solution, the form shows varRecord from whichever form with no issues! Thanks again Shane... VERY, VERY HELPFUL!!!

If you have been struggling with this like me, the above video saved my current app and all future ones. There was an issue I was getting. I had a different screen for viewing the results. All you need to do is add Navigate after the set varRecord, this will then pass the results to the view screen: Set(varRecord, ThisItem); Navigate(View) [View is the name of my view screen]

Hello Shane, again thank you for another great lesson on working with Gallery. You are right on the point to solve my question on how to reset the TemplateFill for selected item. A very smart solution.

This was great! Yeah, I had gallery.Selected EVERYWHERE which kinda' made me nervous that something would break somewhere. Thanks so much Shane!

Exactly what I needed - thank you SO much Shane - you are amazing!

Love your work Shane!

That’s genius and opens up many other ideas. Thanks, Shane.

These tips were awesome and exactly what I need for my next project!!

Thanks a lot, i am always watching those Videos and immediately trying it on my existing apps .

Great tips and tricks indeed!! Many thanks Shane!!!

Gidday Shane. I've been watching your video for about a year now - love your work but I missed this tip somehow. Lookkng forward to tidying up my OnSucces email variables! Cheers mate.

I was trying to do this yesterday. Thanks Shane.

Wonderful video, thank you Shane. I loved it.

Another top tip, thanks Shane !

You can just set the default of the gallery to {} which is a blank record then when it resets then nothing is selected. 🙂

Just what i was looking for!!! Thanks so much!!!

Thanks Shane...another great video!

Cool tutorial and tips. Many thanks for sharing them!

Thank you so much Shane!

Thank You Shane , you are the max..! I can build a Gallery Menu using the same technique! Thank you again!

Thank you, Shane!

I wish you would do a video showing a fully featured app that you build. Even if it has to be several different parts due to the length. I would love to see a really in depth building of an app. Sometimes it’s hard to grasp some of these concepts when they are done in pieces. For my own selfish reasons I would like to see you build an app to OCR documents but I’ll take what I can get.

i had watched this a few weeks ago and ended up storing only the email instead of the record, because the display its pointing at is from a different table - but i DID run across a problem where you could add a record to the child table for the first person in the first gallery even tho they hadnt been selected - this caused problems with calculations after the update. The only thing I had to fix was to hide the 2nd gallery if nothing was stored in my variable - and also the 'add' button, and change the title. but thank you!

This was very helpful. Thanks Shane

Smooth, very smooth. Thank you.

Thanks a lot. That varRecord is gold.

Great videos! Thanks for sharing!!!❤

Easy Pizy.. Japanizi.. Thank You Shane for Sharing.

Dam I wish was aware of this a year ago, Thanks Shane.

So handy! Thanks 😊

Great way of thinking every day is a school day!

Hi Shane awesome video...

Excelent Tip, thank you so much

Hi Shane! I did a universal replace of gal selected with var record. Worked great-thank you! The problem now is that when I patch something and my items go back into view mode, they are not reflecting the change anymore. Before, after a moment, my record items (I don’t use a form, but a free-form canvas linked to a gallery) would reflect the updated data after my patch. They don’t do that anymore, and I have to return to my gallery, reselect the item and then the record will show the updated information. I have my attachments in a form and it is not updating to show my saved attachment changes patch either. I’ve been at a loss for a few days on how to get that back.

Hi Shane, The video was very helpful. How do i set the app to select the first record in the Galley by default when the screen opens? Thanks

Thank you Shane san 😍😍

Hi, Shane Great videos as always. One question when you select a record in your gallery your selection does not move .... I have set up my gallery with the same setting, but when I select a record it moves the records up in the gallery window. For example, when you select yourself in the gallery, you can still see Nicola and Greg's records. When I select a record it will move the gallery up so that would have to scroll up to see Nicola and Greg's records. Other than that very works just you have in your video.

great video

Shane, you rock! Can you do one on simulating a Pivot Table? Struggling with grouping by certain choice columns to summarize info from a Sharepoint list. Maybe I just needed to embed a powerBI. Trying to summarize by 3 “levels”.

Exxxxcelente!!!! The best!!! By Brazil

Thank you so muchhhh..

Shane, you rock! Can you do one on simulating a Pivot Table? Struggling with grouping by certain choice columns to summarize info from a Sharepoint list. Maybe I just needed to embed a powerBI. Trying to summarize by 3 “levels”. Thanks!

Hey Shane, great video! I have one wrinkle that you didn’t cover and I’m hoping you can help. I set my form visible properties to !isblank(varRecord) and my label visible to isblank(varRecord). When I click on my button that is set to create a new blank form to enter a new record, the new form isn’t visible. What am I missing to get the new form to be visible? Thank you!

Nice trick. Think I need to make som changes here and there in my solutions ;-)

Hi Shane, this video is a life saver... I started to have several issues with the Selected techinque. Right now I am having an issue trying to use it with attachments though... it seems you cant access to the attachment using varRecord as you would in Gallery.Selected. Do you have any solution in that direction. Thanks for your awesome videos!

Hello Shane, you have a video on how to apply currency format, for example I need to use C$ with comma for thousands and point for decimals, thanks I have learned a lot in your channel.

Fab! understand variables better... how can you use Search Text field using variables to search for items in the Gallery by two criteria? For example, I have a list of the projects with PM name and Region in a Gallery and I want a search field to select just these projects that are in US. Or search for projects that are assigned to Sam Smith as a PM

Love the video and will definitely implement the varRecord idea. What are some of the pitfalls of using .IsSelected or .Selected? I'm just curious. Thanks for all you do!

Shane, as always great info. Just started to use this way and I noticed some of the Templatefills are glitchy, might be due to large amount of data in the record, still working through this. One question though, if navigating from another Screen and I want it to select a record on load should I set the Record in the Onselect from the screen I am navigating from? - I may have answered my question while typing Thx anyway.

Hi Shane! As always thank you for your awesome videos. What if on your home page you had a button that said meet our Nap Taker - Is there a way to onselect navigate to your gallery an automatically select Chewy?

Hi Shane, i am struggling with the simplest of tasks. I have a data source that is a stock list and over a period of time the value of the stock reduces. Then i would like to reset all the stocks to a start number (eg 100). I have a gallery of the data source with the item and the stock, i can change these stocks manually. How then do i patch ALL the new stock values back to the data source. I have tried ForAlll and i am failing miserably? Thanks

Hi Shane... Great video. I am facing an issue with in PowerApps gallery about refresh after deletion of record. I am using an API as a custom connector and built a gallery with the data from it, deleted record is displaying on gallery until we refresh it manually. Share me if you have any solution for it... Thank you

Hi Shane! Need your help! I'm using a variable to select the item from a gallery which routes a user to another screen displaying the form. When the user submits the form, it will update the record and retain the selected item. I'm using lookup on the items property of the form to capture the variable ID. However, if they click to edit the form again and resubmit, the item becomes deselected. Any ideas on why this might be happening? I've combed forums for nearly a week now looking for a solution with no luck.

Hi Shane, I have Checkbox control in the Gallery control and would like to display all "uncheck" items when selecting a "Reset" button control. My Sharepoint list is Choices column with multiple selections. Any advise?

What in the world would I do without you?

Hey Shane, I've followed your video's for a couple of years now and they've helped so much. I wanted to ask with the new price plans coming up a lot of large premium user apps are going to be completely unaffordable. We have one that would soon cost $250k per year which isn't sustainable. Do you have any thoughts on Microsofts cash grab and what impact you think it will have on the PA community?

Hi I am using variable but data is not coming ,in gallery created on variable and calling in next screen display form in item property varriable no error but still no data

Hi Shane, again a great session ! What I'm struggling with is to force select the first item in a gallery after a filter condition has updated the items.

Thanks Shane this is great! Any idea how you would make the gallery item disappear after successful form submission?

Love your videos, informative and very easy to follow. Have a gallery based on a dataverse table that has lookups. I set the on select value of the gallery to Set(varRecordSelected,ThisItem) and get error msg "This formula has side effects and cannot be evaluated". Broken in Step 1 :-( I was using gallery.selected and it worked. Why does the variable not work for ThisItem?

Thanks so much! I have two galleries from the same list. The 1st gallery is in the main screen, I needed to group the gallery by division (department) but since department is a choice I needed to set the group and I used this on the ITEMs in the gallery to get it working GroupBy(AddColumns('Department of Pediatrics Team List', "DivisionGroup", Division.Value), "DivisionGroup", "DG". On my second screen, the gallery shows the name of team members when Items is Gallery1.Selected.DG. Also, on my second screen I have the form control to toggle between view, edit and new form mode buttons. The problem is that when I go back to screen 1 and select a different division/department, the form view shows the information of the previously selected record in another division/department but it changes as soon as I click in a new name from another division/department. How can I have the form reset or not show up for view but only after i select the name? I tried doing what you showed with !isblank()...but i can't seem to hide the view mode. Also, my save button in edit mode onsuccess shows lastsubmit record on viewmode but my gallery goes back to the first record in the first department and for some reason they are not linking to be the same. Any help?

I just stumbled on this! I have a Records list screen (which has the gallery), a Record Detail screen to display the selected record on a View form and also it's child items, and a Record Entry screen for adding new record, or editing the selected record. When I selected a record for edit, after successful submit, I want to navigate to the Record Detail screen and have it show the updated record. But because it's Item property is Gallery.Selected, it always shows the first item, as the submit causes the gallery to refresh. So I tried to use Set(varRecord, ThisItem) in the OnSelect property of the gallery, then have the View Form's Item property set to varRecord. However, after submiting the changes, the View form remains showing the selected record, but values are before the submit. So, in the OnSuccess event of the edit form, I do a Set(varRecord, frmEdit.LastSubmit). This seems to finally achieved what I want. But I'm not sure if this is the best way of doing it. 😄 Ideally I wish there is a way to set the selected item of the gallery to the the one that was selected before, after the gallery is refreshed.

What if we're not using Forms, but rather using Patch with fields on a canvas? How to load that Screen with those fields blank until a gallery item is selected?

Hi Shane, as always, great video. Is there any difference between setting varRecord the way you have done it in the video and setting it like this: Set(varRecord, Gallery1.Selected), i.e. for navigating to a form on a different screen?

Hi Shane.. I tried this approach.. where One screen I have a gallery..when I click on edit button present as gallery Item.. I follow your steps as mentioned in this video...then I navigate to another screen.. which opens the form.. now letter when I come back.. using side navigation bar to navigate to gallery screen.. On Screen Visible I Reset Gallery & Set Record to Blank.. But somehow this is breaking.. can you please share insights on why this behaviour might not be working? I also tried adding a button which does the same as Reset Gallery & Set Record to Blank.. and On Screen Visible.. I select the button.. yet this is also not working..

Shane, the OnSelect() in the Gallery gets triggered only when the user clicks on it. But there are senarios where we select a item in the gallery dynamically (using the defaults property). In such cases using the varSelected approach will not work.

In gallery label , can we take variable which hv some calculated values?...I hv tried but it's giving err n I m not able to do..pls suggest

Hi Shane. Awesome video. One quick question: Why "Gallery.Selected" does not work for an edit form if both the data sources are pointed to a same collection? Can you please prepare a video on this?

Hi Shane, Thank you very much for all the tips! I have a question for you , i have a gallery based on a data source and inside that gallery i added a dropdown on each item based on a different data provider and i want to use the reset function but i get and error "Name isn't valid. '{0}' isn't recognized." so i'm lost ahah

I love qtt

Hi Shane! Does reset also in the background refresh the datasource?

Hello Shane, I am updating a SP List with updateif command with OnChange of a text input control, the issue I have is that the gallery (connected this SP in question) of the selected item resets and displays the 1st item in the gallery. All I want is to keep selected the item I originally 'selected'. Do you have a suggestion to achieve this?

Thank you so much for sharing Shane! I have a question... Im working with collections to be displayed in a gallery to collect different milestones. but once the user has finished working on it and click on submit i want the gallery to reset to blank so that other user can work on it. is that possible ? Im still learning :), thank you again!

Shane I need your help. I made a barcode scanner app.. I have 2 text inputs in this app, To change focus from TextInput 1 to TextInput2 I am using SetFocus function, But after a scan I always have to press return/Done on the RF Gun to set focus on next TextInput field. How can I do it without pressing a button, When the TextInput1 gets any data then it should set focus to TextInput2. This will really increase the speed of scanning.

Hi Shane, That was very helpful. The one thing I haven't been able to figure out is that I'm using a radio button choice list with my gallery and form. The gallery is an FAQ List and the form displays the answer. When a user selects the question and then chooses another category, it continues to display the answer for the previous question rather than the text label. How can I get the gallery to also initially just show the text label message when the user selects a radio button? I imagine I have to change the OnSelect property with the radio button.

Hey Shane, very helpful videos! I have a question here. I'm trying to make a button visible to managers only (and we have 100+ managers in the company( ° △ °|||). I know from your previous video that I can make a button visible to a specific person by setting up "visible = If(User().email = "this person's email address", true, false)". Is there anyway that allows me to make a button visible to a group of people without having to add their email addresses one by one? Thank you!

👍

When ever we create a new record that new record should only visible remaining records should not visible in gallery grid how to do it

Does the varRecord approach also work if a SharePoint List item has an attachment?

What are you setting varRecord to, if anything, when you are creating a new record?

Hi Shane. How do you deal with Form Submission? After submitting the form, how do you "refresh" the varRecord to have the new changes submitted? (Working with Sharepoint as a database)

Shane, how can you set the first item in the gallery to varRecord when you select the reset button? That way Nicola's record would be displayed on the right?

I need to set my gallery default item. lookup(datasource, status.value = "approved") does not work how do i fix this?

Hi sir , How can I hide empty data rows in "Gallary control "?

Hey Shane. Wonderful video. I am trying something and its not going well. I want to send an MS form via email on power Apps and get responses on Sharepoint. (Super Easy). However, I want to show the progress of whether a flagged form has being filled by having a gallery showing the status of either filled or not. I know automate can help here but a little bit stuck.A video would be awesome. Thanks in advance.

Shane, do you know of a way to go back to the first item in a gallery by selecting an icon (like a to top in a website?)

Man... I had my jaw dropped with so many things to explore and you say.. easy peasy lemon squeezy.. Thanks for this super awesme tricks I have a snall request though. I hav a flow which reads excel and updates the sharepoint list. The challenge is to show alias instead of email id ot lastname, first name for a person column. It says..."required info" even though the content is present. Did I confuse you?

Hi, what formula will be for save, back and new item please? Thank you

6:14 🤣👌🚀

Hi shane, i've got the challenge. 2 different lists, List A with column Vnr en List B with column WBS, both containing a accountnumber. I want to use list A : projectname and from list B: the finance informatie for that project in a form, by compare Vnr=WBS.Maybe its simpel, but I dont get it done. Hope you can help me. Regards, Arthur from The Netherlands.

Shane, really enjoy your videos. One issue that I am seeing is that varRecord does not consistently change when I select another record in the gallery.

Isn't easier is to set default to {} It sets default to empty and no need to call another variable...

I switched my design to varRecord .. now i cant upload my attachments any longer 😅 .. the upload is broken

Nice Hack!