Hi All,
I have a table (tblTools) that contains a Line which is a choice column in dataverse. In my canvas app I have a gallery and edit with a different table (tblAssemblies) set as the data source.
In the edit form I have added a dropdown and set the Items property to Gallery1.Selected, However when I need to create a new entry and use my button with OnSelect set as NewForm(Form1) I need to be able use the values from my choice column in the tblTools.
I have achieved this by setting the drop down Items property to Distinct(tblTools,Line) however I have lost the connection with Gallery1.Selected
How can I combine the two functions?
Thanks
WarrenBelz
146,618
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,957
Most Valuable Professional