CODEWITHSUNDEEP
powerappspowerapps-canvas
BossMoffel Inc
BossMoffel Inc

Reputation: 1

Unexpected characters and Expected operators. Power Apps

I have been trying out Power Apps of late and I ran into this issue creating a form that links to a SQL database: Unexpected characters and Expected operators. And for the life of me I don't know what characters and operators they are complaining about. 

Text(DateDiff(
    TimeValue(Text(Dropdown1_2.Selected.Value) & ":" & Text(Dropdown1_3.Selected.Value)),
    TimeValue(Text(EndHrs_1.Selected.Value) & ":" & Text(EndMin_1.Selected.Value)),`Hours,"[$-en-US]00") & ":" &
Text(Mod(
    DateDiff(
    TimeValue(Text(Dropdown1_2.Selected.Value) & ":" & Text(Dropdown1_3.Selected.Value)),
    TimeValue(Text(EndHrs_1.Selected.Value) & ":" & Text(EndMin_1.Selected.Value)),Minutes

Upvotes: 0

Views: 1689

Answers (1)

SeaDude
SeaDude

Reputation: 4375

‘,Minutes’ at the end appears to be out of place being outside the last parenthesis. Typically the only thing after a paren that can be used is a semicolon to chain another statement or a period to “dig” into the schema.

Upvotes: 0

Related Questions