cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

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.

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 

1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

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

 

View solution in original post

1 REPLY 1
Syndicate_Admin
Administrator
Administrator

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

 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Kudoed Authors