Unanswered

Syntax Error for Filter Query

(0) Share

Report

Posted on by EliLow

Hi guys, I’ve been trying this for very long but I’ve not been successful

Basically, I’m trying to create a flow to update a name in an excel sheet table, replacing the old name with a new name. As there are multiple rows with the same name, I’ll need to update all rows for data consistency.

1) Get rows from an excel table with the ‘List Rows Present in Table’ function

2) I try to filter query so that it gives me the lists with the columns which has the value of the old name using this command

- JDE Cost Center Owner eq ‘dynamic content of the outgoing DisplayName’

When I do this, it always gives me this error. Anybody can kindly assist me on this?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

jinivthakkar 4,187 on at

Like (0)

Report

@EliLow this is how you can query column with spaces
Check this: https://flowaltdelete.ca/2020/04/12/excel-filtering-columns-with-space/

and I was just wondering do you need filter action, anyways just try this.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
EliLow 2 on at

Like (0)

Report

Hi,

Thank you so much for your response.
I have tried using the filter array method as well but my question now is how can I update a value in all of the rows that came out of the filter array since the values cannot be used as a dynamic content for the update rows.

Thanks again 🙂

Was this reply helpful? Yes No
KayFax 99 on at

Like (2)

Report

Hi @EliLow ,

So, I just came accross your never solved problem because I had the same and just learned the hard way, that sometimes the solution is very simple: the odata filter in the get rows excel action does only accept a column name (as filter key) in one string without spaces. So, change your column name to "JDEcostcenterowner" and save again and try again...

(or try with expression to turn the column name into a string, but I would first check the simple approach, just to know if that was the problem).

I am not a helper on this forum, so this is kinda late, but just wanted to mention it.
Cheers!

Was this reply helpful? Yes No
NJMUser 25 on at

Like (0)

Report

Thank you!

Was this reply helpful? Yes No