Answered

PowerApps gobal variable returns blank when using IF or Switch statement

(0) Share

Report

Posted on by nramirez03

Hi!

I'm having some trouble with a global variable. When I try to set the value using an IF or a Switch statement, it'll return blank. I have different user access levels. When a user opens the app, I lookup the user's email in a table and find the access level (varAccessLevel) (1 for region level and 2 for district level) and the location ID (varTransitNumber). I need to setup the variable varRegionTransitId. If the access is at Region level, varRegionTransitId should be the same as varTransitNumber. If it's district level, then I need to search on another table for the region ID.

I'm attaching some screenshots of this. Here, when looking at the Switch statement, it shows that it evaluates it correctly (first image), but when looking at the variable, it displays blank (second image). Hope someone can help. Thanks!

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Where is varTransitNumber being set? I setup a test with this same formula and had no issues. You need to make sure that varTransitNumber has a value before setting your varRegionTransitID
nramirez03 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your reply! It's all been done in the app OnStart. In lower part of the images I attached, on the first one I show what happens when clicking on the switch function, it evaluates correctly (giving 12153 as the result). I attach it again with the result highlighed in yellow. On the second one, when clicking on varRegionTransitID it shows blank.
JR-BejeweledOne 5,836 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

In the App OnStart the order of things is crucial, otherwise it can get flaky. I don't know what all you have running in your App Onstart and if you are using the Concurrent function.

I have run into issues when I have a lot of things happening in the OnStart. Can you trigger it from somewhere else, like the OnVisible of a screen just to see if it behaves differently?
Verified answer

nramirez03 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks again for your reply! It looks like the issue was because of a calculated column in the data sources which I used to lookup a value for a previous variable. Thanks again for your help. I really appreciate the time you took to help me!