Customer experience | Sales, Customer Insights,...

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

(0) Share

Report

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

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Leah Ju Microsoft Employee on at

Like (0)

Report

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?

Was this reply helpful? Yes No

Join the conversation

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates