Answered

How to get Gallery to show all selected values in data table

(0) Share

Report

Posted on by overhead_press2

Current I have a data table on the left and a gallery on the right. I am having issues having the right side display the selected values in my data table. I have the column names figured out but not sure how to display the corresponding column values instead of showing values from just one column.

The code for my text input box is currently : table.Selected.column1

How do I expand that to include the values for the other 4 columns? Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @overhead_press2

It would be easier if you had an Edit form on the right instead of a gallery. You would set the Edit form Datasource to your table and the Item property to Lookup(table, ID=Datatable1.Selected.ID). You would need to add a "+" icon with its OnSelect property of NewForm(Form1) so that you could add a new record. You would also need an icon with SubmitForm(Form1) to save your changes. You can add all of the fields to the Edit form from the fields dropdown on the right hand side of the screen and sort them in the order you prefer using drag and drop on the list of fields.

FYI galleries and datatables are meant to display all or some of the records in a table, the Edit form and Display forms are meant to show, modify or add a single record to a table.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi@overhead_press2,

Based on the issue that you mentioned, do you want to display all the values from the DataTable selected record?

Could you please share a bit more about the scenario?

Actually, there is something misunderstood with the Gallery display items. Each section within the Gallery represents a single record, so does the DataTable.Selected. Therefore, you could not display the DataTable.Selected as multiple sections within the Gallery. DataTable.Selected.Column is a single text value specified to a certain column within a record.

I have a test on my side, please take a try as below:

Set the Items property of the Gallery as:

DataTable2.Selected

Set the Text property of each Label within a same section as below:

DataTable2.Selected.Column1 DataTable2.Selected.Column2 DataTable2.Selected.Column3

Hope it could help.

Regards,

Qi

Was this reply helpful? Yes No