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 Platform Community / Forums / Power Automate / Expressions for Dataverse
Power Automate
Unanswered

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.

Categories:
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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard