Yes it is first, because you are using the frist function. This will always return the first record of a table. If you use Last it will give you the Last record of the Table
Set(
rootFolder,
Last(colFolders).'{FullPath}'
);
If you use this code you get a table with one column that has all root folders:
Set(
rootFolder,
colFolders.'{FullPath}'
);
to get a specific record or a few you could use a filter (Returns all records matching the criteria) or a lookUp funtion (Returns first record matching the criteria)
