I would like to create a ShinyApps R script that takes as input two files sitting on my enterprise's SharePoint. Is this by any way feasible? Would it make things easier if the input files were stored on Microsoft Azure instead?
My Microsoft365R package will let you access files in OneDrive and Sharepoint from R.
If your files are in an Azure storage account, you can use AzureStor instead. It supports blob, file and Azure Data Lake v2 storage.