Update Sharepoint flow from Excel

[kevinm1]

Hi all,

I followed this guide on Youtube:

https://www.youtube.com/watch?v=-ZaktFuS1KA&list=PLcwrIWK7WBcSwOGT4ZaPeAm70egmTVU3k&index=9

 When I test the flow and run it for the first time it works as expected. it follows the Create item path and the SharePoint list gets his date from the excel. When I update the excel and run it again it follows the update item path but nothing  gets updated in the sharepoint list. When I add something to the excel file and run it, it follows the update item path and the new date is added in the SharePoint list but the old data is still not updated in SharePoint. What I do notice is that when I save the flow the dynamic values in the Update Item action at the Title, Category,... parameters are changed automatically from the Excel dynamic values to the SharePoint dynamic values and I can't figure out why it does that. I already changed it back to excel several times and created the entire flow again but it keeps changing those values from Excel to Sharepoint

[kevinm1 · Accepted solution]

For people experiencing the same or a similar error, I found the solution myself. I was working in the new designer and for some reason when I changed to the old designer and entered the Excel dynamic values they didn't change anymore after saving. Even when changing back to the new designer it kept working. What I did notice was that when I checked the code when created in the new designer at first it didn't had the For_each part that I underlined below and took from the old designer mode.

{

    "inputs": {

        "host": {

            "connectionName": "shared_sharepointonline-1",

            "operationId": "PatchItem",

            "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline"

        },

        "parameters": {

            "dataset": "https://m365x64748087.sharepoint.com/sites/PowerAutomatetestsite",

            "table": "7ce7a556-c3c7-4dd5-9f69-6731b051f2f5",

            "id": "@items('For_each_1')?['ID']",

            "item/Title": "@items('For_each')?['Title']",

            "item/Category": "@items('For_each')?['Category']",

            "item/Quantity": "@items('For_each')?['Quantity']",

            "item/Status": "@items('For_each')?['Status']"

        },

        "authentication": "@parameters('$authentication')"

    },

    "metadata": {

        "operationMetadataId": "0a67e578-5ec3-44d7-ba49-41abcc50d714"

    }

}

So probably just a bug in the new designer mode