Set a value by selecting a different column's value

[CoStratify]

Hello!
I have got a SQL table with applications. Each application has an ID called 'AppID'.

I also have a SQL table for servers. Every server needs to have an Application associated with it. The user however does now know the AppID and would need to use the AppName to select it.

The server content is in a gallery in my PowerApp and can be edited from there. This is then saved to the DB via a patch.

I need the user to be able to select an Application from a dropdown (showing all of the AppNames included in the table). After, editing the row the patch needs to assign an AppID to the server row, dependant on the AppName selected (the AppID that is on the same row in the Application table).

I have tried the below and it works.

Dropdown Items =     '[dbo].[fp_cat_apps]'. AppName

Dropdown section of Save Patch =      

AppID: Dropdown1.Selected.AppID

However, my major issue, is that if the server already has an AppID assigned to it, I want the dropdown to see that and show it in the dropdown's content by selecting it in the first place.

Please let me know if I can provide any more information 

[VijayTailor · Accepted solution]

Hi ,

better for this issue you can use Combobox. 

and set the yellow highlighted in the screenshot

Once to set above 2 properties  (Highlighted in Screenshot) then it will same look like DropDown.
After that set the  DefalutSelectedItem if AppID is already assigned.
like in  the below place.

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[CoStratify]

This is great! Thank you. 

Your first step makes sense, but what do I need to write for the second step to get it to see the AppID as default?

I have tried 
If(ThisItem.AppID) but brings up errors. 

[VijayTailor]

Please Attached Screenshot if possible.

but for DefaultSelecteItem you can set like that - [ThisItem.'Project Name'.Value].

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[CoStratify]

Thanks again. 
Had a look at your second screenshot and it doesn't contain a formula in the highlighted box. 
I have again tried [ThisItem.'AppID'.Value] but again sadly doesnt work

[VijayTailor]

Can you attach the screen of the Issue or Error? showing