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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Force sync between Pow...
Power Apps
Unanswered

Force sync between PowerApps subgrid and Dataverse: systemuser tableā€

(1) ShareShare
ReportReport
Posted on by 14

I created a Model-Driven PowerApp.
In this PowerApp, I added the Dataverse table: TEAMS, in which I included the subgrid: MEMBERS of the related table: SYSTEMUSER.

I created a PowerAutomate flow that creates Dataverse teams with some users (records from the systemuser table).

Problem: sometimes the subgrid appears empty!

How Can i solve this problem??


Solution1 = I found that one possible solution is to go to Administration Interface > Environment > Check app access > enter the email address of the users in that team and click SEARCH

I want to ā€œautomateā€ this Solution1 via a PowerAutomate flow.

Solution2 = using the PowerAutomate action: FORCE USER SYNCHRONIZATION Solution3: making a POST and a GET to the systemuser table

POST https://{tenant}/api/data/v9.2/systemusers CallerObjectId: ReplaceWithAzureObjectID Accept: application/json Content-Type: application/json; charset=utf-8 OData-MaxVersion: 4.0 OData-Version: 4.0
{ā€œaFieldLogicNameā€:ā€œSample Account created using impersonationā€}

GET https://{tenant}/api/data/v9.2/systemusers ?$select={aFieldLogicName}

ISSUE: it doesn’t always work! Sometimes the calls fail, and the subgrid appears empty in the PowerApp.

Categories:
I have the same question (0)

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard