Nested table values in a gallery group by identifier

(0) Share

Report

Posted on by JamtMaster

140

Greetings.

I have the following collection:

ClearCollect(
 colValidaciones,
 GroupBy(
 ValidacionConocimientos_1,"Identificador",
 "Data"
 )
)

This generates a collection with 2 fields, the identifier field and the data field, which is a table type and is where the data that interests me is.

I was using the code:

First(First(colValidaciones).Data).Evaluator

to show the data that I was interested in that is inside data but then I realized that it didn't work for me since it always shows the same data. And try something like:

LookUp(colValidations, Identifier = ThisItem.Identifier).Data.Evaluator

but it gives an error. What would be the correct way to achieve what I need?

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Cat Schneider 488 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Couple things (mainly out of curiosity, I am a Cat, after all... 😅)
1. Where is the information coming from that populates the collection?
2. How is the collection updated?
3. What is being used to display the first level of the collection?
4. Where in your app are you trying to display/interact with the "Data" table?
JamtMaster 140 on at

Like
a
(0)

Report
Copy link

Link copied!
@CatSchneider
Currently I managed to solve it in the following way:
In the gallery:
GroupBy( ValidacionConocimientos_1,"Identificador", "Data" )
In the gallery items:
First(ThisItem.Data).Training
Now all I need is a way to filter the data in the gallery using a texinput but I can't find the correct logic.

1. A sharepoint list
2. It is no longer necessary but it was updated in the on visible property of the form where it was hosted and with a button within that screen in case you wanted to refresh the data.
3. item of a gallery
4. in a gallery
Cat Schneider 488 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
So, when you click to select the Gallery under Tree view... then look at the Items property value (in the Formula bar) or Data source (at the top of the properties pane), what is the value?

This is the value below, correct?
GroupBy( ValidacionConocimientos_1,"Identificador", "Data" )

If so, then I am assuming that the name of your SP list (as it's linked in your app) is "ValidacionConocimientos_1", there is a field in your list named "Identificador", and that there can be multiple records in the list that share the same value, which you are grouping together as "Data".

Then each Gallery Item is made up of a distinct "Identificador" value, with an associated list of 1 or more records in the "Data" field. Within your gallery, I am assuming that there is a textbox or label of some sort that you are then showing the value of
First(ThisItem.Data).Training

Where I am lost on your ask is... are you trying to filter the Gallery Items? Or the Data Items?

As a sidenote, if you want to quickly see a list of each record in Data, you could use the following in a label control (with the Gallery Items Template) set to either AutoHeight = true or Overflow = Overflow.Scroll:
Concat(ThisItem.Data, Training & " - " & FieldName, Char(10))
where the dash is any character you want to separate the values, and FieldName is any other Field included within Data (like a Completion status, for example)