CDS Current Environment - Trigger Filter Expression with Lookup field

(0) Share

Report

Posted on by shennu

So I have a flow that I want it to only run when the lookup field currency (transactioncurrencyid) is equal to USD.

It works fine when I use the "_transactioncurrencyid_value eq {GUID}" in the Filter expression.

Where GUID is the USD currency record GUID.

Clearly we will have an issue here, that is if I take the flow into another environment or if the currency data every gets recreated... the GUID will change and then the Flow will not get triggered until I update the Filter Expression.

Currently what I have done is instead of using the filter expression and I am using the "Get Record" in order to check the selected currency is in fact USD. Otherwise, don't do anything...

But still I wonder, if it is even possible test a lookup field text instead of the GUID in the Trigger Filter Expression...

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

shennu 82 on at

Like (0)

Report
Copy link

Link copied!

Jay,
Thanks.
Sorry if I wasn't clear enough in my initial post, but what I am really after here is if it's possible to test the text value of the lookup field directly in the Filter Expression instead so the Flow will not get trigger at all.
Any ideas?
Xun

Was this reply helpful? Yes No
shennu 82 on at

Like (0)

Report
Copy link

Link copied!

Thanks again for giving the details with extra action steps by using Parse Json ...

So in the other word it is Not Possible to filter use the Filter Expression on the Trigger itself by a lookup field text instead of the value,
Correct?

If you confirm the above for me that would be brilliant.
Many thanks adv

Was this reply helpful? Yes No
shennu 82 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the confirmation re it is not possible to do such thing on the Trigger itself...

Appreciated

Was this reply helpful? Yes No