Context
I have an automation that runs for numerous child companies of my company. This process is a critical monthly process that is relatively time sensitive. One of the needs of the end users is the ability to see statuses, as the individual transactions can sometimes take a long time. To fix this, I implemented a data store system where the automation would send transaction relevant data to a Sharepoint list, that Sharepoint list is then connected to a PowerApp which is designed as a Dashboard where users from any company can select their company and see that status of transactions.
Now here is the issue. Permissions are already set up on an individual company level, where they each have access to their own company drive within the Sharepoint. As it stands, the bot account I am using with IS has the Sharepoint data lists stored under its “My Lists” section. But this means for any user that uses the PowerApp, I would need to give every user explicit permission to this list. This would not be an issue if I created a list in the Shared Company Sharepoint and connected to it.
So why haven’t I done that?
Issue
My bot, RPA8 is what we call it, has Full Control of the target Sharepoint, but in the connections list, this Sharepoint nor the Lists on the Sharepoint show up.
Sharepoint:
It has explicit ownership of the lists themselves located within the Sharepoint.
Orchestrator:
Yet notice how in Orchestrator it can only see “My List” and “Recruiting”, which is a separate Sharepoint we successfully added it to over a year ago.
Now here’s the kicker. These connections don’t show up explicitly in Orchestrator, which to be clear is my issue, however I did some messing around with the coded API exposed my the MSFT 365 Activities.
To start, I created a normal workflow and added a Sharepoint activity to expose the connection:
I then use the provided API and connection to manually connect to the Sharepoint list in the target site and return the list as a datatable:
Here is the list and its contents:
And here is what prints:
So through explicitly connecting I can reach this Sharepoint site and List, yet the site does not show up in the Orchestrator dropdown.
Is this some sort of Orchestrator bug or is there something I am missing?