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 (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 (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 (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 (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 (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