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


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (71,917)