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."}
);
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.
Hope this gives you some inspiration during your troubleshooting.