May 30 2020 10:47 AM
May 30 2020 10:47 AM
I want to create a list on my Sharepoint Online 365 by connecting to an API of a system where I will get all the registration information of my employees, then I will use this list as a data source in an application on PowerApps. How do I set up this connection to external data in Sharepoint?
May 31 2020 12:44 AM
@leandrosg you would need to use Power Automate with a custom connection if there is no ready-built connector for the system that holds your registration information. That flow could get the registration data and populate the SharePoint list which could then be the data source for your app in Power Apps.
Microsoft Power Automate Community Super User
May 31 2020 01:24 AM
@leandrosg To set up connection so that SharePoint data can be accessible from external connection, I have written a blog, please check below link:
Jun 05 2020 06:58 PM
First of all congratulations on the blog, but I couldn't get past the xml permission part Failing to create.
Jun 06 2020 06:07 AM
@leandrosg : It seems you need tenant level permission to trust this app. This granting can only be done via the appinv.aspx page on the tenant administration site. You can reach this site via https://tenantName-admin.sharepoint.com/_layouts/appinv.aspx. Once the page is loaded add your client id and look up the created principal.
Use below XML to get the full control permission for the APP.
When you click on Create you'll be presented with a permission consent dialog. Press Trust It to grant the permissions
Jun 06 2020 02:33 PM
I did all the steps, but it didn't work.
When I am going to generate the Sharepoint api website it presents the following error:
"error_description": "Exception of type 'Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException' was thrown."
Jun 06 2020 09:15 PM
@leandrosg : Check the API, it should be this format: https://<sitename>.sharepoint.com/_api/web?$select=Title
You have used _layout/15/, should not be part of API URL.
Jun 09 2020 02:59 AM - edited Jun 09 2020 03:01 AM
@leandrosg : Hope you are changing the authorization token after token_type "Bearer" which generated from below API: