Change User USERSETTINGS

Hi,

I have an application with partition capabilities and I set the condition to be the country of the user. My question is, can I input initial values for “Country Option” in USERSETTINGS table for each user manually? I want to do that to force them into using the partition meant for their country only.

Thanks for your support!

Yes you can set stuff in USERSETTINGS()

Simon@1minManager.com

2 Likes

I know how to set them up, but I do not know how to choose their values for certain users. For example, I want Jone to be on partition for Country USA from first login, how can I do that as an Admin?

So you need an app user table where you have at least [Login Email] and [Country]. Then you Usersettings formula will be something like

ANY(Select(UserTable[Country],[Login Email]=UserEmail()))
2 Likes

Hi @Hattan_Hamoud

In addition to what @1minManager said, you also may want to use this expression:
LOOKUP(USEREMAIL(), “UserTable”, “Login Email”, “Country”)
(which is strictly the same)

2 Likes

This make so much sense, it is working now!

Thanks a lot for your quick support everyone. Much appreciated.

3 Likes