Skip to main content

Notifications

Community site session details
Power Automate - General Discussion
Answered

Get item ID - Item Not Found

Like (0) ShareShare
ReportReport
Posted on 20 Dec 2021 13:16:41 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
    41 on 21 Jun 2023 at 10:52:09
    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.

     
  • Community Power Platform Member Profile Picture
    on 20 Dec 2021 at 15:48:03
    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
    25,223 Most Valuable Professional on 20 Dec 2021 at 15:23:53
    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'

     

     

     

  • Community Power Platform Member Profile Picture
    on 20 Dec 2021 at 15:04:25
    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
    25,223 Most Valuable Professional on 20 Dec 2021 at 13:26:52
    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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

#1
rpersad Profile Picture

rpersad 16

#2
David_MA Profile Picture

David_MA 10 Super User 2025 Season 1

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 8 Super User 2025 Season 1

Overall leaderboard
Loading started
Loading started