You’re offline. This is a read only version of the page.
23
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:
"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!
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.
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!
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")
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
