Fill in a variable in a function

[Nico_TW]

Hi,

i want to access a certain column in a SahrePoint list when a certain user is logged in. 

For Example:

If User().Email = "xxx@domain.com" ; list_xxx

If User().Email = "yyy@domain.com ; list_yyy

Is there a way where i can set a variable which checks for the current User().Email and fills in the name of the list.

For Example

If User().Email = "xxx@domain.com ; Set(name ; "xxx")

If User().Email = "yyy@domain.com ; Set(name ; "yyy")

list_name

So that i dont repeat the code and if statement.

Im new to coding and would appreciate better ideas but in my mind that would be the easiest solution.

[WarrenBelz · Accepted solution]

Hi @Nico_TW ,

Unfortunately, you cannot dynamically refer to Power Apps elements such as field names in the context you want to. You would need to hard-code it as you have now.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps