Pass selected data in table to Text box

(1) Share

Report

Posted on by Skybluekid

254

Hi,

I am very new to Power Apps, I have a Data Table with a list of PO's. What I would like to do is if the user selects a line, and presses a button, it would take the PO number and put it in a text box on another.

Any ideas would be most grateful.

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Sundeep_Malik 6,484 on at

Like (2)

Report

Re: Pass selected data in table to Text box

Hey @Skybluekid

There is no on select property for data table. So we would take help of variables here.

Take a button, and on select property of that button write a similar formula:

Set(selectedItem, DataTable.Selected)

Then take a text box and in that text box write the following formula:

If(IsEmpty(selectedItem), "", selectedItem.Title)

If nothing is selected the data table, it will show nothing and when you select a line in table it will show the title for it. You can replace it with PO Number.

I hope this helps 🙂

Was this reply helpful? Yes No
Skybluekid 254 on at

Like (1)

Report

Re: Pass selected data in table to Text box

Thank you very much

Was this reply helpful? Yes No
Skybluekid 254 on at

Like (0)

Report

Re: Pass selected data in table to Text box

@Sundeep_Malik I have 3 other fields in that Table(Date, Description and Value). Am I able to extract this information from the selected value?

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (1)

Report

Re: Pass selected data in table to Text box

@Skybluekid

You will be able to do that. Just replace the .Title with other columns.

with the on select on button, we are extracting every field for that item with: DataTable.Selected

Was this reply helpful? Yes No
Skybluekid 254 on at

Like (0)

Report

Re: Pass selected data in table to Text box

Thank you once again

Was this reply helpful? Yes No