cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Fusion
Level: Powered On

Getting information form a DataTable to Text Box's

Hey all, need some help. I have been trying to get information form a Data Table and populate a bunch of textboxes when the user presses the Edit button. 

I have used the txtBrand.Text = dtDeviceInfo.Selected.Brand but nothing shows up and I have been researching through this site and can't seem to find a way to do this. 

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Getting information form a DataTable to Text Box's

@Fusion 

 

For a Text Input control, you need to place this expression on the "Default" property.
 
Hope this Helps!

View solution in original post

6 REPLIES 6
Dual Super User
Dual Super User

Re: Getting information form a DataTable to Text Box's

Hi @Fusion 

 

Can you please confirm where you are putting this value for the DataTable selected item? I carried out a simple test on my side and it worked fine.
 
I have made a reference to Data Table selected item on the label, but using below mentioned formula on Text property of label:
Expression: 
DataTable1.Selected.Education
Here DataTable1 refers to the name of my DataTable and the Education is the attribute that I want to refer to.\MicrosoftTeams-image (141).png

 

Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Fusion
Level: Powered On

Re: Getting information form a DataTable to Text Box's

Sorry for taking a while to reply the issue is I need it done when the user hits the edit button. 

So within btnEdit.OnSelect I have the code 

txtBrand.Text = dtDeviceInfo.Selected.Brand

Which then does nothing when the button is pressed

Highlighted
Dual Super User
Dual Super User

Re: Getting information form a DataTable to Text Box's

@Fusion 

 

This is happening because you cannot set control text directly, for doing so, please follow below steps:
 
Button -> OnSelect -> Set(SelectedBrand, dtDeviceInfo.Selected.Brand)
 
Label -> Text -> SelectedBrand
 
Using a variable you can directly set the reference to update value.
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Fusion
Level: Powered On

Re: Getting information form a DataTable to Text Box's

I just tried your response but the issue is that I am using a text box and not a lable as this is also used as an input method. 

The text box does not have the TEXT property in the pull downAnnotation 2019-07-02 160831.png

Dual Super User
Dual Super User

Re: Getting information form a DataTable to Text Box's

@Fusion 

 

For a Text Input control, you need to place this expression on the "Default" property.
 
Hope this Helps!

View solution in original post

Fusion
Level: Powered On

Re: Getting information form a DataTable to Text Box's

So easy how did I not know that

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (3,709)