Issues Setting Global Variable

(0) Share

Report

Posted on by AGS94

197

I had posted this issue previously and thought it was solved, but I am still having problems.

I have the following formula in the OnSelect of the next arrow of a gallery (FavProd😞

Select(Parent)
;If(FavProd.Selected.ChkF=Lower("false"),Set(VarChkF,false),Set(VarChkF,true))
;Navigate(Mixing,ScreenTransition.Fade)

I have tried setting FavProd.Selected.ChkF equal to:

false
"false"
Lower("false") (as shown above. This was out of desperation to find a solution)

To help troubleshoot, I have two text labels - one with FavProd.Selected.ChkF, (results in false, which is correct) the other with VarChkF (results in true no matter what I have tried).

Side note: I have a total of three occurances of setting VarChkF in the app. In addition to the one above, the other two occurances set VarChkF to false via (Set(VarChkF, false)).

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

mdevaney 29,989 Moderator on at

Like (0)

Report

@AGS94
What does the table in your datasource look like? Could you please share a screenshot?

Was this reply helpful? Yes No
AGS94 197 on at

Like (0)

Report

Here your go. Note that all formulas referecning the various column values are working as expected in the gallery's NextArrow1.OnSelect except the Chk"x"s (B thru F).

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

deleted post

Was this reply helpful? Yes No
AGS94 197 on at

Like (0)

Report

Actually I only have one favorite saved thus far (shown in row 8 of the Excel worksheet pic) - the blank rows are not part of the actual Excel table that my app is referencing. So far the only rows in the table are rows 7 and 8 and those are the only rows the app is actually referencing. As I save a favorite, a new row will be added to the Excel table and the app will then be able to reference that new row as well.

The way I have it set up is when a new favorite is saved, ChkB through ChkF will always either be true or false. I have verified via a text label that FavProd.Selected.ChkF does indeed return false as is shown in Cell V8. Also verified, for example, that FavProd.Selected.ChkD returns true as shown in Cell T8.

That said, if I do as you suggest, wouldn't the result always be true? My apologies if I am missing anything.

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@AGS94
I deleted my latest post right before you posted back. I was looking at the column called ItmF instead of ChkF. That’s why my response did not make any sense.

Please do two more things for me.
1. Click on cell V8. Take a screenshot. Let me see what is in the Excel formula bar.
2. Try the formula =TYPE(V8) on a blank cell in your spreadsheet. This will return a number that tells us the data type. Let me know the result.

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@ASG94
You might also want to try replacing lower(“false”) with upper(“false”)

Was this reply helpful? Yes No
AGS94 197 on at

Like (0)

Report

Screenshots below. No formula in V8, just text (as shown). I clicked on the cell to get the Type and also keyed in TYPE(V8). Both returned "4" (shown in Cell C2)

I also tried "Upper" and still the same results.

This seams to be a simple formula. No idea why the trouble. Thanks for sticking with me on this one.

Was this reply helpful? Yes No
Verified answer

mdevaney 29,989 Moderator on at

Like (1)

Report

@ASG94
I was finally able to test on a computer. You want to compare against the value “False”. First letter is uppercase and the rest are lowercase.

Select(Parent)
;If(FavProd.Selected.ChkF=“False",Set(VarChkF,false),Set(VarChkF,true))
;Navigate(Mixing,ScreenTransition.Fade)

—
Please Accept as Solution if this post answered your question so others can find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

Was this reply helpful? Yes No
AGS94 197 on at

Like (0)

Report

It worked! I owe you a virtual beer. Thanks for all the help!

Was this reply helpful? Yes No