Automatically create Asset Properties via Microsoft Flow

(0) Share

Report

Posted on by Paul Deemer

Can anyone assist in a Microsoft Flow that automatically creates the 'Asset Properties' of a customer asset? As there is no default way of forcing all the asset properties into the asset, they have to be added manually which is not the best.

Scenario:

Customer Asset has Category set to a value that which has a Property Template assigned.

Flow:

To automatically create a property log on the asset creation for ALL properties related to the template (even if it's blank) so that there is a template filled in already.

It seems crazy that this isn't default and that you they cannot be added automatically with a default value or something similar.

Ideally I wanted to pull product properties to asset properties, but that seems like a separate branch of the flow that is required once the property log is created.

All responses (3)

Answers (1)

Nya 29,060 on at

Like (0)

Report

RE: Automatically create Asset Properties via Microsoft Flow

Hi Paul,

If the issue has been solved, it would be appreciated if you could click "Yes" to verify my answer.

If there is any further doubt, please do not hesitate to let me know.
Suggested answer

Paul Deemer 70 on at

Like (0)

Report

RE: Automatically create Asset Properties via Microsoft Flow

As always Nya, your Dataverse flow explanations are perfectly explained.

Also really helps others understand and use the same method for other functions.
Verified answer

Nya 29,060 on at

Like (1)

Report

RE: Automatically create Asset Properties via Microsoft Flow

Hi,

The property can be found according to the Category in the Customer Asset.

The specific operation process is as follows:

Step1: Determine whether the category has a value; find the content of the Asset Category Template Associations table through the category. Thus, the value of the Property Template is also obtained.

Step2: Then find the content of the Property Template Associations table through the property template. Thereby, the value of property is also obtained.

Step3: Get the ID of the property and assign it according to the Property Type.

When Property Type is “Number”:

When Property Type is “String”:

When Property Type is “Boolean”:

When Property Type is “Date and Time”:

The test results are as follows: