Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Lookup Function

Good afternoon,

I have a lookup function:


                'TEAM MEMBER'.Value = Input_TeamMemberTarea.Selected.Value && FECHA = Input_FechaTarea.SelectedText.Value && SERVICIO.Value = Input_Servicio.Selected.Value


 'TEAM MEMBER', 'FECHA' and 'SERVICIO' are columns in TAREA list
but I have an error:

It says that both values are in a different type.

can you help me solve that?



It only allows me to put:

FECHA = Input_FechaTarea.Selected.FECHA

Input_FechaTarea.Selected.FECHA returns a Date value. To use DateValue() it needs inside a Text value

Otherwise I can put:

FECHA = DateValue(Input_FechaTarea.SelectedText.Value)

 Input_FechaTarea.SelectedText.Value returns a text value

but it returns the same error

Ok, so what is the error when you use ?

FECHA = Input_FechaTarea.Selected.FECHA

Is the error to do with this equation or is it something else.


Also, how are you making your dropdown dates? Can you show me the formula / items of the dropdown.



 Date Error:

Date error.PNG

When I save:


The dropdown items property:

Filter(CALENDARIO;SEMANA = Input_SemanaTarea.Selected.Result)


@JoseC12 so you are using another list - CALENDARIO - to create a list of Weeks (SEMANA)? Is Semana a text field? 


Basically, you need everything to be of type date (not text) - or- you need to convert to dates so that you have Date = Date, you cannot have Date = Looks like a Date.


Dates are a special data type. They are just numbers but in milliseconds from 1/1/1970 (I think this is the standard start date). So when comparing dates if you try to compare 02/03/2020 = 02/03/2020 their millisecond number MUST match and their data type MUST match otherwise you will get an error.


In your situation you may also be able to compare Text to Text eg '01/03/2020 - 08/03/2020' as a text value but I'm not sure because the CALENDARIO table seems to be pulling in text not dates.


Could you screenshot the CALENDARIO table as well as the Main data table you are sending data to as well as the field types.


As I said I put the formula:


FECHA = Input_FechaTarea.Selected.FECHA


and 'Input_FechaTarea.Selected.FECHA' returns a Date value but the error still appearing.

About selecting weeks ('Semana') it accept normally because the column is in single text as you said Single text=Single text

But about the date, in the TASK list (where I want to save), is a Date&Time type. So I want to add a dropdown where I put all the dates from another list called CALENDARIO:

Calendario data.PNG

I tried to change, the date form into "dd/mm/yyyy"

change format.PNG

but I see it doesn't update, how can I fix it?



Tarea data example:




I feel that this is the correct formula

FECHA = Input_FechaTarea.Selected.FECHA


When you put the above into your formula there appears to be another error happening? The original error (your first post) only had the error under the '=' whereas when you put in the above the entire formula gets a red line so I think there's something else causing this error not dates?

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!


Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (73,163)