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

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

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!

Top Solution Authors
Top Kudoed Authors
Users online (6,903)