Answered

Get item ID - Item Not Found

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@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'

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Sam2089 41 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No