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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Power Apps Deployment ...
Power Apps
Suggested Answer

Power Apps Deployment Requires Manual Refresh of Tables and Flows After Every Release

(0) ShareShare
ReportReport
Posted on by 15

We are experiencing an issue with our Power Apps deployment process. After every deployment (both manual and CI/CD based), the application does not function correctly for end users until the app is opened in edit mode and all table connections and Power Automate flows are manually refreshed and republished.

Current post-deployment steps:

  1. Open the Canvas App in edit mode.
  2. Refresh all data source connections/tables.
  3. Refresh all Power Automate flow references.
  4. Save and republish the app.

If these steps are not performed, users encounter errors while accessing data or triggering flows.

We would like to understand:

  • Why this manual refresh is required after every deployment.
  • Whether this indicates an issue with connection references, environment variables, solution configuration, or deployment pipeline setup.
  • Best practices to eliminate the need for manual intervention after deployment.
  • Any recommended troubleshooting steps to identify the root cause.

Has anyone encountered a similar issue or found a permanent solution?


Update:

I am using SQL as data source and user gets below error unless we manually refresh all tables and flows.

ThrowCrmSecurityException:
The user with id xxxd9505-cc67-xxx1-bec2-000xxxxxxxxb has not been assigned any roles.
They need a role with the prvReadWorkflow privilege.
Categories:
I have the same question (0)
  • Power Platform 1919 Profile Picture
    2,258 Super User 2026 Season 2 on at

    Could you please confirm the datasource used for this solution?
    Also, could you share your deployment process, such as whether you are using pipelines or doing manual import or export of the solution?

    I previously faced issues when using SQL as a datasource, so I want to make sure what this solution is connected to

    Thanks!
     
  • Suggested answer
    11manish Profile Picture
    4,000 Super User 2026 Season 2 on at
    This should not be treated as a normal post-deployment activity. A Canvas App should not require someone to open it in Studio, refresh every table and flow,
     
    save, and republish after every deployment.

    The behavior strongly indicates a problem with Canvas App dependency resolution during ALM, most likely involving connection references, Power Automate
     
    flow references, data-source bindings, or solution deployment/layering.

    The most important clue is:

    The app starts working immediately after manually refreshing data sources and flows and republishing.

    That suggests the deployed app contains stale or unresolved dependency metadata. The manual refresh is effectively forcing Power Apps Studio to rebuild those
     
    references.

    this happens consistently after every deployment, I would also capture the solution version, Canvas App version, flow IDs, connection-reference mappings,
     
    deployment logs, and exact runtime errors and raise it with Microsoft if the ALM configuration checks out. The repeated "refresh in Studio fixes it" behavior is a
     
    particularly useful reproduction detail for Microsoft Support.
  • vkvikash337 Profile Picture
    15 on at
    We are using SQL as datasource
  • Power Platform 1919 Profile Picture
    2,258 Super User 2026 Season 2 on at

    Hi @vkvikash337,

    Could you share how you are connecting to the SQL datasource?
    Are you using environment variables, or is it a direct connection in the canvas app?

    something like this ?

    Thanks!

  • Power Platform 1919 Profile Picture
    2,258 Super User 2026 Season 2 on at

    Hi @vkvikash337,

    I just checked the update in the question, and I’ve faced this issue before as well.
    Can you try assigning the “App Opener” and “Basic User” roles to the end users or to the Dataverse teams from the power platform admin center?
    This usually resolves the insufficient privilege issue.

    Thanks!

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 401 Most Valuable Professional

#2
11manish Profile Picture

11manish 201 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 128 Super User 2026 Season 2

Last 30 days Overall leaderboard