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;
I have two other tables which relates to this one (Simplified);
I have created a screen where I can add activities;
In that screen I added a dropdown box which I have connected to the table 'ActivityCategory';
The next thing I want to do is that the dropdown box displays the description, I have to do the following;
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?
Go to Solution.
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;
The go to the tab 'advanced' and to the field 'Update'
And change it to the field you want to have;
View solution in original post
Check out these cool Power Apps & vote on your favorite!
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021