Select Query in List rows present in a table

(1) Share

Report

Posted on by SeguM

Hi everyone,

I have a question about the Select Query parameter inside the List rows present in a table action.

The problem I have is that if the column name I choose has no spaces, the selector works correctly. But if the table column name has spaces, then it doesn't work:

I've already tried with: _x0020_, brackets, double and single quotes, but nothing seems to work.

The error is this: !Oa0ZR!An identifier was expected at position 0. Ploc !

Do you have any idea how to select columns with names with spaces?

Thank you very much everyone

Categories:

Building flows

I have the same question (7)

All responses (3)

Answers (0)

Suggested answer

Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi

Can you verify, that the name is actually ID Number (with the space characters in it)

Go to the list, click on the field name, when the field properties page comes up, look at the end of the URL, thats the real internal name

Can you verify its not just IDNUMBER, and also, its not usually all caps like that, so that matters.

Was this reply helpful? Yes No
SeguM 90 on at

Like (0)

Report
Copy link

Link copied!

Hi FlMike

The problem is that they are headers of an excel table, not a URL.
Thank you for your answer.

Was this reply helpful? Yes No
SeguM 90 on at

Like (0)

Report
Copy link

Link copied!

Hello

Any more suggestions?, I'm still doing tests and I still haven't managed to get it to work with fields with blank space names. I am sure that there must be a special character. But it's not: _x0020_, brackets, double or single quotes.

Thanks!!

Was this reply helpful? Yes No