Unknown word starting at index 0 ???

(0) Share

Report

Posted on by RvdHeijden

602

Hey guys, i need your help with this one.

Ive made an If statement in my gallery and it used to work until I changed the formula to deal with the Date colum 'Datumtelling' and now i get a strange error

If(
ddHoofdprojecten.Selected.Result= "Alle projecten" And ddDatumTelling.Selected.Result = "Alle tellingen";
'Voorraden Logistiek';
ddHoofdprojecten.Selected.Result= "Alle projecten" And ddDatumTelling.Selected.Result = "Alle tellingen";
Filter('Voorraden Logistiek';(Text('Datumtelling'))=ddDatumTelling.Selected.Result);
ddHoofdprojecten.Selected.Result <> "Alle projecten" And ddDatumTelling.Selected.Result = "Alle tellingen";
Filter('Voorraden Logistiek';Hoofdproject.Value = ddHoofdprojecten.Selected.Result);
ddHoofdprojecten.Selected.Result <> "Alle projecten" And ddDatumTelling.Selected.Result <> "Alle tellingen";
Filter ('Voorraden Logistiek';Hoofdproject.Value = ddHoofdprojecten.Selected.Result And (Text('Datumtelling')) = ddDatumTelling.Selected.Result))

The Error states: that the string wasn't recognized as a valid date/time. There is an unknown word starting at index 0.

I have no idea where to begin trying to fix this problem but I do Know it started when I changed the part with (Text('Datumtelling'))

However the complete formula now has a red line under it so basically the whole thing is broken

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RvdHeijden,

Do you mean that the 'Datum telling' is a Date column in your Data Source?

Could you please tell me that how you set the ddDatumtelling?

Actually, a data and time column has value with date time format, there is no necessary to format it as text string and populate a dropdown with it. Since you have formatted it as text string, it may cause invalid date/time issue when you compare it with the date column directly in your formula.

I would suggest you use a normal DatePicker to select date which could compare it with the date column directly.

Was this reply helpful? Yes No
Verified answer

RvdHeijden 602 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-qiaqi-msft the funny thing is that the error isn't there anymore ... and i have no idea why.
Maybe there was an error somewhere but either way it's gone now.

I just have a warning symbol in the formula because of the = statement at the end of the formula but I fixed that myself because I referenced to the colum DatumTelling but the column wasn't in ""

Problem solved I guess.....

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RvdHeijden,

Glad that you have solved your problem.

Please mark your reply as answer.

Was this reply helpful? Yes No