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:

Power Automate

All responses (3)

Answers (0)

shennu 82 on at

Like (0)

Report

Re: CDS Current Environment - Trigger Filter Expression with Lookup field

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

Appreciated
shennu 82 on at

Like (0)

Report

Re: CDS Current Environment - Trigger Filter Expression with Lookup field

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
shennu 82 on at

Like (0)

Report

Re: CDS Current Environment - Trigger Filter Expression with Lookup field

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