Trying to Connect to Dataverse Project Table

(0) Share

Report

Posted on by Churchy

129

Hi Experts,

I'm using Power Automate to create a projects and task in a Planner Project.

I'm using premium, so the data is all stored in Dataverse, and indeed I can go to powerapps, find the tables and see the data that my flow is creating.

This is all working fine for when I create a table, however, if I want to update a project, I need to be able to filter the dataverse table to my project in order to get the ID.

This is where I'm getting stuck - when use the "List Rows" connector, I can't see my project table in there (its the standard msdyn_projects table I'm using). I can see the other tables, such as project tasks, I just can't see the project table, and I can't use a custom value to call it either.

I'm not sure what I can do if I can't connect to that table though - I need the GUIDs from that table to be able to make the changes to the necessary fields.

Does anyone know why I might not be able to see that table? It seems like it should be fairly standard?

For reference, these are the "project" tables i can see when I use the connector:

Thanks

Categories:

Building flows

I have the same question (0)

All responses (16)

Answers (1)

Sort by

Expiscornovus 33,851 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Churchy,

Have you tried adding the table name as a custom value? Try using msdyn_projects as a custom value to see if that makes a difference.

Btw, do you have multiple environments. Did you make sure you selected the correct environment? (alternatively, try and use the list rows from selected environment action instead).

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
Churchy 129 on at

Like (0)

Report
Copy link

Link copied!

Hi

I've tried with a custom name, both logical and system name.

I've tied with the selected environment connector, doesn't show up there.

I've got an admin account, which I've just tried connecting to PBI and I can see the table in there... so it can't be a permissions issue...

At the moment, my work around is going to be to model the data in PBI, then return the data from that query in a JSON table, which will give me the ID's I need in order to update the table... but that does seem somewhat of a fudge!!

Thanks

Was this reply helpful? Yes No
Suggested answer

stampcoin 5,153 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Churchy Hi,

If you use project web. you will have the Plan table rather than project.

1. Normally it located in the default Environment, Go to Solution, select Managed.

you will find Project service core or patch

2. Open it.

Check the table, you will find the records within it.

Enjoy Power Platform and have a great day 🚀 | My LinkedIn

If the answer helps, please consider 👍, Thanks.

Was this reply helpful? Yes No
Churchy 129 on at

Like (0)

Report
Copy link

Link copied!

Hi @stampcoin

Thanks for the response, however unfortunately my issue is not manually finding the table and ID's - its dynamically finding the ID's.

I need to be able to find the table in Power Automate, so that I can then find the project records that I want... and I can't find the Plan/Project table in the list of available tables there.

However, the work around I suggested earlier is now what I am doing. I'm using Power BI to connect to the necessary tables, get all the IDs, then returning them in a JSON table and using them.

Unless anyone can tell me how to get at the missing table via Power Autoamte, the PowerBI approach is the one I will be using

Thanks

Was this reply helpful? Yes No
Suggested answer

stampcoin 5,153 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Churchy Hi,

have you tried 'List rows from selected environment' ? make sure you have the products on that environment.

below is from one of my environment, for your reference.

Was this reply helpful? Yes No
Churchy 129 on at

Like (0)

Report
Copy link

Link copied!

hi @stampcoin

Unfortunately, yes, tried that too :(

I also have an admin account that I tried... just nothing seems to return the table that I need in the list!!

THanks

Nick

Was this reply helpful? Yes No
stampcoin 5,153 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Churchy, Hi,

can you confirm your environment has the product ?

otherwise you have to use Plan table.

see my screen from dataverse.

first one with proper Project product.

second one with planner product.

Was this reply helpful? Yes No
Churchy 129 on at

Like (0)

Report
Copy link

Link copied!

hi @stampcoin

Please see below the project table (I'm using planner)

Was this reply helpful? Yes No
stampcoin 5,153 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Churchy Hi,

Do you have the same as mine ?

Was this reply helpful? Yes No
Churchy 129 on at

Like (0)

Report
Copy link

Link copied!

Hi @stampcoin

I can't quite read your screenshot, but I think so:

Was this reply helpful? Yes No