Answered

Expressions for Dataverse

(0) Share

Report

Posted on by pirateinnature

Hi Everyone,

New to Power Automate. Just trying to develop a simple flow. When an opportunity is closed as Won (Trigger:Dataverse), the related contacts email address is sent a Customer Voice survey.

I'm guessing since statecode columns are usually choice based, the expression is incorrect. Any resource for learning expressions would be appreciated.

Categories:

Building flows

All responses (3)

Answers (1)

Sort by

v-JessicaG-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @pirateinnature ,

You could try " statecode eq 'Won' " in expressions and write expressions in trigger condition to reduce API calls. The usage of "When a row is added, modified or deleted" action could refer to this document: Trigger flows when a row is added, modified, or deleted - Power Automate | Microsoft Docs

Best Regards,

Jessica Gu
Verified answer

pirateinnature 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-JessicaG-msft ,

Thank you for your response. I'm not sure if the API calls were an issue. I discovered the expression had the wrong syntax for statecode. The following is the correct one
The following is the guide I was informed about by a Microsoft rep.
Cheers!
v-JessicaG-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @pirateinnature ,

I am very glad your problem is solved, , and hope your solution can help more people in the forum.

Best Regards,

Jessica Gu