cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Dropdown box SQL display and apply value

Hello all, I want to create a dropdown box that looks up a value from another table (I use Azure MSSQL), in this case I have an 'Actvity' table, which consists of the following fields;

  • ActivityID (Key)
  • ActivityCategoryID
  • ParticipantID
  • Amount

I have two other tables which relates to this one (Simplified);

  • ActivityCategory
    • ActivityCategoryID (Key)
    • ActivityCategoryDescription
  • Participant
    • ParticipantID (Key)
    • ParticpantName

I have created a screen where I can add activities;

image.png

In that screen I added a dropdown box which I have connected to the table 'ActivityCategory';

image.png

 

 

image.png

 

The next thing I want to do is that the dropdown box displays the description, I have to do the following;

image.png

So far all is going fine, but now when the record is updated I want to have the number updated to th sql table instead of the description, because when I submit now, obviously I get an error.

How can I do this?

 

Best Regards,

Sapper

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

Re: Dropdown box SQL display and apply value

OK, found it myself........always good to post a question 😉

 

I did the following to solve it, all the steps as described above, including;

 

Select the datacard that holds the dropdown;

ScreenHunter 52.png

 

The go to the tab 'advanced' and to the field 'Update'

image.png

 

And change it to the field you want to have;

image.png

 

That's it!

View solution in original post

1 REPLY 1
Highlighted
Frequent Visitor

Re: Dropdown box SQL display and apply value

OK, found it myself........always good to post a question 😉

 

I did the following to solve it, all the steps as described above, including;

 

Select the datacard that holds the dropdown;

ScreenHunter 52.png

 

The go to the tab 'advanced' and to the field 'Update'

image.png

 

And change it to the field you want to have;

image.png

 

That's it!

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,511)