Patch to different datasource depending on a variable

[Anonymous]

Hi,

I would like the information collected by my app to be written to a specific datasource depending on which user is logged in.

Currently, I am using:

'If(User().Email = "...",Patch(...' etc.

but with over 20 distinct users this is not ideal.

I have tried unsucessfully to Set a dynamically named  variable by Concatenating and then:

Patch(variablename,

or

Patch(Text(variablename),

etc.

Any help with Patching to dynamic datasources would be appreciated.

Thanks,

David

[WarrenBelz · Accepted solution]

Hi @Anonymous ,

 You cannot refer dynamically to a data source, control or field in Power Apps, so you will have to hard-code it.

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.

[Anonymous]

That's a pity. Thanks for the reply.