Getting error: The arugments of DateTimeValue function do not represent a valid Date or Time value

(0) Share

Report

Posted on by DBTS7

Hi All,

I'm getting an error: The arugments of DateTimeValue function do not represent a valid Date or Time value.

I wrote below code:

Text(DateValue(
Left(
Text(
LookUp(
TempFilter,
Uuid=ThisItem.FilterId,
CreatedOn
)
), 10
)
), "mmm dd, yyyy")

I'm not getting how to resolve that error message. I've tried all possible solutions.

Please help......

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

RusselThomas 4,014 on at

Like (0)

Report
Hi @DBTS7 ,
If I replace your lookup expression with Today(), it works fine.
Text(DateValue( Left( Text( Today() ), 10 ) ), "mmm dd, yyyy")
If it also works for you, then I suggest you check the result of your formula manually;
LookUp( TempFilter, Uuid=ThisItem.FilterId, CreatedOn )
to make sure it's actually returning a date in Date format.
Hope this helps,
RT

Was this reply helpful? Yes No
DBTS7 on at

Like (0)

Report

Thanks Russel but by using Today() instead of Lookup() function, the data is giving today's date.
I want date when that particular item is created.

Was this reply helpful? Yes No
RusselThomas 4,014 on at

Like (0)

Report

Hi @DBTS7 ,
The point of using Today() is only to troubleshoot, not to solve the problem - if using Today() works without errors this tells you your LookUp() formula is the problem.
To fix it, you then troubleshoot your LookUp() formula, as suggested - and once that's fixed you get rid of Today() and replace it with the working LookUp() formula, which should resolve your problem.
Make sense?
Kind regards,
RT

Was this reply helpful? Yes No
DBTS7 on at

Like (0)

Report

Yeah I'm trying to replace LookUp() or modify it.
Thanks

Was this reply helpful? Yes No
RusselThomas 4,014 on at

Like (0)

Report
Hi @DBTS7 ,
Ok, so we need some more information to continue troubleshooting;
What is your data source TempFilter? (SPO List, Dataverse, SQL, Collection)
If it's a collection, does it have data in it?
Can you manually perform a LookUp() using this condition and get a result from the source? (i.e. use a text label and place in a static conditions - in other words do NOT reference ThisItem in the formula)
Like using Today(), not referencing ThisItem is not the solution, it's a way to find the problem. Do it, then let us know what happens so we can continue troubleshooting.

Other things to check;
What is the data TYPE of Uuid in the source? (Text, Number, GUID?)
Is ThisItem.FilterId of the same type? Just because they both look the same does not mean they are of the same type.
Is this LookUp() condition the correct condition to be testing for? (what other condition would you replace it with?)
Warning - If Uuid is of a GUID type in your source and you've collected it to TempFilter, then you may want to convert your FilterId to a GUID as well for comparative testing, because it's probably being converted to a string on the way into your collection.
The condition If(GUID = String) will always return false, meaning your LookUp will return blank. If this is the case, try this;

LookUp( TempFilter, Uuid=GUID(ThisItem.FilterId), CreatedOn )

Alternatively, think of some other field you can use to uniquely identify the record.
Let me know how it goes, and if you're still stuck please do answer the questions above.
RT

Was this reply helpful? Yes No
DBTS7 on at

Like (0)

Report

I'm using SQL for storing data.
UUID is a Text data type and I'm using UUID to get different data whenever user create or save any new data.

I've tried to received data from gallery of TempFilter as shown in the image and it not showing any FilterId inside edit fields but when I'm using above formula(1st ques. that i asked) than it is showing FilterId for options inside TempFilter and also tried to fetch data using LookUp() function inside label(downside to the gallery (in image)), but it is not giving anything.

CaptureLookupTest...

Was this reply helpful? Yes No
RusselThomas 4,014 on at

Like (0)

Report
Hi @DBTS7 ,
Perhaps I'm missing something here, but why would your Uuid be equal to your FilterName?
I don't think that label formula would ever work. The idea was to add it into the gallery using the lookup formula with the same condition you originally posted.

Anyway, it looks like your gallery already has the CreatedOn field you need, so not sure why you have to look it up again? If you already have a label there that has the CreatedOn date - are you just trying to change the format of the CreatedOn date on that label for each row, or do you actually need to do a lookup to data elsewhere?

Based on your screenshot, can you not just change the Text: property of the CreatedOn label INSIDE the gallery to the following?

"CreatedOn: " & Text(ThisItem.CreatedOn, "mmm dd, yyyy")

Kind regards,
RT

Was this reply helpful? Yes No