Power apps building flow

[PakN4Z]

Hello,

I am  new to power apps and this is what I try to do.

I am trying to make flow: When a row added, modified or deleted check collumn cre4a_column9 (name of collumn "BROKEN") if value in column found "L" then post message using teams private chat with flow bot to recipient in message include specific row data.

My error: 

{
"error": {
"code": "0x80040203",
"message": "Exception parsing cre4a_column9 eq L submitted for attribute filterexpression of callback registration. Target entity: cre4a_tool_data. Exception: Microsoft.OData.ODataException: Could not find a property named 'L' on type 'CallbackRegistration.cre4a_tool_data'.\r\n at Microsoft.OData.UriParser.EndPathBinder.GeneratePropertyAccessQueryForOpenType(EndPathToken endPathToken, SingleValueNode parentNode)\r\n at Microsoft.OData.UriParser.EndPathBinder.BindEndPath(EndPathToken endPathToken)\r\n at Microsoft.OData.UriParser.MetadataBinder.Bind(QueryToken token)\r\n at Microsoft.OData.UriParser.BinaryOperatorBinder.GetOperandFromToken(BinaryOperatorKind operatorKind, QueryToken queryToken)\r\n at Microsoft.OData.UriParser.BinaryOperatorBinder.BindBinaryOperator(BinaryOperatorToken binaryOperatorToken)\r\n at Microsoft.OData.UriParser.MetadataBinder.Bind(QueryToken token)\r\n at Microsoft.OData.UriParser.FilterBinder.BindFilter(QueryToken filter)\r\n at Microsoft.OData.UriParser.ODataQueryOptionParser.ParseFilter()\r\n at System.Web.OData.Query.FilterQueryOption.get_FilterClause()\r\n at Microsoft.Crm.ObjectModel.EdmModelEvaluator.EvaluateFilterExpression(String filterExpression, ODataQueryOptions queryOptions)\r\n at Microsoft.Crm.ObjectModel.EdmModelEvaluator.EvaluateFilterExpression(String filterExpression)\r\n at Microsoft.Crm.ObjectModel.CallbackRegistrationService.<>c.<.cctor>b__67_0(EdmModelEvaluator evaluator, String testValue)\r\n at Microsoft.Crm.ObjectModel.CallbackRegistrationService.ValidateInputEntity(IBusinessEntity entity, ExecutionContext context, IFeatureDetailContainer featureDetailContainer)"
}
}

[StretchFredrik]

Do the filter like this in your trigger:

cre4a_column9 eq 'L'

[PakN4Z]

It seems it helped, now it works.

In message I would like to include data from ROW the value L was found what code should I place?

[StretchFredrik]

Depends what column value you want there. Hard to say without knowing the dataverse database structure. 

[PakN4Z]

My database structure:

My cre4a_column9 is 'BROKEN'

When it find value 'L' on newly added row.

Post teams message including same row data from columns cre4a_tools (TOOLS) + cre4a_Column2 (NAME) + cre4a_Column2 (Frezavimo min.)

[StretchFredrik]

Should be something like this but it may vary, i would need to see the JSON output from the trigger to give you a more exact answer:

triggerBody()?['TOOLS']
triggerBody()?['NAME']
triggerBody()?['Frezavimo_min.']

If this solved your issue please mark the post as Solved. 
Also, if you appreciated my answer, don't forget to give it a Thumbs Up 😃

[PakN4Z]

What wrong did I do?

Message in teams looks like this:

[StretchFredrik]

They need to be created as expressions:

See this link: Use expressions in flow actions | Power Automate Blog (microsoft.com)

[PakN4Z]

Chat is empty something wrong with expression.

[StretchFredrik]

Could you please provide me with the JSON from the trigger? The outputs from a previous run.

[PakN4Z]

Not sure if this that output you requested. If not please let met know where to find it.

[PakN4Z · Accepted solution]

I found the problem the code should have been like this:

triggerBody()?['cre4a_tools']
triggerBody()?['cre4a_column2']
triggerBody()?['cre4a_column9']