0

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
Arun Vinoth-Precog Tech - MVP
  • 22,364
  • 14
  • 59
  • 168
BossMoffel Inc
  • 1

1 Answers1

0

‘,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.

SeaDude
  • 3,725
  • 6
  • 31
  • 68