Expression.SyntaxError: Token Eof expected. and Token Comma expected

[berezinskiy-p]

Please, help, i can't understand my falt

Error in editor - Expression.SyntaxError: Token Eof expected.

Error in update - Token Comma expected

= Let (page as number) as table => 
Let yesterday = Date.ToText(Date.AddDays(DateTime.Date(DateTime.LocalNow()),-1),"yyyy-MM-dd"),
Source = Json.Document(Web.Contents("URL/api/v4/orders?filter[createdAtTo]="&yesterday&"&page=" & Number.ToText(page) & "&limit=100&apiKey=TOKEN")), orders = Source[orders], 
#"Converted to Table" = Table.FromList(orders, Splitter.SplitByNothing(), null, null, ExtraValues.Error) 
in 
#"Converted to Table"

[Bridgetter]

I am recieving  "Expression.SyntaxError: Token ',' expected" for expression

IF(AND([Team]="Johnson", "Ohio") THEN, "Maryland" else [Field Office]))). I cannot clear up my error. (first says IF is spelled incorrectly now I cant get past the Syntax error) Thanks

[lbendlin]

@Bridgetter please open a new thread.

[lbendlin · Accepted solution]

Power Query is case sensitive.  Instead of "Let" use "let"

You can simplify "yesterday"

yesterday = DateTime.ToText(DateTime.LocalNow()-#duration(1,0,0,0),"yyyy-MM-dd")

[berezinskiy-p]

https://skr.sh/sCxle6hYoo0

now it shows that i have error with comma and "Expression.SyntaxError: Token Eof expected." (((

[lbendlin]

you need to put "let"  before "yesterday" 

[berezinskiy-p]

Thank you, it works! Ihha!