How to do a OnStart with SQL connector and a IF statement

[balys]

Hello All,

I have table Settings - In the table Columns SettingName and SettingValue 

The task is to Run a Screen named ConfigurationScreen if 

• SettingName InitialWizardCompleted
• SettingValue 0

I understand I need to do that on App setting OnStart  whith a IF statement, but I can not my head around it. 

If(

SettingValue.InitialWizardCompleted="0", Did not work

Settings, LookUp( Settings, SettingValue= "InitialWizardCompleted" ), { SettingValue: "0" } Did not work

IF TRUE

Navigate(ConfigurationScreen),

IF FALSE

Navigate(MainScreen))

Please help me. 

[RandyHayes]

@balys 

You will want to do this in the StartScreen property of the app instead of the OnStart.

The formula should be:

If(Coalesce(LookUp(Settings, SettingValue= "InitialWizardCompleted", SettingValue), 0) = 0,
    ConfigurationScreen,
    MainScreen
)

I hope this is helpful for you.

[balys]

The system takes the FX, but tried it on StartScreen as you suggested and OnStart - still the same. 

[RandyHayes · Accepted solution]

@balys 

Navigation in the OnStart is not supported any longer.  This needs to be done in the StartScreen.

When you say "still the same" can you describe what is the same?

[balys]

Ok, understood why not to use OnStart - EOL. 

The Configuration screen still does not come up as before, but SQL database InitialWizardCompleted is set to zero

I updated table by running: 

UPDATE Settings
Set SettingValue= '0'
WHERE SettingName = 'InitialWizardCompleted'

Could it be that I insert text value and the IF statement is looking for a number? 

[balys]

@RandyHayes 

Your command worked when I changed a SettingValue to SettingName

If(Coalesce(LookUp(Settings, SettingValue= "InitialWizardCompleted", SettingValue), 0) = 0,
    ConfigurationScreen,
    MainScreen
)