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 Automate / Update "Last Enrolled"...
Power Automate
Suggested Answer

Update "Last Enrolled" Field Based on Matching WSU ID from Related Contact

(0) ShareShare
ReportReport
Posted on by 6

Hi everyone,

 

I’m working on a Power Automate flow in our Dataverse environment and need some help.

 

When a new record is created in the GDCH Enrolment table (custom table: schn_enrolment), I want to:

 

  1.  

    Find the associated Contact record linked to that enrolment.


  2.  

    Get the WSU ID from that Contact.


  3.  

    Search for other Contact records in the Dataverse that have the same WSU ID.


  4.  

    Once found, update the "Last Enrolled" field on their Graduate Diploma in Child Health Enrolment record(s).



  5.  
 

I'm stuck on how best to structure the query for finding the other Contacts with the same WSU ID and updating related enrolment records. Has anyone done something similar?

 

Any suggestions, examples, or best practices would be greatly appreciated!

 

Thanks in advance,

 

 

Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,414 Super User 2025 Season 2 on at
     
    You are using capital letters, all name are local case.
     
    So if that is the actual "column" then you want new_wsuid not that caps version
     
  • MV-09050036-0 Profile Picture
    6 on at
    Hi Michale,
     
    I have used the lower case for schema names. but still i can't find a success on this flow. If anyone could help me to find the steps?

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 Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard