web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

PMA project stage bulk update using excel add ins

(0) ShareShare
ReportReport
Posted on by 162

Hi there,

we are using D365 F&O PMA at the version of  10.0.8 (10.0.319.20003)

we are trying to move a number of projects to the stage of "close", trying to do this via Excel add in, and bring in the Project stage field to the excel, but when we change the project stage value and tried to save and refresh the change back to the database, I am getting a message saying 'project stage" is a read only field.  Is there a way to get around this issue

Thanks in advance

I have the same question (0)
  • Suggested answer
    Christoph Thaler Profile Picture
    5,442 on at

    Hi Agnes.

    unfortunately not. It seems this is not allowed by design. In addition you are not allowed to bulk update multiple projects in the user interface. I suggest to request a modification by a developer but think about an additional security check to ensure nobody will close all project by mistake. 

  • Agnes Lee Profile Picture
    162 on at

    Thanks Christoph, much appreciated

  • Suggested answer
    Rahul Mohta Profile Picture
    21,044 on at

    project stage field triggers /controls other updates to project hence is a read only

    you can multi select projects in UI and can update in bulk

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Agnes Lee,

    The project stage is not something you can directly mass update.

    Yet, with a little adjustment of the respective entity, you can use flow / powerautomate to achieve what you want.

    I posted something about my blog about this flow integration where my friend Ievgen explains how to realize the modification needed for the entity.

    Might help; maybe just have a quick look at the video.

    Best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    304,443 Super User 2026 Season 1 on at

    Hi Ludwig,

    It will be helpful if you share the direct link to the specific blog and video. Can you add these links? There is now only a general link to your blog in your signature.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 627

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 615 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 301

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans