Answered

Expand Query Syntax

(0) Share

Report

Posted on by BagOTricks

The DepartmentOrders table has a lookup to the Departments table. I'm using the list rows command with a filter (to gather data from last 7 days) and attempting to expand the query so that I can reference the department name. While building the flow it appears to work fine as I can reference Department DeptName from the dynamic content (see Create Order List below) but when I run the flow I get a "could not find a property" error message. I feel like I'm very close but missing some vital piece of the puzzle.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sundeep_Malik 6,497 on at

Like (0)

Report
Copy link

Link copied!

Hey @BagOTricks
Not sure but try this:
Column name eq 'Value'
Above what you have written looks fine just write braces beside the expression.

Was this reply helpful? Yes No
BagOTricks 23 on at

Like (0)

Report
Copy link

Link copied!

I don't think I understand what you're saying. Try Column name eq 'Value' where? Braces beside which expression?

Was this reply helpful? Yes No
Sundeep_Malik 6,497 on at

Like (0)

Report
Copy link

Link copied!

@BagOTricks
You have used addDays expression there, beside that use braces.

Was this reply helpful? Yes No
BagOTricks 23 on at

Like (0)

Report
Copy link

Link copied!

Can you explain your reasoning? The addDays part of that works fine. It's the Expand Query that I can't make work. Are you saying that the filter rows expression is impacting the Expand Query? In what way?

Was this reply helpful? Yes No
Verified answer

BagOTricks 23 on at

Like (0)

Report
Copy link

Link copied!

I'm not entirely sure I understand why but the solution to this was a capital D on the Departments table reference. Doesn't make any sense to me why it would pull in the dynamic content with a "syntax error" in the table name but once I changed that it worked just fine.

Was this reply helpful? Yes No
jowald 6 on at

Like (0)

Report
Copy link

Link copied!

It's because you need the Schema name in the first part of your expand query

Was this reply helpful? Yes No