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:
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)).
Solved! Go to Solution.
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.
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.
FIll out a quick form to claim your community user group member badge today!
The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!