no data found if column name contains dots

(0) Share

Report

Posted on by Community Power Pla...

Dear community,

I have the following issue:

I am extracting data from an excel sheet into a variable and then sending it via E-Mail.

This is working fine for all columns where we do not have any dots, slashes or other things in the column name. For columns with a slash inside I found a workaround with the concat expression - but this is not working for dots inside the column name.

items('Apply_to_each')?[concat('Purch', '.', 'doc')]

Did someone experience such a problem as well?

All responses (4)

Answers (2)

Community Power Pla... on at

Like (1)

Report

Re: no data found if column name contains dots

Thanks a lot Damien. That helps!
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Re: no data found if column name contains dots

Hi @Anonymous

items('Apply_to_each')?['Doc_x002e_ date']

It's worth you having a quick look in here:

As it will give you the expressions you need to use.

Damien
Community Power Pla... on at

Like (0)

Report

Re: no data found if column name contains dots

Awesome thanks, that worked!

If we have a column which is called "Doc. date" - How do you write this in PA language?

items('Apply_to_each')?['Doc_x002e__x0020_date']

I have tried but this does not work. Any idea?
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Re: no data found if column name contains dots

Hi @Anonymous

Try items('Apply_to_each')?['Purch_x002e_doc']

If you look at the run history of your list rows, you will see something like follows:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉