Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

"Add Row into a table" takes a valid input and turns every value to "Null"

(0) ShareShare
ReportReport
Posted on by 13

I am trying to add the values from a spreadsheet table to a master table, and everything works except that on the "Add Rows into a Table" step, the inputs look right and have values, but the output says "Null" for every value. The rows that get added to the master spreadsheet are all blank. 

 

The Outputs of "list rows present in a table" has some values put in as random test data

CHSL_0-1681757218597.png

 

But then I use the output of that (@{outputs('List_rows_present_in_a_table')?['body/value']}) for an "Add Row into a table" action and I keep getting empty values.  

 

CHSL_1-1681757308970.png

I have tried mapping the columns using the "apply to each" level that contained the "List Rows Present in a Table" Action, for example @{items('apply_to_each_2')?['Contractor Supervisor Visits']} . 

 

I'm very new at this and I may well be missing something obvious. I'd appreciate any help with what I am doing wrong!

  • Verified answer
    CHSL Profile Picture
    13 on at
    Re: "Add Row into a table" takes a valid input and turns every value to "Null"

    Thanks for your response. I continued to fiddle with it and discovered that the rows were referencing the wrong "Apply to Each" loop. They needed to reference the current item, and it worked at that point. 

  • v-qiaqi@microsoft.com Profile Picture
    on at
    Re: "Add Row into a table" takes a valid input and turns every value to "Null"

    Hi @CHSL,

    Show me your flow configuration.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >