Hello everyone,
I need to develop an application that is going to get the last modified .xlsx file from a SharePoint folder and verify if a given code exists in one of the columns.
This .xlsx file is always going to have the same format because it is an export from SAP. I cannot import a .xlsx file as a connection because it has to be dynamic.
I created a Collection in order to get the first .xlsx file :
ClearCollect(ExcelFile, First(
Sort(
Filter(
'Expedition Validator',
EstUnDossier = false && 'Chemin d’accès au dossier' = "Expedition Validator/Fichiers excel/" && Lower(Right(
ThisRecord.'Nom de fichier avec l’extension',
4
)) = "xlsx"
),
Modifié,
SortOrder.Descending
)
));
This code allows me to find the file and all the metadata related to the file I would like to use the data :
However, when I try to use the LookUp function to verify if a code exists in a column from the collection ExcelFile, it does not work at all, because it does not identifies the Collection "ExcelFile" as a Excel file.
How can I get the data from this file, in order to verify if a code exists or not in this excel file?
Thank you very much!
