cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rho1967
Helper III
Helper III

SQL database with Dropdownbox

Hi everyone,

I am working with a SQL database with Dropdownbox.

The dropdown box1 now contains the ID of a record in my recipes table. The dropdown works well, but I would like to show a different text instead of the recipe.ID.
For example, the name of the recipe recipe.name .

I have to keep working with the ID in the database.

Regards

4 REPLIES 4
CNT
Super User
Super User

@rho1967 

Please try the following,

Change the Value property to the recipe name field.

CNT_0-1637749971716.png

 

Thanks for the quick reply.

If I then leave the datacard to Dropdown1.Selected.ID nothing is saved.

 

I work with 2 tables.

kitchen.ingredients

kitchen.recipes

 

I need to be able to add ingredients in the recipes app. But the ingredients can also be changed by, for example, a different name.

If I change the name, the link is not established.

 

Is it possible if I change something in the kitchen.ingredients database that it will be adapted in the kitchen.recipes database?

 

Can I use the patch function for this?

Regards

@rho1967 I believe the Update property should be Dropdown1.Selected as a record should be sent back to be saved.

Thanks for the quick reply.

 

Unfortunately, he won't accept it. 

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (2,429)