cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Siewake
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
Siewake
Frequent Visitor

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

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
sudharsan1985 Post Patron
Post Patron

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

Hi @Siewake 

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

Siewake
Frequent Visitor

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

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.

Siewake
Frequent Visitor

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

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
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (6,791)