Skip to main content

Notifications

Power Automate - General Discussion
Answered

Get item ID - Item Not Found

(0) ShareShare
ReportReport
Posted on by

Hi All,

 

I'm developing a project that entails working with different SharePoint lists. Some columns should be linked to a masterlist. When selecting the "Get Item", the ID field is mandatory. Not all my lists have the same number of items, so I'm getting the error of "Item Not Found" because ID doesn't match, and it cannot be modified because it's automatically created by SharePoint. Is there any other way of linking two lists without using the ID number as a connector?

 

That's the error I'm getting:

Item Not Found
clientRequestId: 59b98a92-f271-4956-8806-7ed08e9b033b
serviceRequestId: 59b98a92-f271-4956-8806-7ed08e9b033b

 

Please try to provide easy/simple solutions, since I have very basic Power Automate knowledge.

 

Thanks a lot in advance for your help!!

 

Best,

Anna

 

AnnaMnz_0-1640005906794.png

 

  • Sam2089 Profile Picture
    Sam2089 41 on at
    Re: Get item ID - Item Not Found

    @ScottShearer hello,

     

    So why for me does not work this query filter?!

    i removed get item action and replace get items in my main list called Document list with an column department type of look up

    Item not found is a result from the department value being null. The department is selected from the department ID i pass through.  why it works sometimes and other times it doesn’t. Likely an issue with the connector or sharepoint cause it is very ridiculous that it’s not repeatable.

     
  • Re: Get item ID - Item Not Found

    @ScottShearer 

    That's exactly what I needed. Thanks for your great help.

    Anna

  • Verified answer
    ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Re: Get item ID - Item Not Found

    @Anonymous 

    If you have a unique entry in the master list with 123 as the Title, here is the filter query that you would use to retrieve that row:

    Title eq '123'

     

     

     

  • Re: Get item ID - Item Not Found

    Hi @ScottShearer,

    Thanks for your message.

     

    The TITLE column stays on every list. For example, if I have an item named as "123" on the overview, I'm also having the same "123" item in the other lists. 

     

    I've checked your link about Filter Query. If I get it right, I should modify Get Item to Get Items action and use ODATA to select the specific file I want to modify...

     

    - Shall I use the "substringof" option? If so, would it be: substringof('Title',Title)?

    - On the next action, Update Item, what should I use as ID then? 

    I'm sending you a screenshot of the automation, hope it helps.

     

    Thanks!

    Anna

     

    AnnaMnz_0-1640012084285.png

  • Verified answer
    ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Re: Get item ID - Item Not Found

    @Anonymous 

    If you are trying to get an item from your master list, you'll want to use a Get items action with a filter query.  This implies that there is some value in the master list that is a common column - you need a way to look up the value in the master list.  What is the common column between the two lists?  

    Here is a link for more info on using a filter query.

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,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard