Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Managed Metadata column was not submitted in the SharePoint List if I have a flow running in the OnSuccess function of the Power Apps form

(0) ShareShare
ReportReport
Posted on by 34

Hi Community,

 

I have met an issue when I was building a Power App Canvas app. After the form submission (Form1.Submit()), the data in the managed metadata columns are not submitted to the SharePoint list. After investigation, I found that, if I remove the Power Automate flow from the "OnSuccess()" function of the form, then the data of those columns can be saved to the SP List. However, they won't be saved if the flow remains in the "OnSuccess()" function.

 

Do you know why this happens and how this can be resolved?

 

Here is the formula running in the OnSuccess:

 

// Update another list with the form's title and collection's content

ForAll(
   MyCollection,
   Patch(
      'Another SP List',
      Defaults('Another SP List'),
      {
            Reference: Form1.LastSubmit.Title,

            Content: CollectionContent
      }
   )
);

 

// Trigger the flow to run using the ID of the form as a parameter
'myflow'.Run(Form1.LastSubmit.ID);

 

// Navigate to the success screen with a message
Navigate(
   SuccessScreen,
   ScreenTransition.Cover,
   {varSuccessMsg: "Your form has been submitted successfully."}
);

  • Verified answer
    willyzh Profile Picture
    willyzh 34 on at
    Re: Managed Metadata column was not submitted in the SharePoint List if I have a flow running in the OnSuccess function of the Power Apps form

    After further investigation by looking into the version history of the SP List item, it turns out that the fields were actually saved, but made blank by the flow's "Update Item" action.

     

    To solve this issue, I had to go inside of the flow, locate to the "Update Item" action, and for all the Managed Metadata columns, click the "down arrow" icon, select "Enter custom value" and remain the field as blank. This will indicate that no change to this field, otherwise the action will think I meant to update it as blank.

     

    willyzh_0-1627315921650.png

     

    Hope this gives you some inspiration during your troubleshooting.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard