Hi @maxiq_2k ,
Please pay attention and check below things:
1. Is SucursalSH the name of your TextInput control? If yes, you should use sucursal12=SucursalSH.Text in your formula.
2. What’s the column type of FechaSH in your SP ? If this is a Date column, you should use this as the condition(remember to add SelectedDate for the Date Picker control):
Text(FechaSH;"[$-es-ES]dd/mm/yyyy";"es-ES")=Text(DatePicker2.SelectedDate;"[$-es-ES]dd/mm/yyyy";"es-ES");
You can add some labels and set them to First(VencLocal).FechaSH and Text(DatePicker2.SelectedDate;"[$-es-ES]dd/mm/yyyy";"es-ES") to compare their date format.
For example, my SharePoint has a Date column called "date1", this is its default result format(with time):
This is the result of my date picker control:
After change(this time you can lookup a record and get its ID):
So on your side, you can try this:
LookUp(VencLocal;
EanSH=confean.Text &&
sucursal12=SucursalSH.Text &&
Text(FechaSH;"[$-es-ES]dd/mm/yyyy";"es-ES")=Text(DatePicker2.SelectedDate;"[$-es-ES]dd/mm/yyyy";"es-ES");
ID)
Best regards,
Allen
