Dataverse trigger filter issue

[MBates87]

Hi,

I'm trying to create a Flow that creates an Outlook calendar entry when a leave request status becomes Approved. I'm having issues with the filter when trying to select rows that have changed Status value to Approved.

This is the Leave Requests Dataverse table I am using

With the Status column details. 

I've noticed there are two Status columns but the one I am interested in is "cdm_Status"

My flow trigger is below - When a Leave Request is modified and the value in "cdm_Status" becomes "Approved"

However, I get an error

{
  "error": {
    "code": "0x80040203",
    "message": "The following filtering attributes are not valid in entity cdm_leaverequest: cdm_Status"
  }
}

Any help would be greatly appreciated.

Thanks.

[MarconettiMarco · Accepted solution]

Hello @MBates87 ,

you need to put the value instead of the label.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

[MBates87]

So Status rather than cdm_Status? Will that not cause an issue with their being 2 Status columns?

[MarconettiMarco]

@MBates87 ,

if you open your field in power apps solution, you can find the value for each label, like below:

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

[MBates87]

Got you, so the value is this nonsense number rather than "Approved"?

[MarconettiMarco]

ok @MBates87 ,

so get the value number without commas.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

.

[MBates87]

It's working! Thank you so much for your help.