cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
troyhoskison
Helper I
Helper I

How do I reference a dynamic content in an expression

Hi,

 

My google-foo is failing me.

 

In power Automate I want to update a field in a Dataverse table based on values in the fields on the record. I have work out how to do most of it, but I can't for the life of me work out one small part which should be really easy.

 

I need to know how to reference the field from my dataverse table in my expression.

 

I can see that the field is there in the dynamic content, but I can't drag the dynamic content in the expression because they both use the same window. I can't find the syntax anywhere. I can see example from Sharepoint, from variables, but not Dataverse table.

 

thanks

 

Troy

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
dpoggemann
Super User
Super User

Hi @troyhoskison,

 

As you are building the expression you can click on the other tab for the dynamic content and add the field to your expression, when you select the field it fills it into the expression.

 

Example on the one below I did the following:

1.  Clicked Expression and typed in the function Concat('Cool ', 

2.  I think clicked on "Dynamic content" and selected the "Account Name" field

3.  It completed the expression to:  

Concat('Cool', triggerOutputs()?['body/name'])
 
dpoggemann_0-1619023784648.png

 

 
Hopefully this helps!
 
Please accept if answers your question or "Like" if it helps in some way.
 
Thanks,

Drew

 

  

View solution in original post

2 REPLIES 2
dpoggemann
Super User
Super User

Hi @troyhoskison,

 

As you are building the expression you can click on the other tab for the dynamic content and add the field to your expression, when you select the field it fills it into the expression.

 

Example on the one below I did the following:

1.  Clicked Expression and typed in the function Concat('Cool ', 

2.  I think clicked on "Dynamic content" and selected the "Account Name" field

3.  It completed the expression to:  

Concat('Cool', triggerOutputs()?['body/name'])
 
dpoggemann_0-1619023784648.png

 

 
Hopefully this helps!
 
Please accept if answers your question or "Like" if it helps in some way.
 
Thanks,

Drew

 

  

View solution in original post

I knew there had to be an easy way of doing it.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,701)