Answered

Choice Column Formula

(0) Share

Report

Posted on by David8

I have an app with multiple choice columns and they all seem to be working. However, every time I open the app, I get a red x indicating there is a problem. When I delete the last closed parenthesis and replace it with the same exact closed parenthesis, the red x goes away. Just curious if anyone knows what would cause this to occur.

Here is an example.

Choices([@'Customer Intake Form'].CIFRequestor)

I remove the last ")" and re-replace it with ")" and the problem is solved.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Pstork1 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I've seen this too, but running the app will also clear up the issue. I suspect it happens because the Choices come from the data source, but the data source isn't loaded until you try to access the data. That happens when you edit the Choices line or actual access the data source in the application. I haven't found a way to fix this, I just live with it.
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

@David8

This is a runtime error and not a formula error. You can safely ignore it when you see it. It only has to do with the timing of the datasource loads and the formula evaluations in the designer.

The reason that when you "change" the formula to the same and it goes away is that the datasource is now loaded and the formula will re-evaluate because you changed it. And, since the datasource is now "ready" it evaluates just fine.

I hope this is helpful for you.
David8 89 on at

Like
a
(0)

Report
Copy link

Link copied!

Makes perfect sense. Thanks, Randy.