Error with Flow - Dataverse Row Lookup

(3) Share

Report

Posted on by Haggis67

Hi There,

Bit new to the community so be gentle on me.

I'm having issue with a flow erroring. The flow is meant to be called by an agent - collect a date range and then lookup a Dataverse Table and return rows that match a query.

Logically it looks like this:

Flow initiated by agent/Agent Calls the flow

Input - StartDate - Text
Input EndDate - Text

Compose - StartDate DateOnly(Format Date for Dataverse Table Data Type)
Expression: formatDateTime(triggerBody()?['StartDate'], 'yyyy-MM-dd')

Compose - EndDate DateOnly(Format Date for Dataverse Table Data Type)
Expression: formatDateTime(triggerBody()?['EndDate'], 'yyyy-MM-dd')

Dataverse - List Rows

Table Name : Driver Deliver Reports
Select Columns: crb3e_connotenumber,crb3e_dateshort,crb3e_deliveredqty,crb3e_receiversignatory,crb3e_receiver,crb3e_suburb,crb3e_serv
Filter Rows:
crb3e_dateshort ge @{outputs('StartDate_DateOnly')}
and crb3e_dateshort le @{outputs('EndDate_DateOnly')}
and crb3e_deliveredqty eq 0

Filter Array

Input - Value - outputs('List Rows')?['body/value']

Edit in Advanced - contains(item()?['crb3e_receiversignatory'],'LPO/')

Error: Flow save failed with code 'WorkflowRunActionInputsInvalidProperty' and message 'The 'inputs' of workflow run action 'Filter_array' of type 'Query' is not valid. Property 'where' must be a template language expression.

Any feedback is appreciated, been stuck on tis for a while now.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

trice602 16,298 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi there!

Add the '@' to your contains.

@contains(item()?['crb3e_receiversignatory'], 'LPO/')

------------------------------------------------

⭐ If this was helpful, please like and check the box below "Does this answer your question" to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!
For the Filter Array action, try:

@contains(
coalesce(item()?['crb3e_receiversignatory'], ''),
'LPO/'
)

Also verify that:

The From property is set to:

outputs('List_Rows')?['body/value']

The advanced expression starts with @.

The internal action name matches the actual List Rows action name.

Based on the error message, the most likely root cause is that the Filter Array advanced condition is not formatted as a valid template expression, or the expression is missing the required @ prefix.

Was this reply helpful? Yes No
Suggested answer

Haque 3,653 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Haggis67,

The curx point in the error description is "template language expression" in the error 'inputs' of workflow run action 'Filter_array' of type 'Query' is not valid. Property 'where' must be a template language expression.

Change your Filter Array advanced mode expression to:

@contains(item()?['crb3e_receiversignatory'], 'LPO/')

The "@" symbol tells Power Automate to treat the expression as a formula.

Note: Please make sure the Compose actions StartDate_DateOnly and EndDate_DateOnly are named exactly as referenced in the filter query of your Dataverse List Rows action.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No