CDS Condition of Get Record failing with "Action '' failed"

[eauerbach]

I have a flow which has to be manually triggered from Dynamics CRM. While I've tried to set trigger conditions to only run under certain circumstances, those haven't worked, so I've been trying to use a condition. Here's the setup:

[ManishJain]

Hi @eauerbach ,

Can you please share your flow screenshots to help us update you ?

Thanks

[eauerbach]

Sorry @ManishJain ; there were in the original post but apparently got removed when I posted. Here's the flow:

And the error message:

[v-alzhan-msft]

Hi @eauerbach ,

Please select the same environment in the trigger and the get record action.

And in the Condition to check if a column is equal to null, you should compare if the expression  "empty(column dynamic content)" is equal true.

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[eauerbach]

Thanks for the guidance, @v-alzhan-msft. I'll try that out.

Why am I unable to select 'Current' for the 'When a record is selected' step? Only 'Default' is available.

[ManishJain]

Hi @eauerbach ,

This action is only available in CDS connector and that is the reason you are seeing this.

Thanks

[eauerbach]

@ManishJain so can this not be done? If the environments selected need to be the same, but they selections aren't the same, how can I complete this action?

[ManishJain]

Hi @eauerbach ,

Can you please add Compose Action after when a record is selected and add Opportunity in that input . You do not need to get the same record via another call . This is to avoid confusion while you are selecting values in your conditions step . 

Thanks

[ManishJain]

Hi @eauerbach ,

Default states the current environment where your flow is residing. If you deploy it to UAT / Prod it will point to respective environment. 

Thanks

[eauerbach]

Hi @ManishJain ,

I've removed the Get Record call and inserted the Compose action. I presume I should be incorporating the Compose into the condition; how would that look?

[v-alzhan-msft]

Hi @eauerbach ,

In the Condition to check if a column is equal to null, you should compare if the expression  "empty(column dynamic content)" is equal true.

Best regards,

Alice   

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[eauerbach]

Hi @ManishJain  and @v-alzhan-msft ,

I've attempted to make the recommended changes (switching null to empty(entity), inserting compose action) but am still unable to get the flow to run without error. What other changes can I attempt?

[ManishJain]

Hi @eauerbach ,

Can you please share screenshot where you are getting error and error description.

Thanks

[eauerbach · Accepted solution]

I've been able to resolve the issue. While the option set records needed to be checked for 'empty(entity reference)', Asset needed to be checked against 'null'. Here's the working Condition statement:

Thanks @ManishJain  and @v-alzhan-msft for the guidance.