How to: not to get stuck on the required fields when creating a Power Automate Flow

By | January 7, 2021

Microsoft Dataverse has a somewhat unique interpretation of what a “required” field is.

It’s a bit of “do as I say not as I do”.

For example, I can’t create an account in the user interface not having “account name” populated (since it’s a required field):

image

But, of course, behind the scene… whether through Excel import or through API, for instance… I can still clear those required fields:

image

That’s always been like this, but, now, how do we bypass “required field” validation when creating a record through Power Automate Flow? Sometimes, there is no field value I can populate through the automation.

image

That was bugging me for a while till I tried using “null” for such fields. Not sure what hit me this time, and why did not I do it before, but it worked right away:

image

image

image

Well, that will save me some troubles moving forwardSmile

5 thoughts on “How to: not to get stuck on the required fields when creating a Power Automate Flow

  1. Ralph Soto

    Null only works on create event. When you need to update the record you do not want to use null as you will override the data that is there.

    I usually set all fields that are set to required to optimal. I use Java Script to set the field to require.

    This will allow users to use power automate or classic workflows without required fields.

    Reply
    1. Alex Shlega Post author

      That’s a viable alternative, but I’m, usually too lazy for that. And, besides, sometimes those fields are not in “my” solution, so changing current requirement level is not always an option.

      Although, that said, “Update” action (in both classic workflows and Power Automate) does not expect us to provide values for required fields – this is more of an issue for “create”.

      Reply

Leave a Reply to Ralph Soto Cancel reply

Your email address will not be published. Required fields are marked *