Answered

Dataverse trigger filter issue

(0) Share

Report

Posted on by MBates237

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.

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report

Re: Dataverse trigger filter issue

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

Was this reply helpful? Yes No
MBates237 97 on at

Like (0)

Report

Re: Dataverse trigger filter issue

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

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (2)

Report

Re: Dataverse trigger filter issue

@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

Was this reply helpful? Yes No
MBates237 97 on at

Like (1)

Report

Re: Dataverse trigger filter issue

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

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (3)

Report

Re: Dataverse trigger filter issue

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
.

Was this reply helpful? Yes No
MBates237 97 on at

Like (1)

Report

Re: Dataverse trigger filter issue

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

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

Like (0)

Report

Re: Dataverse trigger filter issue

Hi There - I am having the same issue, but cannot seem to resolve it. Please could you include a screen shot of the working filter? Thank you for your help. 🙂

Was this reply helpful? Yes No