It sounds like you want to have certain default dropdown choices appear for specific users?
If so, make a table similar to the one in your original post with the user's email and then columns for each dropdown's default value. Then, your app can use a LookUp() based on User().Email to pull in the correct default value. For example, in the Default property of Dropdown1 you could put:
LookUp(dropdownTable, user = User().Email, Dropdown1)
// where dropdownTable is the table of dropdown defaults stored by user email
// user is the column with the user emails
// Dropdown1 is the column containing the desired default value to use for Dropdown1 in the app
Hope that helps,
_________________________________________________________________________________________ Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.