Trying to chain statements but get "Missing operator"

(0) Share

Report

Posted on by simondpalmer

131

Hi I have the following code in "Items" of a Gallery

AddColumns(DateRange,"vis",Date>=(ThisItem.StartDate) && Date<=(ThisItem.DueDate));
AddColumns(IndexedPhases, "col",LookUp(IndexedPhases, Value=(ThisItem.Phase.Value),PhaseColor))

When each of these statements are by themselves the formula runs but I cannot get the ; operator to chain them. What and am I missing?

Any help would be appreciated. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

FrostedFlake 138 on at

Like
a
(0)

Report
Copy link

Link copied!

1. Please try to replace every , with an ;
2. Try to use && to chain statements instead of using ;

The syntax of PowerApps is really weird somehow

Was this reply helpful? Yes No
simondpalmer 131 on at

Like
a
(0)

Report
Copy link

Link copied!
That just creates alot more errors. Is it because I have a Boolean operation (&&) that is not enclosed in parenthesis? I tried that as well (as shown below).
AddColumns(DateRange,"vis",(Date>=(ThisItem.StartDate) && Date<=(ThisItem.DueDate))); AddColumns(IndexedPhases, "col",LookUp(IndexedPhases, Value=(ThisItem.Phase.Value),PhaseColor))
but I still cant get it to work.
Is it because I am adding multiple columns to "Items" of a gallery? And I cant treat it as if I am adding columns to a Table? Or can I?

Was this reply helpful? Yes No
simondpalmer 131 on at

Like
a
(0)

Report
Copy link

Link copied!
I am guessing the problem is I am "addingcolumns" from 2 separate Tables. The "DateRange" Table I need for visibility settings and the "IndexedPhases" is used for coloring buttons. I instead tried to add the color information for the "fill" settings like below
LookUp(IndexedPhases, Value=(ThisItem.Phase.Value),PhaseColor)
But that doesn't work. Any help would be awesome

Was this reply helpful? Yes No
FrostedFlake 138 on at

Like
a
(0)

Report
Copy link

Link copied!
To chain multiple statements you have to do a double semicolon after a statement

SubmitForm(SharePointForm1);;

Was this reply helpful? Yes No
Verified answer

simondpalmer 131 on at

Like
a
(0)

Report
Copy link

Link copied!
I worked it out. For a Galleries Items you can't add columns from two separate tables. So I made sure I had everything I needed was in ThisItem so after I retrieved everything I needed from the table (DateRange) I just went and referenced ThisItem to grab a value for a Color.
AddColumns(DateRange,"vis",Date>=(ThisItem.StartDate) && Date<=(ThisItem.DueDate),"col",(ThisItem.Color))

Was this reply helpful? Yes No