Gallery of a specific record

(0) Share

Report

Posted on by barrymac20

175

Is it possible to create a gallery based on one record in a table?

The gallery would should a record for each field of a specific row.

e.g. A table has 5 columns (ABCDE) and 3 rows (123)

A normal gallery will have 3 records, one for each of 1,2 & 3.

I want a gallery to show the 5 records/columns for one specific row.

Or is it only possible to get specific record details by using a form?

Barry

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

eka24 20,923 on at

Like (0)

Report

To enable you view gallery items in a form, you can insert a Gallery and set the item to the Datasource.
Then in the Item of the form, put Gallery1.Selected
That whatever you click in the gallery appears in the form

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Was this reply helpful? Yes No
barrymac20 175 on at

Like (0)

Report

Thanks for the reply.
I'm aware of that process but what I'm wondering is if its possible to retrieve a specific record into a gallery without the need for a form. This is so I can do a lookup against all the fields of one record easily.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report
You can insert a label and filter the Gallery based on the value in the label which can be an Title of the record:
Filter(TableName, SearchBox1.Text in Title)

Was this reply helpful? Yes No
barrymac20 175 on at

Like (0)

Report

Hi.

I've added some sample images that I hope will explain better.....

The DataTable shows data that is changed by a form with multiple drop downs (my real life example has 90+ drop downs in the form). There can and will be multiple rows in this table.

For each value in the rows I want to lookup against the LookupTable to pull the individual price and then sum all of these to get a total price. The lookup table will have a couple of hundred rows that included all the possible items that can be picked for the DataTable.

DesiredResult shows what I'm looking for. A dynamically produced Sum for a given record in the DataTable that will change if any of the values un the DataTable change.

Currently the only way I know of doing this is to create a textbox and add a lookup formula for each item and add them together, but for 90+ values this is too long and too slow.

Is there another way to do what I'm looking for?

Barry

Info.JPG

Was this reply helpful? Yes No
barrymac20 175 on at

Like (0)

Report

So i've attached a snap of my actual form, which shows one record from a data table. These are all drop downs and there are 90 of them.

I want to be able to transpose all of the values in the dropdowns into a column so I then do a lookup against the price table. Can this be done?

ActualForm.JPG

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

What you have shown in the picture are textboxes not dropdowns. I cant see 90 dropdowns in your screenshot. explain further

Was this reply helpful? Yes No
barrymac20 175 on at

Like (0)

Report

They are dropdowns but they are currently in view mode. You cant see 90 because they don't all fit on the screen.

I've been able to figure this out by creating a collection of the fields and placing them in a column. Its working ok.

Barry

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (1)

Report
Hi @barrymac20 ,

Do you want to display 5 columns of a specific record as separated rows within the Gallery?

Based on the needs that you mentioned, I think the Concat function and Split function could achieve your needs. I have made a test on my side, please take a try with the following workaround:

Set the Items property of the Gallery to following:

Split( Concat( Filter('20190816_case6', ID = 30), Title &";" & 'Due Date' & ";" & 'Trip Status'.Value ), ";" )

On your side, you should type the following formula within the Items property of the Gallery:

Split( Concat( Filter('Your Table', PrimaryColumn = "Specific Value"), // find the specific record in your Table A &";" & B & ";" & C & ";" & D & ";" & E ), ";" )

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No