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

[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. 

[wskinnermctc · Accepted solution]

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.

[Stacey_T]

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.