Power Platform Community Forum Thread Details

Hi Community!

I need help with below:

Task - There is a MS List (with 10 headers) created on SharePoint. And there is an daily report (excel) getting generated and saved in OneDrive with exactly same set of headers as that of MS list. The ask is to create a PowerAutomate Flow that should update the MS list's values everyday based on the daily report's value. The 'Key' is the first column which has ids right from 1-50 in 50 rows of lists/excel data but daily report can have any number of rows between 1-50 and this is what needs to be updated everyday with data refresh. Also, some columns can have null values as well except 'ID' column.

Current Flow - 1) Trigger - OneDrive - When a file is modified (properties only)

2) List rows present in a table - This is to fetch data from the excel table

3) For each - body/value from excel

- Get items - From SharePoint and Filter Query - Title eq 'ID' : Title is the first column in mS List and iD is the corresponding column in excel

- Condition - length(outputs('Get_items')?['body/value']) >0

- True : For each 1 - body/value (sharepoint)

- Update Item (SharePoint)

- False: Create Item (SharePoint)

Issue - There are no errors with the flow but it's not updating the values as per excel report stored in the form of table. I suspect there may be something wrong with the parameters/argument that's causing the issue but I am not able to detect. Kindly assist.