Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / power apps, how to get...
Customer experience | Sales, Customer Insights,...
Suggested answer

power apps, how to get field value from parent to child table and roll up values for parent value

(0) ShareShare
ReportReport
Posted on by Ahmed_16

power apps, how to get field value from parent to child table and roll up these values for other parent value

example I have a master worker list with wages,

I also have a task list as a parent with child table of assigned workers, relationship one to many I need to get wages from workers and roll it up in the task sheet

I tried to use a calculated field to get the value from a parent, But roll up can't work with the calculated field

  • Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    power apps, how to get field value from parent to child table and roll up values for parent value
    Hi Partner,
    Did that answer your question?
    Any updates? Please feel free to ask me any questions you may have!
    If someone answered your question, can you check this box to mark that response as an answer?
  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    power apps, how to get field value from parent to child table and roll up values for parent value
    Hi Partner,
    Based on your description, are you using calculated fields to get the field values of the parent record?
    Indeed, calculated fields are not available in rollup fields.
    So you need to use other methods to get the field values of the parent record：
    For example, create a common field, and then use a workflow or flow to auto-populate the value when the lookup field on the child record's form has a value.
     
     

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans