List Gifts 400 - Bad Request

Hey Yall! I had gotten Daily Gift Report emails set up in Power Automate to go to our Officers every morning, but one of the flows I have keeps spitting out a 400 error with the following internal error (cut down to the important stuff):

Bad Request - Request Too Long

HTTP Error 400. The size of the request headers is too long.

For context on this flow, this officer (due to the way his position works) currently has 790 people assigned to him. Looking at the below screenshot, this is how I have each thing set up:

• List Fundraiser Assignments
  • Fundraiser ID = his ID
  • Limit = 1000
• Append to string variable
  • Name = CSLGifts
  • Value = (no quotes in the actual value) "[Constituent ID], "
• Append to string variable 3 - used to remove the final ", " from the list created above
  • Name = Take CSLgifts
  • Value = [take(variables('CSL Gifts'),sub(length(variables('CSL Gifts')),2))]
• List Gifts
  • Added on or after = Past time (24 hours)
  • Constituent ID = [Take CSLgifts]
  • Limit =5000

I'm not sure why its saying its too long of a request when I have the limits set to 1000 & 5000. Any and all help is appreciated, I haven't done much with the Limit option before so there's a good chance I'm looking at this wrong!!

EDIT: I forgot to add what Power Automate has as the error at the top of the workspace:

Action 'List_gifts' failed: The response is not in a JSON format.