cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Problematic SharePoint list causing an API error - Flow > Forms > SharePoint

Hi,

 

Similar error message to another post near the top of the forum, but an unrelated issue i believe, I can't find anone that's posted about this problem so maybe someone here can help me.

 

I've an issue with the first part of a flow that's designed to pick up details from a Form and put it into a sharepoint list.

I've stripped it back to the most basic format to debug and it's a problem with a particular list within my SharePoint site.

 

Problem happens when i try to create an item in the list using the 'Sharepoint > Create Item' flow step. The Sharepoint site has multiple lists and the 'Sharepoint > Create Item' step only generates the following error when connected to the one list i need to connect it to, when the other lists are selected I get expected behaviour and see the fields of the list below.

 

Error executing the api '/$metadata.json/datasets/https%253A%252F%252F**************.sharepoint.com%252Fsites%252F******/tables/a2e4978f-32cd-4865-bb52-373e97f12d64'

 

The list structure in the target sharepoint list is different to the other lists in the site and has some dependencies (2 Lookup type field) on values from other lists, is this the problem? I've got quite far into a project now and am not sure this will work without this functionality.

 

Thanks for reading.

 

Simon

 

1 ACCEPTED SOLUTION

Accepted Solutions

While not a solution, I acutally did want to enforce a value here, but I have found that the trigger behind the error was related to one of the lookup fields that was listed as required, when i changed this value to optional the' Sharepoint > Create Item' Flow piece did indeed display the fields from the table that it was unable to connect to before.

 

Having this problem? - remove 'required' from the Sharepoint lookup columns in the Settings / List Settings for that particular list.

View solution in original post

3 REPLIES 3
Super User
Super User

Hi @Siewake 

Can you please try to use 'Send Http request to SharePoint' for creating an item in SharePoint list using REST API?

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

Thankyou for the suggestion, I have been trying to get this to work for a while but it's a good bit more complex than just using an action, I've not managed to post an item yet, so i may have to learn a bit more here.

While not a solution, I acutally did want to enforce a value here, but I have found that the trigger behind the error was related to one of the lookup fields that was listed as required, when i changed this value to optional the' Sharepoint > Create Item' Flow piece did indeed display the fields from the table that it was unable to connect to before.

 

Having this problem? - remove 'required' from the Sharepoint lookup columns in the Settings / List Settings for that particular list.

View solution in original post

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (3,380)