Hi @Anonymous ,
It helps greatly to post your code in Text - I have done this below (OCRd so watch spelling)
Sort(
RenameColumns(
AddColumns(
GroupBy(
Sort(
'Project Portfolio List',
ID,
Descending
),
"ProjectID",
"OtherData"
),
"Project Name",
First(OtherData).'Project Name',
"Country",
First(OtherData).Country,
"Function",
First(OtherData).Function,
"Methodology",
First(OtherData).Methodology,
"CreationYear",
First(OtherData).CreationYear,
"ID",
First(OtherData).ID
),
"ProjectID",
"Project ID"
),
'Project ID',
Descending
)
You can also do it this way (Note you have the same Delegation limitations as above and need all the records to be in the newest xxx (Delegation limit) records and get all the fields available
With(
{
wList:
Sort(
'Project Portfolio List',
ID,
Descending
)
},
With(
{
wGroup:
AddColumns(
GroupBy(
wList,
"ProjectName",
"Data"
),
"gID",
First(Data).ID
)
},
Sort(
Filter(
wList,
ID in wGroup.gID
),
'Project ID',
Descending
)
)
)
but to your question - the Item of the Form can simply be
LookUp(
'Project Portfolio List',
ID = GalleryName.Selected.ID
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
