Is it possible to connect sharepoint list to quicksight
QuickSight currently does not connect directly to Sharepoint.
You can upload Sharepoint data to S3 (manually or programmatically) and then connect QuickSight directly to S3 or use QuickSight → Athena → S3.