To be able to use secrets in the KNIME Business Hub for logging into Microsoft Services like Sharepoint, one has to follow the documentation here: https://docs.knime.com/latest/business_hub_secrets_guide/index.html#howtos_azure_app_interactive
The permissions have to be set in the Azure Portal.