web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Expressions for Dataverse

(0) ShareShare
ReportReport
Posted on by 8

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.

pirateinnature_0-1641861747960.png

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

I have the same question (0)
  • v-JessicaG-msft Profile Picture
    on at
    Re: Expressions for Dataverse

    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

    vJessicaGmsft_0-1642139741482.png

     

    Best Regards,

    Jessica Gu

  • Verified answer
    pirateinnature Profile Picture
    8 on at
    Re: Expressions for Dataverse

    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 

    pirateinnature_0-1642460448586.png

    The following is the guide I was informed about by a Microsoft rep.

    pirateinnature_1-1642460550677.png

    Cheers!

     

  • v-JessicaG-msft Profile Picture
    on at
    Re: Expressions for Dataverse

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 788 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 452 Moderator

#3
developerAJ Profile Picture

developerAJ 302

Last 30 days Overall leaderboard