Categories: Microsoft Office 365

Better Formula-level error Management and Power Apps Patch

Have you tried the Power Apps Patch function to update list items with formula-level error management enabled?

Required fields in SharePoint

In SharePoint you always have to consider the required fields when you update list items. However when you update or create a list item with the patch function you will find that required fields are simply marked as required in SharePoint however the Patch will still work.

So even though I didn’t fill in a required field in my Patch function. The SharePoint list item is still created. This is without enabling the error handling in Power Apps.

Formula-level error management

Notice that Formula-level error management is still one of the experimental features. However you can enable it quite easily within the settings of your app.


Important is also that you save your app and then restart the Power Apps studio so that the app is restarted with the new setting.

Patch with the Formula-level error management enabled

Once you have enabled Formula-level error management however you will find that the Patch fails and Power Apps complains that there is a required field.

This is one thing that you do need to be aware off when you try the Formula-level error management feature. With this feature enabled the SharePoint connector seems to be less forgiving of your mistakes.

See Also

https://powerapps.microsoft.com/en-us/blog/new-feature-error-handling-and-writing-null-values-to-databases/

Share
Pieter Veenstra

Business Applications and Office Apps & Services Microsoft MVP working as a Microsoft Productivity Principal Consultant at HybrIT Services. You can contact me using contact@veenstra.me.uk.

View Comments

Recent Posts

Create a Microsoft Teams team template

Recently I was asked about creating a team template in Microsoft Teams and apply this…

1 week ago

Who is in the office tomorrow, using Power Automate?

Do you want to know who is in the office tomorrow or the day after?…

2 weeks ago

8 top reasons to use Dataverse or SharePoint lists in the Power Platform

Why would you use Dataverse, if SharePoint lists gives you the option to avoid premium…

4 weeks ago

Filter by calculated fields in SharePoint using Power Automate

When you read items from a SharePoint list and you want to filter by calculated…

4 weeks ago

Expected String but got Null, when calling a flow from a Model Driven app

A few weeks ago I looked at calling flows from model driven apps. And for…

1 month ago

Get all your broken connections using Power Automate

To get all your broken connections in the Power Platform can be a challenge. In…

1 month ago
%%footer%%