Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Query to Dynmaics 365 for Operations SalesStatus

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.

Community Support Team
Community Support Team

Re: Query to Dynmaics 365 for Operations SalesStatus

Hi Anra,


From this blog, 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.




Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level: Powered On

Re: Query to Dynmaics 365 for Operations SalesStatus

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.

Helpful resources


Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Power Platform World Tour

Coming to a city near you


PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 84 members 3,834 guests
Please welcome our newest community members: