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()
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()))
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)
This make so much sense, it is working now!
Thanks a lot for your quick support everyone. Much appreciated.
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |