You’re offline. This is a read only version of the page.
Announcements
Hello everyone,
I'm trying to sort a gallery of a sharepoint list using as sorting criteria a column from another list. Both lists have an ID column that is the relation of the tables.
Please let me elaborate:
The gallery shows the items from TableA, and the goal is to sort it using TypeColumnB as criteria.
After reading some posts I wrote this:
Share
ReportSort(
AddColumns(TableA;"NewColumn";
LookUp(TableB;IDColumnB=IDColumnA.Value;TypeColumnB.Value)
)
;NewColumn;SortOrder.Descending
)
| Name in example (For clarity) | Description | Original name |
| TableA | Sharepoint List | '232 - Actividades - Calibraciones' |
| TableB | Sharepoint List | '232 - Lista de equipos e instrumentos - Calibraciones' |
| IDColumnInA | A LookUp type column inTableA | 'ID de equipo Actividades' |
| IDColumnInB | A Text type column inTableB | TituloEquipos |
| TypeColumnInB | Multiple choice column from Table B | 'Tipo @Equiposeinstrumento' |
The problem is that the created column from the code above (NewColumn) is empty.
And in the end sorting doesn't work.
Any help would be apreciated.
Hi @drudas ,
Try using below formula -
All responses (
Answers (
4,667
Sort(
AddColumns(TableA;"NewColumn";
Concat(LookUp(TableB;IDColumnB=IDColumnA.Value; TypeColumnB) ; Value ; ",")
)
;NewColumn;SortOrder.Descending
)
