Patch function - Field required error even though field value is provided

[Anonymous]

In my app's OnStart PowerApps is telling me that a Patch command is failing due to a "Field required" error, i.e. I am not providing a value for a non-nullable column in my database (Azure SQL). As you can see below:

I know you are going to ask whether the ThisApplicationId variable has a value, so to make things clearer here it is with a constant value provided:

This is an export of an app that works fine in our production tenancy. I am getting this error in a trial environment in our non-prod tenancy, where I am looking to perform some testing. However because the AppStart process is failing, my tests are failing at the first hurdle.

I am also getting another Patch field required error elsewhere in the app, on a date field, despite that date being set to a date picker which definitely has a value, but that's another post for another day.

[v-yutliu-msft]

Hi @Anonymous ,

Could you tell me whether do you want to create a new record or edit an existing record?

Actually,  the right syntax of Patch function should be like:

Patch(table,Defaults(table),{....})   //create a new record

Patch(table,the item that you want to edit,{..})    //edit an existing record

While your formula is like: Patch(table,{Id:Blank()},{.....})

{Id:Blank()} can not represent an item that need to be edit.

Usually, we use LookUp() or First(Filter()) to represent the item that will be edit.

So if you want to create a new record, please try: 

Patch(table,Defaults(table),{....})

If you want to edit an existing record, please try: 

Patch(table,LookUp(table,Id=Blank()),{...})

What's more, please make sure that your SQL table has primary key. If it doesn't have primary key, you can not update this table in PowerApps.

Here's a doc about Patch function for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch

Best regards,

[Anonymous]

Thanks for taking the time to reply - I appreciate it.

Passing in a blank Id as I do (Id is the primary key) tells Patch to create a new record, and it's a pattern I use a lot. This works and has worked in production for a long time. I am just getting this error in my test environment for no apparent reason. My suspicion is that the error message being displayed is incorrect and covering up some other sort of error, but I have no way of proving that.

Anyway, using your preferred syntax I still get the same error:

[Anonymous]

OK so I seem to have solved this. As expected the error message was misleading - it was actually the UserId value that was missing (earlier in my script that value wasn't loading correctly for some reason).

So I guess the question is why was PowerApps claiming it was the ApplicationId that was missing?

[cowg843]

I had a very similar scenario. 

I tried patching using budget_id:thisitem.budget_id but the error said the budget_id was required. 

I believe I have figured it out. 

Power apps has a relatively new feature where fields have to be explicitly named to be fetched. Either turn this off or reference the field and it should work - it has for me.

[Anonymous]

@cowg843 @I am encountering a similar issue that the script showing "ID" is required. (I am trying to do a upsert)

May I ask what feature did you turn off to solve this issue?

[cowg843]

The setting is Explicit column selection, it is in preview. 

As I say, I switched this off and then patched using ThisItem.ID, which resolved my issue. 

Given this is in preview, hopefully this issue will be resolved before it is included in general release.