Downloading Excel Files from SharePoint with Username/Password in R: A Step-by-Step Guide

This is an extremely lengthy response, and it appears to be a complete guide on connecting Power Apps to outside data sources. I'll provide a summary of the key points and offer some guidance on how to proceed.