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

Like (0) Share

Report

Posted on 17 Apr 2023 18:58:11 by CHSL

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

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.

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!

All responses (2)

Answers (1)

Verified answer

CHSL 13 on 19 Apr 2023 at 15:43:39

Like (0)

Report

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 on 19 Apr 2023 at 03:10:44

Like (0)

Report

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

Hi @CHSL,

Show me your flow configuration.