Create a table error - Need some help

(0) Share

Report

Posted on by Community Power Pla...

Hello all,

I'm following the link below to create a flow to export a sharepoint list to excel and send an email.

https://www.enjoysharepoint.com/power-automate-export-sharepoint-list-to-excel-and-send-an-email/

Step 9 'Create a table' we use the expression to define the table range followed by $A1:$ and 1:

outputs('A1_Notation_Mapping')[sub(length(outputs('Array_of_col')),1)]

However I keep getting the following errors in the flow check:

Correct to include a valid reference to ‘Array_of_col’ for the input parameter(s) of action ‘Create_table’.

Correct to include a valid reference to ‘A1_Notation_Mapping’ for the input parameter(s) of action ‘Create_table’.

Any ideas on what I need to do to correct it?

I have the same question (0)

All responses (4)

Answers (2)

Pstork1 68,271 Most Valuable Professional on at

Like (0)

Report

Re: Create a table error - Need some help

Check the value that is being supplied by outputs 'outputs('A1_Notation_Mapping')[sub(length(outputs('Array_of_col')),1)]' it should be a letter value, like 'D'. I suspect that you aren't getting the right input in your A1_Notation_Mapping array.

Was this reply helpful? Yes No
Riyaz_riz11 3,661 Super User 2025 Season 2 on at

Like (0)

Report

Re: Create a table error - Need some help

Hi @Anonymous

Please refer this

You have to pass sheet name as well.

Regards

Ahammad Riyaz

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

Re: Create a table error - Need some help

Thank you guys for the answers!

Actually what I had to do was changing the names from "Array_of_col" and "A1_Notation_Mapping" to "Compose" and "Compose_2". For some reason that's how it came named when building the flow. I'm just new to it, so did not figure this out earlier.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,271 Most Valuable Professional on at

Like (1)

Report

Re: Create a table error - Need some help

Those are the default names when you add the action. He evidently renamed them for clarity in the demo. The bottom line is that the correct value wasn't being returned because the names were wrong.

Was this reply helpful? Yes No