Power Platform Community Forum Thread Details

Background

One [Estimate] to many [Project Mat]
One [Estimate] to many [Production Item]

Project Mats have Units (decimal) and a Name (string).

Production Items have Units (decimal).

Challenge:

When in the [Estimate] main form, I want to be able to click a button that will create a new associated [Production Item], based on the properties of the first associated [Project Mat].

I created a Command Bar Power Fx button with this code:

With(
    {ProjectMat:First(Self.Selected.Item.'Project Mats')},
    Patch(
        'Production Items',
        Defaults('Production Items'),
        {
            Estimate: Self.Selected.Item,
            Units: ProjectMat.Units,        
            'Text Test': Text(ProjectMat.Name)
        }
    )
)

The Problem:

The newly created [Production Item] is correctly associated with the [Estimate], but Units and Text Test properties are always empty!

Note that all Project Mats have values for Name and Units.

Any thoughts?

Suggestions to troubleshoot this will help me as well, because since my code is inside the DefaultCommandLibrary Component Library of the solution, I can't use Canvas App monitor to try figuring this out.

Thanks,

Gil

Categories:

Using Apps Using Formulas