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