Customer experience | Sales, Customer Insights,...

Lookup Field Text In Power Automate control(condition)

(1) Share

Report

Posted on by sandeepc

5,514

Hi All,

I have a requirment where i need to add a condtion for lookup field in power automate flow contro(condition)

When opportunity status not equal to closed or lost then send update else should not send update

Thanks

Sandeep

I have the same question (0)

All responses (4)

Answers (0)

Sort by

sandeepc 5,514 on at

Like (0)

Report
Copy link

Link copied!

In condition i need to show

if deal status is not equal to close

or

if deal status is not equal to lost

Any suggestions will be marked as verifiec

TIA

Was this reply helpful? Yes No
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi sandeepc ,

Opportunity status?

It's supposed to be of type CHOICE and only have these three options?

Based on the screenshot, you can noticed that option is combined with two parts: Label and Value.

What you need should be the label, right?

Please refer to the following links:

--get choice label in power automate:

https://softchief.com/2021/07/13/get-choice-field-text-in-power-automate-from-microsoft-dataverse-cds/

https://www.encorebusiness.com/blog/power-automate-get-choice-label-metadata/

I hope you can mark my answer verified if it is helpful! If you have any questions, please feel free to contact me.
Regards,
Leah

Was this reply helpful? Yes No
sandeepc 5,514 on at

Like (0)

Report
Copy link

Link copied!

I have a custom entity where i have added these options.

My question is how can i add not equal to expression in filter query

ABC ne Closed or ABC ne Lost

Thanks

Sandeep

Was this reply helpful? Yes No
Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Sandeep,

In the power automate, there is one action--Condition.

You mentioned: expression in filter query?

1)If the field type is choice, you can only use value to make a judgement, because that we can't easily get option label.

--statecode is logic name of this field.

2)If this field is lookup, you need compare it with guid:

Was this reply helpful? Yes No