web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : Uye8h5a7E/4vIfXyxr3+gS
Power Automate - Building Flows
Answered

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

Like (0) ShareShare
ReportReport
Posted on 17 Apr 2023 18:58:11 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 19 Apr 2023 at 15:43:39
    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 19 Apr 2023 at 03:10:44
    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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete