Unanswered

Dataverse trigger not working with row filter

(3) Share

Report

Posted on by PresidentEvil

Hi,

I have built a flow to check the "Approvals" action created by another flow and see if the approval task was reassigned.

But flow is not triggered even after the approval task is reassigned. Initially, when I didn't use the filter rows option, it worked whenever a new approval was created. However, after the 'Filter rows' addition the trigger is not working.

Any help on this is highly appreciated.

Thanks.

All responses (7)

Answers (0)

Suggested answer

CU06080633-1 on at

Like (1)

Report

Dataverse trigger not working with row filter

How to complain against Paytm? Paytm that you can use to file a complaint about a refund issue: Customer Support: 098-31-27-39-10 (available 24/7) You can use any of these channels to reach out to Paytm customer support team and file your complaint as soon as possible.How to complain against Paytm? Paytm that you can use to file a complaint about a refund issue: Customer Support: 098-31-27-39-10 (available 24/7) You can use any of these channels to reach out to Paytm customer support team and file your complaint as soon as possible.How to complain against Paytm? Paytm that you can use to file a complaint about a refund issue: Customer Support: 098-31-27-39-10 (available 24/7) You can use any of these channels to reach out to Paytm customer support team and file your complaint as soon as possible.How to complain against Paytm? Paytm that you can use to file a complaint about a refund issue: Customer Support: 098-31-27-39-10 (available 24/7) You can use any of these channels to reach out to Paytm customer support team and file your complaint as soon as possible.
Rudylar 18 on at

Like (1)

Report

Dataverse trigger not working with row filter

I'm sure you found a workaround Presidentevil, but if that can help others, here is my workaround (it is not a solution to the topic, just a workaround):

- Trigger: trigger WITHOUT any filter

- Get a Row: get this row with the ID from trigger

- Condition: test whatever condition you wanted to as a filter in the trigger

Not the ideal, because it fires a flow cycle, but at least it works.
Rudylar 18 on at

Like (1)

Report

Dataverse trigger not working with row filter

Very similar issue here with CustomerAsset entity. Trying to trig record creation event with a "filter rows" set on a custom field. The Flow starts, but the filter is literally NOT taken in consideration.

Row input below:

{

"host": {

"connectionReferenceName": "shared_commondataserviceforapps",

"operationId": "SubscribeWebhookTrigger"

},

"parameters": {

"subscriptionRequest/message": 1,

"subscriptionRequest/entityname": "msdyn_customerasset",

"subscriptionRequest/scope": 4,

"subscriptionRequest/name": "xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"

}

}
kmartiny 7 on at

Like (1)

Report

Re: Dataverse trigger not working with row filter

I have come across a similar issue with a custom table. Any time I have something in the "Filter rows", the flow registers an error with the trigger action. Something about a type initializer (I copied part of the error message below)? I was able to get around this by using the "old" version of trigger conditions in the Settings of the trigger.

Error message:
System.TypeInitializationException: The type initializer for 'Microsoft.Xrm.Sdk.Data.Mappings.TypeReflector`1' threw an exception. ---> System.ArgumentException: An item with the same key has already been added. at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource) at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add) at System.Linq.Enumerable.ToDictionary[TSource,TKey,TElement](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer) at Microsoft.Xrm.Sdk.Data.Mappings.TypeReflector`1.GetTypeProperties() at Microsoft.Xrm.Sdk.Data.Mappings.TypeReflector`1..cctor()
ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (1)

Report

Re: Dataverse trigger not working with row filter

Hi @PresidentEvil

Pls try turning off-on the flow. Sometimes, the callbacks fail to register.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
PresidentEvil 14 on at

Like (1)

Report

Re: Dataverse trigger not working with row filter

Hi Manish,

Thank you for the solution. I changed the change type from "Added or Modified" to "Modified" but the flow still didn't trigger at all.

I ran another automated flow that includes 'approval', and then reassigned the approval to another user. However, nothing happened even after several minutes post reassignment.
ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (1)

Report
Re: Dataverse trigger not working with row filter

Hi @PresidentEvil

As you have selected the change type as 'Added or Modified' so flow also triggers when a new request is raised with no reassignment. If you want to trigger the flow after reassignment then set the change type to 'Modified' as shown below:

msdyn_flow_approvalrequestidx_reassignedfromid ne '<none>'

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.