Unanswered

Query to Dynmaics 365 for Operations SalesStatus

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm would like to query the SalesOrderLine Data Entity from my PowerApp. There is the field SalesOrderLineStatus in the entity.

I can query the valid values using DataSource.AllowedValues, this returns the Values from these enumeration: None, Backorder, Delieverd, Invoiced as expected.

If if use SalesOrderLineStatus in an Filter Formula it only works if i use it as Text(SalesOrderLineStatus). But with this expression Delegation fails. How can use SalesOrderLineStatus in a Filter Expression to work with Delegation?

The same behavour is also in PurchaseLineStatus.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Anra,

From this blog https://dynamics365.wordpress.com/tag/microsoft-powerapps/, we could see that you should be able to query Sales order number, order status, etc. using Entities in PowerApps. Follow the steps there to see if there is anything wrong. Also try to create a new entity/app to test if this is specific issue.

Regards,
Mona

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot Mona, i'm not quite happy with your reply. i'm not sure whether i have to use a CMD data entity.
i connect my PowerApp direct to my Dynamics 365 for Operation datasource and query the available data entities without any CMD between.
if i use CMD, i can create a structure for the entiies, but how do i get the live data queried from my Operations Tenant then to my PowerApp?
Furtermore i see the data entity "Sales Order Line" in CMD is not as wide as i'm used from Dynmaics for Operations Sales Order Line Data Entity.

Was this reply helpful? Yes No