Retain Exit Settings for Next OnStart

[Phineas]

I have a main screen that has a series of buttons that allow for users to navigate through the app.

I have a toggle (Toggle1). I use the toggle to shutdown access to the site through the buttons referenced above.

The default setting of Toggle1 is 'true'. If for some reason the owner wants to limit access to the site for a period of time the owner can set Toggle1 to 'true' and all of the site buttons will default to 'Disabled'.

My issue, if the owner sets Toggle1 to off and then exits the site, when the owner returns the Toggle has reset to 'false' and all the button are back to 'Edit'.

How do I set it up so that the setting of Toggle1 is how the site open during the next viewing?

[BCLS776]

There are a couple of ways to handle this:

1. Save those settings to a backend, such as a Sharepoint list. Read them back in during OnStart
2. If you are using mobile apps only, you can save a collection for use at a future time using the Savedata and Loaddata functions. This functionality doesn't work for web browsers, though.

Hope that helps,

Bryan

[Phineas]

Thank you for your reply.

Yep, while I was typing the question it came to me to simply make a List, Patch to the List on Toggle1 change, then pull it back in through a Collection at OnStart, and set the Toggle1 default to Self...something, is that about right?🤔

[BCLS776]

The details will vary a bit depending on the exact needs of your app, but you've the basics. Personally, I prefer to use a Lookup rather than load the settings back into a collection. 

Bryan

[Phineas]

It is my understanidng that you can't query Lookup columns in Power Apps? Or, is that calculate columns?

Please do tell; how can I solve this kunundrum?

[BCLS776]

Sorry, I wasn't clear. I don't use a lookup column; I use a LookUp() function to pull the desired values back out of a SharePoint list.

[Phineas]

If you have an example can you share.

I am not understanding how a many to one relationship work in a Lookup() function.

Again, there may be one or may items associated with one Location on the 'List1'.

That same location only appears once on 'List2'.

If any one item in the table from the 'List1' in "Noncompliant" then that same location on 'List2' needs to be set to "Noncompliant".

[BCLS776]

I have an example for you using a Sharepoint list. These columns get set through a Patch as necessary. This one uses the User().Email as a unique ID for lookups:

In the OnStart of the app that uses this table, I have a few simple lookups to set some variables in the app:

Set(varVisible, LookUp(UserSettings, AppUserName = User().Email).varVisible);
Set(dispToggle, LookUp(UserSettings, AppUserName = User().Email).dispToggle);
Set(defaultLocation, LookUp(UserSettings, AppUserName = User().Email).defaultLocation);

Bryan

[Phineas]

I'm using a flow.

This looks like you are doing everything in Power Apps, is that correct?

If you are using a flow how would I make this happen in a flow?

[BCLS776]

You started this thread asking about doing this with an app, but now you want to use a flow? That's puzzling - are you confusing this with another thread?

I wouldn't use a flow to accomplish the task you originally described.