How to collect to a dynamic connection

(0) Share

Report

Posted on by nagestiada

504

Hello guys I want to make the connection of the patch a variable; is it possible?

Set(varAOAConnection, "AOA");

Patch(varAOAConnection,
LookUp(varAOAConnection,QuestionIndex=Value(QuestionIndexLabel.Text) && Language="EN"),
 {
 QuestionValue: TextInput2_8.Text
 }
)

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @nagestiada ,

Short answer no - you cannot refer to data sources dynamically. You would have to hard-code it all.

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
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @nagestiada ,

In PowerApps, the data source you update must be a constant, not a variable. Or you can try this:
Update different data sources based on the value of variable.
Switch(var, "AOA",Patch(datasource1, LookUp(datasource1,QuestionIndex=Value(QuestionIndexLabel.Text) && Language="EN"), { QuestionValue: TextInput2_8.Text } ), “BOB”,Patch(datasource2, LookUp(datasource2,QuestionIndex=Value(QuestionIndexLabel.Text) && Language="EN"), { QuestionValue: TextInput2_8.Text } ),…)

Best regards,
Rimmon Li