cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MrNguyen
Helper I
Helper I

Dataverse Odata Filter for Annotations

Hi All.

 

I have test flow that I want to retrieve Approvals data from an entity in DataVerse. I want to filter the records for where approvals are still "Pending" or "Active". I have this flow that runs successfully and returns the correct values that I want:

MrNguyen_0-1619721974363.png

 

Looking at the response JSON, I might want to filter on a value that may be perceptively stronger:

 

MrNguyen_1-1619722057505.png

 

Is there a way to filter the data for the Odata.Community.Display.V1.FormattedValue where either statecode or statuscode is "Pending" or "Active"?

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User II
Dual Super User II

@MrNguyen

If you want to filter on state code or status code use below:

statecode eq 0

statuscode eq 133377

You can do or/and between conditions as well.

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

4 REPLIES 4
Mira_Ghaly
Dual Super User II
Dual Super User II

@MrNguyen

If you want to filter on state code or status code use below:

statecode eq 0

statuscode eq 133377

You can do or/and between conditions as well.

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

Thanks Mira! Do you happen to know the code for Canceled and Complete? 

Mira_Ghaly
Dual Super User II
Dual Super User II

Hi @MrNguyen 

Completed:192350004

Canceled:192350006

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
MrNguyen
Helper I
Helper I

Thanks so much!

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,157)