Hi all,
I am relatively new to Power Automate, but am trying to create a flow that will create tasks in Planner when a task is created in Project (ultimately I am trying to work out if assignment will be able to be copied and changes copied each way, but creating the tasks in planner is the first goal).
My flow is failing at the first hurdle, connecting to a project. I have entered the url of the team as
https://ordnancesurvey.sharepoint.com/teams/<myteamname>
which seems to be what it wants. I am pretty sure this is the right team as clicking on Team files in the top right ... menu in Project goes to that team site.
I have then entered the project id as the (what looks like a) GUID from the url of the actual project (after ?projectId=).
I haven't tried any filtering yet.
This is the error I get when I run a test:
{"odata.error":{"code":"1164, Microsoft.Office.Project.Server.Library.ProjectInstanceNotFoundException","message":{"lang":"en-US","value":"ProjectInstanceNotFound: No rows in MSP_WEB_ADMIN table for the site collection. Possibly PWA was not provisioned or it is deleted."}}}
I would be very grateful if anyone has any ideas for how to solve this?
Many thanks in advance!