Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Action 'Update_item' failed

(0) ShareShare
ReportReport
Posted on by 4

I am trying to create a List that mirrors and updates from another List with just specific columns.  I haven't been able to get it to work. I have tried this example : https://youtu.be/kEkZXBMf6eo 

 

Some how I had it working before now there is a new error.  I even deleted every past List and started from scratch twice (this is becoming my third).  If you could recommend a different method or help me address my current flow, PLEASE!!!!

canog1_1-1644528029448.png

 

canog1_0-1644528029692.png

 

As you can see I am using: Instant Flow Cloud

 

Sharepoint: When an Item is created or Modified

(Selected) Source Information

 

Sharepoint: Get Items

(Selected) Desired Information

Note: Under Filter Query added: ID eq'ID'

 

Conditions:

length (triggerBody()?['value']) / is equaled to / 0

 

(Yes) Sharepoint: Create Item

(No) Sharepoint: Update Itm

 

Error Details:

Could not find list item.
clientRequestId: 4721ebe0-dee4-4ea3-9ae7-73ebed85a37e
serviceRequestId: 4721ebe0-dee4-4ea3-9ae7-73ebed85a37e

 

INPUTS: Raw 
{
    "method""patch",
    "path""/datasets/https%253A%252F%252Fteex.sharepoint.com%252Fsites%252FITSICIDMREC/tables/0297e360-aeaf-4815-847b-eda8bc8c26ea/items/28",
    "host": {
        "api": {
        },
        "connection": {
            "name""/providers/Microsoft.PowerApps/apis/shared_sharepointonline/connections/adef5b6af7284a98bf13e6cf81903152"
        }
    },
    "authentication": {
        "scheme""Key",
        "parameter""*sanitized*",
        "type""Raw"
    },
    "body": {
        "CourseStatus": {
            "Value""Under Review / Processing"
        },
        "DeliveryPlatform": {
            "Value""Face2Face"
        },
        "StartDate"null,
        "EndDate"null,
        "CourseTitle": {
            "Value"null
        },
        "Seq_x0023_"0,
        "Project_x0023_": {
            "Value""0"
        },
        "Task_x0023_"0,
        "LeadInstructor": {
            "Claims"null
        },
        "SecondaryInstructor": {
            "Claims"null
        },
        "OtherInstructor": {
            "Claims"null
        },
        "CourseAddress"null,
        "CustomerPOC"null
    }
}
 
OUTPUTs: raw
{
    "statusCode"404,
    "headers": {
        "Vary""Origin",
        "X-SharePointHealthScore""0",
        "X-MS-SPConnector""1",
        "X-SP-SERVERSTATE""ReadOnly=0",
        "DATASERVICEVERSION""3.0",
        "SPClientServiceRequestDuration""34",
        "SPRequestGuid""4721ebe0-dee4-4ea3-9ae7-73ebed85a37e",
        "request-id""4721ebe0-dee4-4ea3-9ae7-73ebed85a37e",
        "MS-CV""4OshR+Teo06a53Pr7YWjfg.0",
        "Strict-Transport-Security""max-age=31536000",
        "X-FRAME-OPTIONS""SAMEORIGIN",
        "Content-Security-Policy""frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com;",
        "MicrosoftSharePointTeamServices""16.0.0.22126",
        "X-Content-Type-Options""nosniff",
        "X-MS-InvokeApp""1; RequireReadOnly",
        "Timing-Allow-Origin""*",
        "x-ms-apihub-cached-response""true",
        "x-ms-apihub-obo""true",
        "Cache-Control""max-age=0, private",
        "Date""Thu, 10 Feb 2022 20:45:08 GMT",
        "P3P""CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"",
        "X-AspNet-Version""4.0.30319",
        "X-Powered-By""ASP.NET",
        "Content-Length""179",
        "Content-Type""application/json",
        "Expires""Wed, 26 Jan 2022 20:45:09 GMT",
        "Last-Modified""Thu, 10 Feb 2022 20:45:09 GMT"
    },
    "body": {
        "status"404,
        "message""Could not find list item.\r\nclientRequestId: 4721ebe0-dee4-4ea3-9ae7-73ebed85a37e\r\nserviceRequestId: 4721ebe0-dee4-4ea3-9ae7-73ebed85a37e"
    }
}
  • canog1 Profile Picture
    canog1 4 on at
    Re: Action 'Update_item' failed

    Thanks for the help. I am not using power automate anymore. 

  • Ellis Karim Profile Picture
    Ellis Karim 10,547 on at
    Re: Action 'Update_item' failed

    May be this will give you some ideas:

    Snag_14d586ef.png

    The ID column is the SharePoint column ID.

     

    You will probably need two flows, and they would resemble something like this:

    Snag_14deca36.png

    You will need to add any condition checks as required.

     

    Hope this helps.


    Ellis
    ____________________________________
    If I have answered your question, please mark the post as Solved.
    If you like my response, please give it a Thumbs Up.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard