Dynamic gallery item from string

(0) Share

Report

Posted on by td1979

157

Hello,

I am using the following formula to set a variable that is used in the item property of a gallery, however the following code requires me to manually add a case for a new client

Switch(
 ClientDropDown.SelectedText.Value;

 Text("CLIENT_1");
 Set(varClient;CLIENT_1);
 
 Text("CLIENT_2");
 Set(varClient;CLIENT_2)

 Text("CLIENT_N");
 Set(varClient;CLIENT_N)

 )

I have been trying to set the variable directly from the selected value (therefore avoiding having to make manual changes if a new client gets added)

for example:

Set(varClient;ClientDropDown.SelectedText.Value)

This will set the variable, however it is text and the variable can then not be used as the item source.

Can anyone suggest a way I can get the functionality of the above switch code but without having to hardcode the clients?

Thanks in advance

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @td1979 ,

I am not entirely clear why

Set( varClient; ClientDropDown.Selected.Value )

is not doing what you need (the text would be the client's name I suspect) - what is it exactly you are trying to set ?
td1979 157 on at

Like
a
(0)

Report
Copy link

Link copied!
thanks for your help/time

I have a collection of client names that correspond to data connections in the app.

i.e.

Set( varMyDataConnectionName; ClientNameThatCorrespondsToACollection.Selected.Value )

dependant dropdowns and galleries work fine if I use switch and hardcode
Verified answer

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @td1979 ,

Unfortunately, you cannot refer to a Variable/Collection name with another Variable (without hard-coding)

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.

MVP (Business Applications) Visit my blog Practical Power Apps