Hi Experts,
I have a gallery that relies on another gallery. Both galleries pull out the data from the SharePoint list.
Gallery 1 is called AppName and Gallery 2 is called ServerName
Depending on the AppName selection, it pulls out the ServerName from the SharePoint list and shows with the checkbox in another gallery.
There are two issues here I am currently experiencing.
One is when I tick the AppName checkbox, it is not showing all server names. It is only showing the current selection of the ServerName for the App. This is fine as there will be too many if the user select all apps.
The second problem is that when I tick the checkbox from ServerName gallery and choose another AppName and tick the checkbox from ServerName for another App, it refreshes the list that's been selected from others. I want to keep this information so I can pass it to the Power Automate flow. Also, user can see the checkbox ticked what has been selected when they came back to the app again.
I followed the Reza's youtube video from here: https://www.youtube.com/watch?v=Vj8uP2zaMtA
and used the code for the AppName as below (tried onChange, onCheck and onSelect but none of them were working)
Set(varAppData, ShowColumns(Filter(GalleryAppName.AllItems,CKBoxApp.Checked),"Value"))
and used below code for the ServerName (tried onChange, onCheck and onSelect but none of them were working)
Set(varServerData, ShowColumns(Filter(GalleryServerName.AllItems,CKBoxServer.Checked),"Value"))
Can someone please advise what I did wrong here?
Thanks