Share
ReportHello Everyone,
Hope you're doing okay.
I am currently working on a Canvas App, In the Canvas App we are creating OOB Task records.
There is a field in OOB Tasks named Regarding. The regarding column is a lookup that contains all the records of all the Tables.
For the Data-source of Drop-Down of Regarding in Tasks Form, I am using a Collection.
Some tables that we require are being collected in this Collection
i.e. ClearCollect(colRegardingColumnValues, Accounts, Contacts)
I've got a requirement to make this merged collection configurable. We want to collect all the tables which are stored in a configuration record in the form of "account,contact".
I understand that in canvas apps Collection we cannot give logical names as parameters for the collection to collect.
I've tried many methods but still no luck.
For Example:
Storing the datatypes of all tables in a collection and using them in a loop to collect all the table available in the coma seperated configuration.
ClearCollect(colTableNames, {Name: "account", Value: account }); //where account is of data type Table.
ForAll(Split("account,contact",","), Collect(colRegardinColumnValues, LookUp(colTablesNames, ThisItem.Name = Name ) .Value ) )
But this also did'nt work.
I want to know if someone has done it before. Or is it even achievable. I'm kinda stuck here. Any help would be appretiated.
Thanks
All responses (
Answers (
181
