Customer experience | Sales, Customer Insights,...

SalesOrderDetail_Dynamicpropertyinstance

(0) Share

Report

Posted on by rs-loc

I am trying to the find the entity in the Dynamics 365 Sales dataVerse called salesOrderDetail_DynamicPropertyInstance ... but I am unable to locate it. Does anyone know where this data is stored in the dataVerse

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi rs-loc,

Do you mean Order Line (salesorderdetail)?

Was this reply helpful? Yes No
rs-loc 5 on at

Like (0)

Report
Copy link

Link copied!

No I meant the SalesOrderDetail_Dynamicpropertyinstance entity - It stores the values of any dynamic properties added to the sales order detail line

e.g. where can i find these Sales Order Details - Product Property values?

Was this reply helpful? Yes No
Suggested answer

Haig Liu Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi rs-loc,

It's actually in the "property" table

Was this reply helpful? Yes No
rs-loc 5 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your suggestion - my dataverse doesn't have such a table - This is a list of all the tables that contain the word property in dataverse:

Was this reply helpful? Yes No
Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi rs-loc,

Is this view from Power BI or Visual Studio?

Was this reply helpful? Yes No
Suggested answer

CRMJetty 3,514 on at

Like (0)

Report
Copy link

Link copied!

Hello rs-loc

Could you please check your Form Properties from solution ? may be you would be find Proper Entity and their field.
after that You check with directly from API : https://{crmurl}/api/data/v9.0/{EntityName}

Hope this helps.

Thanks.

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Portal.

Was this reply helpful? Yes No
rs-loc 5 on at

Like (0)

Report
Copy link

Link copied!

This view is from SQL Server - I also have the same view from Azure Data Factory and the Dataverse connector in Excel

Was this reply helpful? Yes No
Suggested answer

rs-loc 5 on at

Like (0)

Report
Copy link

Link copied!
SalesOrderDetail_Dynamicpropertyinstance - While referenced in the dataverse documentation does not appear to exist as an entity.

I have managed to find the data I need in a combination of the following dataverse entities

DynamicPropertyInstance

DynamicPropertyOptionSetValue

However, I could not query the OptionSetValue entity directly from any dataverse tools (PowerBI, Excel, Sql Server etc) as it did not return all of the rows in the entity. When i queried the entity via the Dynamics Web API I was able to retrieve all of the data records in the entity. I am not clear why there is an inconsistency between the dataverse query tools and the Web API. But I have all that I need

Was this reply helpful? Yes No