no data found if column name contains dots

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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?

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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 😉

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thanks a lot Damien. That helps!

Was this reply helpful? Yes No