SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error.

Hi JakeSWTC,,
It seems to be problem in sharepoint, you could try to increase lookup column in sharepoint setting. You could refer to How to increase Lookup column limit from 8 and How to increase lookup column limit in SharePoint lists for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.