Answered

Add a row to Excel table isn't populating last column of data?

(0) Share

Report

Posted on by Stacey_T

I have a flow that compares data from an Excel file to a SharePoint list and writes the delta/changes to a separate Excel table. Everything seems to be working as designed, flow executes successfully except Power Automate doesn't upload the last column of data, "ECAS Actual Start Date", into the table. It's almost as if the column doesn't exist in the flow run history. I am baffled and can't figure out why it looks fine in the designer but is seemingly absent from the run history.

I've tried deleting and readding the Add a row to a table action; I've also tried creating a new, different table in the Excel file but no joy. I confirmed the range of the table includes this column.

Edited to add: If I add random data to the column (ex: "Name") instead of the date, it seems to work.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

wskinnermctc 6,519 Moderator on at

Like (0)

Report

Are any of the "ECAS Actual Start Date" values blank in the source?

Double check the source SharePoint List and make sure the column name is correct or wasn't changed or deleted. I would delete the action that is getting the values from sharepoint and then re-add it. Trying to refresh the source connection as opposed to the final Excel connection.

I know that will probably break the rest of your flow, but I think it is worth a try since this seems more like a source issue.

Another thing to do is to put a "Compose" action right before the "Add a row into a table" action. Then put the dynamic content for Actual Start Date into the Compose field. Run your flow and see if that Compose field has a value or if it is blank.

Was this reply helpful? Yes No
Stacey_T 60 on at

Like (1)

Report

So deleting and readding the Get Items SharePoint step didn't solve it by itself, but I think I needed to do it. I didn't post a screen shot of my flow, but I had to add the last apply to each step within the second-to-last apply to each step for it to work. The final condition to check for the bMatch variable is what adds the row to a table. Not sure why that is what the solution was, but it works. Last apply to each was originally outside of the loop where the purple arrow points to.

Was this reply helpful? Yes No