Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[John Heck]

Hello,
I have a gallery that shows a list of orders, all tables are in Azure SQL.  When an order is completed it sets the global varOrderID and navigates to a Contract screen.  The OrderID is part of the Contract screen.  When the screen opens and the Contracts gallery is displayed is it possible to have the system select the gallery item that matches the OrderID to highlight the Contract that was just added? 

Thanks in advance for the help.

——————————
Kind regards,
John Heck
——————————

[Warren Belz]

Hi ,
Assuming you have OrderID (or whatever you called it) ?as a field in your SQL table, set the Default of your Gallery to

LookUp(
   YourSQLTable,
   OrderID=varOrderID
)

and it will select the matching item in the gallery.

——————————
Warren Belz
Queensland Australia
——————————
——————————————-

[John Heck]

Hello @Warren Belz,
I did put the LookUp(…) that you suggested above in the Default section of the Gallery (I had done this earlier and it wasnt working so I thought I was missing something).  The correct OrderID is in the variable varOrderID.  I was going to tell you that it was not selecting the correct row when the table is displayed.  I found a variable that someone had put on the screen so I wrapped the LookUp(…) in an If st?atement.

It works like a champ.  Thanks for the help Warren.

——————————
John Heck
——————————
——————————————-