Problem with Column name in Excel connection

(0) Share

Report

Posted on by JaviCear

Hey there,

I'm trying to select data from a column before list rows present in a table and all I can get is null values.

This is the column name:

Sin título.png

"FECHA DE INGRESO 1ª ACOGDA/OTRO DISP.
(dd/mm/aaaa)"

It has a line break between "DISP." and "(dd/mm/aaaa)" that I can not remove because of some restrictions in the Excel Table. I've tryed to replace the line break with <br>, <br/>, /n, ... without success. Also, I've replace the dot with _x002e_ ...

Please, I don't want to give up on this!

Categories:

Using flows

All responses (6)

Answers (1)

Sort by

rrovira Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hello, @JaviCear!

Would you be so kind as to share a screenshot of your flow? I'd like to replicate the issue and see if we can figure out a solution! Thanks in advance!

(EDIT)
I'm still doing some tests but I found this: ("\n" instead of "/n")
JaviCear 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @rrovira . Thanks for your reply. Sorry, I meant "\n".

Sure, this is the part of the flow where I have the problem:

There is no OData filter at the LIST ROWS PRESENT IN A TABLE action, or any advanced option checked.

As you can see, between the SELECT and the LIST ROWS PRESENT IN A TABLE actions, I'm doing an a ARRAY FILTER. And, in this ARRAY FILTER I have no problem with the column ['FECHA SALIDA (dd/mm/yyyy)'] that has also a line break, just before "(dd/...". Is in the SELECT action, where the input body comes from the ARRAY FILTER, where I can't get values of these columns (here with the line breaks):
['FECHA DE INGRESO 1ª ACOGDA/OTRO DISP.
(dd/mm/aaaa)']
and
['FECHA SALIDA
(dd/mm/aaaa)']

If you need more info, please let me know it.

Thank you so much!
JaviCear 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello!!

@rrovira or somebody can help me? Please...
JaviCear 23 on at

Like
a
(0)

Report
Copy link

Link copied!

UP!!!! 😊
JaviCear 23 on at

Like
a
(0)

Report
Copy link

Link copied!

🤔
Verified answer

JaviCear 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Well, after all I have found a way by my own.
Using a string variable with the column name (including the line break), previously to the Select action, and then setting it into the proper item: "item()?[variables('nameofvariable')]".
Works fine.