Power Platform Community Forum Thread Details

Need help with combining the below code into a single action. Both work individually but from a user experience perspective, I need a single action.

Hierarchy of tables:

Facilities (1:many)
- Assessment Event (1:many)
  - Assessment Tasks

The current code that works independently. This does the Facilities and Assessment Events.

With(
 Patch(Facilities, Defaults(Facilities), {
 'Facility Name': "CLONE " & Self.Selected.Item.'Facility Name'
 })As ClonedFacility,
 ForAll(Self.Selected.Item.'Assessment Events', Patch('Assessment Events', Defaults('Assessment Events'), {
 AssessmentTitle: "CLONE " & AssessmentTitle,
 Facility: ClonedFacility
 })))

What I need to have happen is then it also needs to clone the Assessment Tasks related to the Assessment Events. This code works by itself but the missing piece for me is getting them nested into one action.

With(ac
 Patch('Assessment Events', Defaults('Assessment Events'), {
 AssessmentTitle: "CLONE " & Self.Selected.Item.AssessmentTitle
 })As ClonedAssessmentEvent,
 ForAll(Self.Selected.Item.'Assessment Tasks', Patch('Assessment Tasks', Defaults('Assessment Tasks'), {
 'Assessment Event': ClonedAssessmentEvent,
 'Assessment Score': 'Assessment Score',
 AssessmentTask: AssessmentTask,
 Category: Category,
 Facility: Facility,
 'Methodology ': 'Methodology ',
 Sort: Sort,
 SubCategory: SubCategory
 })));
Notify("A copy of the selected Assessment Event, " & Self.Selected.Item.AssessmentTitle & ", has been created. Please open the record and update the necessary fields.")

Categories:

Building Power Apps