Power Automate

Create record in dynamic f&o in AssetConditionTableEntity fails: Object field requires Int64 RecId

(0) Share

Report

Posted on by CU13101239-0

Hi,

I'm trying to create a record in Dynamics 365 F&O using Power Automate
(Fin & Ops connector) from a SharePoint list.

Entity: AssetConditionTableEntity
Field: Object (type: Int64, Nullable=False)

The error I get:
"A null value was found for the property named 'Object',
which has the expected type 'Edm.Int64[Nullable=False]'"

OR:
"Matching record with key 'Object': 5637145417
for the data source 'FunctionalLocationObject' does not exist"

My situation:
- SharePoint has the ObjectID as text (e.g. "SL-30")
- The Object field in the entity requires the RecId (Int64) not the text ID
- I tried using Lists items present in table on AssetsRentPrices
to get FunctionalLocation_FunctionalLocationId
- But I cannot find a way to get the RecId of the Object

Questions:
1. How can I get the RecId of an Asset Object using Power Automate?
2. Which entity should I query to get the RecId by ObjectID?
3. Is there a better approach to populate Object lookup fields
in AssetConditionTableEntity from SharePoint?

Thank you

I have the same question (0)

All responses (3)

Answers (0)

Sort by

André Arnaud de Cal... 679 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Can you provide a description how the flow is configured? Do you know if the entity you used is a custom data entity in Dynamics 365 F&O? Usually, RecID reference fields are replaced by the natural key fields in an data entity.

Was this reply helpful? Yes No
CU13101239-0 54 on at

Like
a
(0)

Report
Copy link

Link copied!

@André Arnaud de Calavon

Hi André,

Thank you for your response.

Flow configuration:
- Trigger: When an item is created (SharePoint)
- Step 1: Lists items present in table (AssetsRentPrices)
filter by ObjectID to get FunctionalLocation_FunctionalLocationId
- Step 2: Create record in AssetConditionTableEntity

The entity AssetConditionTableEntity is a custom entity

The field "Object" in this entity requires Int64 (RecId).
I have the ObjectID as text (e.g. "SL-30") in SharePoint.

When I query AssetsRentPrices by ObjectID, I get:
- ObjectID: "SL-30"
- FunctionalLocation_FunctionalLocationId: "1023009"
- ItemInternalId: (GUID)

But no RecId is returned.

Is there a specific entity I should query to get
the RecId of the Object by its ObjectID (e.g. SL-30)?
Or should the natural key be used instead of RecId
for this field?

Thank you

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 679 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

In this case, the issue is with your custom data entity. The whole concept of data entities is to make the communication independent of record ID references. A developer should replace the record ID reference field for the object with the natural value of the object, like you have stored in your SharePoint list. This is how all data entities are developed in the standard application.

As example: The EcoResReleasedProductV2Entity has a string value for the Product field where in the InventTable this product is a record ID reference field. Ensure the data entity is developed as per best-practices and let the entity resolve the Record ID value required for an object.

Was this reply helpful? Yes No