Power Platform Community Forum Thread Details

Updating Sharepoint list with Excelsheet overwriting values with 'null'

I have an excel sheet with values that I would like updated to a Sharepoint list. I've created a PowerAutomate flow like this;

The issue I'm facing is in the Update Item step. The value of interest (Adjustment) should be updated here, but instead is being replaced by blank values.

I've set the update step up to update the Adjustment field with the Adjustment2 value from the Excel sheet. When I set the step up, Adjustment two does not appear in the 'data from a previous step' lookup, it has to be added as a dynamic field. At this point the value will show as from Excel.

Once I've run the flow, it will then show the adjustment field as coming from Sharepoint.

I can see that the 'Get Fields' step is getting the right values from the Excel sheet as it has an OData filter that correctly calls the StudentID column, and I've tested it with the Adjustment2 column which worked. My guess is that the metadata of the Excel values are not being properly communicated to the update fields step, and that the issue happens after the 'Get Data' step, but I don't know how to resolve this.

Categories:

Business Process Flows

Quick Links

Leaderboard > Power Automate