web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Patch with Managed Met...
Power Apps
Suggested Answer

Patch with Managed Metadata type

(0) ShareShare
ReportReport
Posted on by 45
I have a patch function that creates new records in a Sharepoint list. It works well. However, it does not work when I do not populate the "Trade" Managed Metadata field. *Note this is not a required field in the list. Any ideas why this is happening?
 
Patch(
    'List-Evidence_Tracker',
    Defaults('List-Evidence_Tracker'),
    {
        CriteriaID: LookUp(
            'List-Criteria',
            Criteria = DataCardValueEvCriteria.Selected.Value,
            ID
        ),
        EvidenceTypeID: LookUp(
            'List-EvidenceType',
            Title = DataCardValueEvType.Selected.Value,
            ID
        ),
        'Evidence-Title': DataCardValueEvTitle.Text,
        'Link to Evidence': DataCardValueEvLink.Text,
        ResponsibleID: LookUp(
            'List-Responsible',
            Title = DataCardValueEvResponsible.Selected.Value,
            ID
        ),
        Trade: {
            '@odata.type': "Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy",
            TermGuid: DataCardValueEvTrade.Selected.TermGuid,
            WssId: DataCardValueEvTrade.Selected.WssId,
            Label: DataCardValueEvTrade.Selected.Label,
            Path: DataCardValueEvTrade.Selected.Path,
            Value: DataCardValueEvTrade.Selected.Value
        },
        Subcontractor: DataCardValueEvSubcon.Text,
        'Planned Collection Date': DataCardValueEvPlannedDate.SelectedDate,
        'Actual Collection Date': DataCardValueEvActualDate.SelectedDate,
        'Submitted to ESDC?': DataCardValueEvSubmitESDC.Value,
        'Collection Status Comments': DataCardValueEvComments.Text
    }
);
If(
     // check if there were any errors when the item was submitted
    !IsEmpty(Errors('List-Evidence_Tracker')),
     // if true, show any error message
    Notify(
        "Criteria submission failed",
        NotificationType.Error
    ),
     // else, go to success screen
    ResetForm(frmAddEvidence);
    Navigate(scrnMainScreen);
   
);
I have the same question (0)
  • ronaldwalcott Profile Picture
    3,862 Moderator on at
    Are there any dependencies on this field?
  • MZ-18110459-0 Profile Picture
    45 on at
    No dependencies. It is a Term Store that is used to populate a drop down list on the form. It is not a required field, so it should be ok to leave it blank/unselected for the patch. 
    Thanks,
    Maria.
  • Suggested answer
    CA1105 Profile Picture
    545 Moderator on at
    Would you pls try to patch that field as null and see what happen? I think it should work but I wanna see the results.
  • MZ-18110459-0 Profile Picture
    45 on at
    Forgive my ignorance as I am still learning, how do I pass a null to the Trade column?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 531 Most Valuable Professional

#2
Haque Profile Picture

Haque 261

#3
Kalathiya Profile Picture

Kalathiya 221 Super User 2026 Season 1

Last 30 days Overall leaderboard