Dynamics Community Forum Thread Details

Configurable Regarding Column Canvas Apps

Hello 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

Quick Links