Share
Report
44Hello, I'm creating an app with gallery based on Sharepoint list "myRegistrar".
My data example are like this (ID is the Sharepoint list unique ID):
| ID | RequestGUID | UserName | SystemName | RequestType | [...many other fields] |
| 9 | dbe4922c-8231 | John Smith | Server S0002 | <some_value> | <field_values> |
| 10 | dbe4922c-8231 | John Smith | Server S0002 | <some_value> | <field_values> |
| 11 | 32412ed1324r42 | Lucy Foo | Server S0003 | <some_value> | <field_values> |
| 12 | 32412ed1324r42 | Lucy Foo | Server S0003 | <some_value> | <field_values> |
I need to dislpay in my gallery ALL the data columns from the max ID, grouped by RequestGUID:
| ID | RequestGUID | UserName | SystemName | RequestType | [...many other fields] |
| 10 | dbe4922c-8231 | John Smith | Server S0002 | <some_value> | <field_values> |
| 12 | 32412ed1324r42 | Lucy Foo | Server S0003 | <some_value> | <field_values> |
I'm struggling with AddColumns, Filter and GroupBy, but I was not able until now to get all columns.
I used to load Items in my Gallery:
AddColumns(
GroupBy(
myRegistrar;
"RequestGUID";
"Requests"
);
"MaxID";
Max(
Requests;
ID
)
)
I effectively obtain the correct ID, but I cannot be able to retrieve all other columns to display in my gallery (and related formview).
I'm searched among other posts, but none helped me...
Could anyone please give me some useful hint to solve this problem?
Thank you
Categories:
I have the same question (0)
All responses (
Answers (
