Unanswered

How to access ThisRecord Dynamically ex ThisRecord.variable (variable is subjected to change and will be definitely available in ThisRecord) in canvas app

(0) Share

Report

Posted on by harshakurakula

Below is the code which i need to modify to make it dynamic, such that if User selects "Teams" table, then "Teams" associated primaryKey(variable), createdon, createdby, modifiedon and modifiedBy column data should be accessed and stored in tempTable. (Assume that all the mentioned columns are available in both/all tables)

If(Self.Selected.Value="Teams",Set(entityName,Teams),Set(entityName,Contacts));
ForAll(
entityName,
Collect(
tempTable,
{
name: ThisRecord.name,
createdOn: ThisRecord.createdon,
creatdBy: ThisRecord.createdby,
modifiedOn: ThisRecord.modifiedon,
modifiedBy : ThisRecord.modifiedby
}
)
);

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,763 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @harshakurakula ,

You cannot refer to data sources or field names (among other things) dynamically in Power Apps - you need 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.

MVP (Business Applications) Visit my blog Practical Power Apps
harshakurakula 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @WarrenBelz for your quick response
mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

Although it would be ugly and loooong code you could do this with a switch statement I think.

Switch(UserSelection,
"Teams",
ForAll(entityName, Collect(tempTable,
{
name: ThisRecord.name,
createdOn: ThisRecord.createdon,
creatdBy: ThisRecord.createdby,
modifiedOn: ThisRecord.modifiedon,
modifiedBy : ThisRecord.modifiedby
}));,
"OtherOption",
ForAllPatchForThisOption,
"OptionThree",
ForAllPatchForThisOption
)

The switch can invoke whatever data source you need based on the user input and then since the columns will match you can just throw them all in the same collection for each case in the switch statement. Not 100% sure this will work for you situation but all I can come up with off the top of my head.
harshakurakula 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @mmollet for your response. i will try this