Answered

Error in Power Apps Formula: "The right side of the 'Equal' operator must be a constant value"

(0) Share

Report

Posted on by lorumIpsum2024

Hello. I am having trouble with one of the formulas that is connected to a button in my app. The first part gathers into a collection a list of tasks that need to be created for a specific shift and day. Once in a collection, I check to see if there are records for that task already in our ShiftTaskResults table, and if there aren't any records for the current day, then they are created. However, when I run the app, I'm getting an error message that says: "The right side of the 'Equal' operator must be a constant value." This error is happening in the LookUp. The error that I am getting says "The right side of the 'Equal' operator must be a constant value." I've tried to replace DateValue(Today()) with a variable that holds the value of DateValue(Today()), but that also did not work. Any help or guidance would be greatly appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Griffin_C 125 on at

Like (0)

Report
Copy link

Link copied!

Are each of the gc_[weekday] meant to be variables? If so, you want to use Set instead of =
So you'd use Set(gc_Sunday,true)

Was this reply helpful? Yes No
lorumIpsum2024 on at

Like (0)

Report
Copy link

Link copied!

These are columns in my table and not variables. It is checking the values in those columns. I fixed the naming and the red error underlines went away. But the error still persists with the Lookup.

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @lorumIpsum2024

Can you post a screenshot of what's inside collection TasksToCreate?

Was this reply helpful? Yes No
lorumIpsum2024 on at

Like (0)

Report
Copy link

Link copied!

I am expecting 2 rows back for the query that I have, but I am not sure where there are question marks in the columns. The values in those columns should be yes or no.

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yes or No?
Or True or False?
They are very different.

In either case, I now need the code you used to create that collection, because something is not right.

Was this reply helpful? Yes No
Verified answer

Griffin_C 125 on at

Like (0)

Report
Copy link

Link copied!
That makes much more sense now. I've found that when two different data sources are nested within functions like that, Power Apps doesn't know which one you're talking about when naming a column or especially when using ThisRecord. Try using the "As" operator in your ForAll function so your data references are more explicit.
For example:
ForAll(TasksToCreate As TASKS,
Then any time you need to reference a column in TasksToCreate within that ForAll function, you can use TASKS.ColumnName.

Was this reply helpful? Yes No