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.
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).
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.
Check out the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021
Check out the Power Platform Community Highlights