Dynamic Attributes/Columns?

(0) Share

Report

Posted on by mykedeabreu

I am building an asset tracker and using Dataverse. Since different assets have many different attributes depending on the asset type is there a way in dataverse to store a dynamic structure almost like a "No SQL" approach where I determine what to write based on the asset? Or do I have to bite the bullet and have a really wide Asset Table covering many different attributes?

I currently have 15 or so Asset Types to track and its putting me close to 75 columns as some assets are vehicles where others are buildings etc.

I have the same question (0)

All responses (5)

Answers (1)

Nya 29,060 on at

Like (0)

Report

Hi,

Are you using the following feature?

Integrate Dynamics 365 Field Service and Supply Chain Management | Microsoft Docs

Was this reply helpful? Yes No
mykedeabreu 99 on at

Like (0)

Report

No I am not. I was going to do this with custom tables then using a Model Driven or Canvas Power App.

Was this reply helpful? Yes No
Nya 29,060 on at

Like (0)

Report

Hi,

So would you please specify which application you are using in Dynamics?

Was this reply helpful? Yes No
Verified answer

Bipin D365 28,983 Moderator on at

Like (1)

Report

Hi,

You could create Text field with Format as JSON field type and store the data based on your assest type.

But this will not be helpful in your reporting and search.

We have other data types in Dataverse which can point to multi entities -

1. Customer Data type - Account/Contact

2. Polymorphic Lookup - Can point to multiple Entity lookup

Another point you have keep in your mind is Fields in Dataverse is type safe meaning it can only store what is intended to store.

Hope this helps!

Please mark my answer verified if this is helpful!

Regards,

Bipin Kumar

Follow my Blog: xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No
mykedeabreu 99 on at

Like (0)

Report

Polymorphic Lookup!

Was this reply helpful? Yes No