Unanswered

Trying to update items from excel to sharepoint list

(1) Share

Report

Posted on by RS-12021353-0

Hello Community
I am new to the power automate.

I am trying to read and update the data from excel file with Project Code as a column which contains unique values.

In return I am not getting the data in sharepoint list and second when it tries to update, I cannot see the data.

Thanks
Rahul

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

David_MA 12,966 Super User 2025 Season 2 on at

Like (1)

Report

Based on the screen shot of the flow, it is not updating items, it is creating a new item in your SharePoint list. Did you mean to say the items are not being created rather than updated or is the update occurring on the no side of the condition?

If you meant it is not creating an item, show a flow run where your flow goes down the yes side of the condition and show the body of the create item action (you can black out any sensitive data).

If the update is occurring on the no side of the condition, show how it is configured. Also, showing a run of the flow and how it performed is helpful for diagnosing the issue.

Note: you may want to blackout your SharePoint domain in the site address since you've blacked out other data.

Was this reply helpful? Yes No
RS-12021353-0 3 on at

Like (0)

Report

Hello @David_MA

Thank you for your response.

It creates the new items but it does not show me the data of other mapped columns.

When it runs to update the items, nothing happens.

I ran two times as a test

Test - 1 (initial state is Blank SP list, so it should add data there, however the result is - it only Added Project codes and there are blanks for rest of the columns). I know there is some silly nuance mistake
Here is the body. I have removed the sensitive data

{

  "@odata.etag": "\"1\"",

  "ItemInternalId": "497",

  "ID": 497,

  "ProjectCode": "PRG-000071",

  "Modified": "2025-02-12T19:10:46Z",

  "Created": "2025-02-12T19:10:46Z",

  "Author": {

    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

    "Claims": "",

    "DisplayName": "Rahul Sehgal (Supplier)",

    "Email": "",

    "Picture": "",

    "Department": "",

    "JobTitle": ""

  },

  "Author#Claims": "",

  "Editor": {

    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

    "Claims": "",

    "DisplayName": "Rahul Sehgal (Supplier)",

    "Email": "",

    "Picture": "",

    "Department": "Supplier",

    "JobTitle": "Principal Consultant"

  },

  "Editor#Claims": "",

  "{Identifier}": "",

  "{IsFolder}": false,

  "{Thumbnail}": {

    "Large": null,

    "Medium": null,

    "Small": null

  },

  "{Link}": "",

  "{Name}": "",

  "{FilenameWithExtension}": "",

  "{Path}": "L",

  "{FullPath}": "",

  "{HasAttachments}": false,

  "{VersionNumber}": "1.0"

}

Test 2 - Updating the data (No side)
1. I cannot confirm if I cannot see the mapped data.

Thank you for your message regarding sensitive data.

Bests
Rahul

Flow 1.png

Was this reply helpful? Yes No
David_MA 12,966 Super User 2025 Season 2 on at

Like (0)

Report

I am sorry, I don't know what this means: "It creates the new items but it does not show me the data of other mapped columns." Can you share a screen shot of a flow run of the action that created the items and in the screen shot highlight what you mean by "other mapped columns". Are you referring to the Programme and Project Name values?

If so, add a compose action before the create item action and put the three values used in the Create item action so you can see what values are in the spreadsheet when the item is created. Then share a screen shot of that. If the compose action has content missing, that is why it is missing when the item is created.

Was this reply helpful? Yes No