How to fix SharePoint error 429

SharePoint offers a wide range of different tools to help users manage and share content such as files, folders, documents, and even lists of data. However, like many things, it is also prone to errors. Such as the one we’re going to discuss today, the error is labeled as error 429 and its most prominent appearance is when users are deemed as performing too many actions on SharePoint at once, throttling the server and preventing tasks from being complete. The true cause of the 429 error is that the throttling limit has been exceeded. Many sources claim that this occurs when SharePoint receives more than one request per second for an extended period. However, using the REST API is simply one technique to get around the user’s throttling restriction. The next most well-known is the CSOM, which utilizes the same endpoint. We will go over some of the most accepted solutions to help resolve this issue in this blog as well as some workarounds to prevent this error from happening again. Follow the step-by-step process below to see how you can resolve error 429.

Step by step process – How to fix SharePoint error 429

  1. Sign into Power Automate with your current login details associated with SharePoint.
  2. In the popular services panel, select “SharePoint”.
  3. Now in the categories, select “When an item is created or modified”.
  4. Type out your site address (the SharePoint site where your file is located).
  5. Now type out the list ID (Referenced to the list with issue).
  6. Click on “Next step”.
  7. Find and click on “Update item”.
  8. Fill out all the information specified (An example can be found below).
  9. Click on “Save”.
  10. Click on “Next step”.
  11. Under “Action” click on “Condition”.
  12. Fill this information out using the information below as a guide.
  13. Finally, click on “Save”.

The flow made above will help regulate the list-based content and prevent the trigger required to conduct the error pass for error 429. The condition is such that it will prevent the looping of said flow and prevent constant buffering from the needless appeal of multiple cycles. Flows are designed to help automate certain aspects of the Office suite. One of which includes a flow network for SharePoint in which you can design to either automate tasks within SharePoint and regulate an automated sequence of flows to help create a cycle such as the one designed above to regulate the flow of content within a SharePoint list. You will need to create multiple flows and repeat the process multiple times if you need to regulate content on multiple lists on your network.

What is Power Automate?

This Software by Microsoft enables people to automate processes within various Microsoft applications. With Power Automate, anybody can create automated processes using flows. Automate repetitive, monotonous activities with ease using low-code, drag-and-drop tools and hundreds of prebuilt connections. With a process adviser, you can record and visualize your end-to-end processes while getting guided advice for designing flows and detailed insights that take the guesswork out of deciding what to automate.

CSOM HTTP 429 error – more information 

The throttling limit has been surpassed, which is the real reason for the 429 error. According to several sources, this happens when SharePoint gets many requests per second for a lengthy period of time. Using the REST API, on the other hand, is just one way to get around the user’s throttling limitation. The CSOM, which uses the same endpoint, is the second most well-known.

If you have 10,000 entries in the table and you filter by the changed column, which is not indexed, it will run through all 10,000 records, lock the database, and hit the list view throttling set in the central admin for list queries, which is set to 5000 by default.

The majority of these lists include fewer than 1000 rows of data, with one having 3500. Users may receive 429 errors for the list with 3500 rows on a frequent basis. Unfortunately, they are now limited to using SP lists as their major data source, and they were shocked to run into these problems with such a tiny amount of data. The dataflows are now refreshed four times each day, with a three-hour interval between each refresh.

So the dataflow in question isn’t performing any mergers between the lists, that’s done in other dataflows that use the linked entities from the dataflow we’re talking about. The dataflows that complete the merge/appends and other similar stages are all configured to refresh an hour later, with refresh times averaging less than five minutes.

Try using the flowing script below in Automate processes to allow for the custom to cork correctly enabling you to get a better rate of data flow.

sitename = “https://<org URL>”,  // if a subsite use “Site/SubSite”  listname = “<list name>”,  baseurl = sitename & “/_api/web/lists/GetByTitle(‘” & listname & “‘)/”,  itemcount = Json.Document(     Web.Contents(baseurl & “ItemCount”, [Headers = [Accept = “application/json”]])   )[value],  skiplist = List.Numbers(0, Number.RoundUp(itemcount / 5000), 5000),  #”Converted to Table” = Table.FromList(skiplist, Splitter.SplitByNothing(), null, null, ExtraValues.Error),  #”Renamed Columns” = Table.RenameColumns(#”Converted to Table”, {{“Column1”, “Skip”}}),  #”Changed Type” = Table.TransformColumnTypes(#”Renamed Columns”, {{“Skip”, type text}}),  fieldselect = “&$top=5000”,  // all fields with no expansion  // fieldselect = “&$top=5000&$select = Id,Title,Person,Date”, // list desired fields (no expansion)  // fieldselect = “&$top=5000&$select=Id,Title,Choice,LookupColumn/Title,LookupColumn/Project,LookupColumn/ProjectStatus,Date,Person/LastName,Person/FirstName,Person/EMail&$expand=LookupColumn,Person”,  Custom1 = Table.AddColumn(#”Changed Type”, “Items”, each Json.Document(       Web.Contents(         baseurl & “/items?$skipToken=Paged=TRUE%26p_ID=” & [Skip] & fieldselect,         [Headers = [Accept = “application/json”]]       )

In depth – Step by step process – How to fix SharePoint error 429

Step by step breakdown:

  • First, sign in to your Microsoft 365 account.
  • Click the app launcher in the top left. (1)
  • Then select “Power Automate” from the apps list. (2)
    • If you can’t see Power Automate, click “all apps” to find it.

Power Automate is a new Microsoft corporate solution that allows us to automate the integration and synchronization of all of our data analysis and apps in order to increase productivity and efficiency. Below is the Power Automate Dashboard.

  • To get started, type “SharePoint” into the search bar at the top. (1)
  • Then select “SharePoint” from the list of connectors. (2)

Power Automate essentially works with as many application connectors as possible. This not only includes Office 365 and Office 365 partner software such as SharePoint but also 3rd party software such as Twitter.

  • Now in the categories, select “When an item is created or modified”.
  • Type the name or site address of the site you want to connect to in the top box. (1)
  • Select your site from the dropdown list of available sites. (2)
  • Select a list from your site that you want to generate a trigger for. (3)
  • Then click the “+ New step” button. (4)

Now select an action — something that happens whenever an item is created or modified. The action we want is to update the item whenever it is created or modified.

  • Type “SharePoint” into the search bar at the top. (1)
  • Then scroll down the list of actions and select “Update Item.” (2)
  • Find and click on “Update item”.
  • Fill out all the information specified (An example can be found below).
  • Click on “Save”.
  • Click on “Next step”.
  • Under “Action” click on “Condition”.
  • Fill this information out using the information below as a guide.
  • Finally, click on “Save”.

That’s it for this Blog thank you for taking time out to read our content, please feel free to email our team about how it went if you followed the steps or if you need more help with the questions we answered in this Blog.

Saajid Gangat

Saajid Gangat has been a researcher and content writer at Business Tech Planet since 2021. Saajid is a tech-savvy writer with expertise in web and graphic design and has extensive knowledge of Microsoft 365, Adobe, Shopify, WordPress, Wix, Squarespace, and more! You can connect with Saajid on Linkedin.

Recent Posts