MS-SQL help: How to get the values from Foreign Key Table. I just want to show those values in Particular Textboxes as Hint Text.

[Syndicate_Admin]

Hi,

Can we display a data from MS-SQl column data into particular Text input field(Canvas App). Here I am using a Gallery to get into next screen; After that If any related data is available in the particular column means it should show that data in that Textinput field & This value will be available from Foreign Key Table of MS-SQL

Please help me on this scenario.

Regards,

Roselin 

[Syndicate_Admin · Accepted solution]

Hi @Roselin 

Yes, this is possible. You can set the HintText property of your text input control to a call to the LookUp function. Your call to LookUp would retrieve the required data value.

https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-filter-lookup