Answered

Patching Lookup Fields...

(0) Share

Report

Posted on by JasonD

I have a deliverable list that has a lookup field for the status that I have been patching without an issue. Over the weekend I altered the lookup to include other fields that denote if that status is included in certain filters.

The fields are listed as required but also read only, but I am getting an error that states that I must enter something in that field when I try and patch.

What must one do to push data to a "required but read only" field for a lookup?

Here is what has worked for that field so far:

Status:
        {
            Value: "In Progress",
            Id: 4
        }

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Sam_Fawzi 917 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ JasonD,

can you share the error message you are getting the data sources that you are using and full patch syntax.

Was this reply helpful? Yes No
JasonD 60 on at

Like
a
(0)

Report
Copy link

Link copied!

The error message is stating that the pending field is required. the data source is sharepoint.

The patch syntax is correct as it has been working for months and the only change that has been made was me including more fields on the lookup field.

Was this reply helpful? Yes No
JasonD 60 on at

Like
a
(0)

Report
Copy link

Link copied!

Patch call that worked before adding the extra fields to the lookup:

//Add Project header to table

Patch(ProjectDeliverables,

{

Project:

{

Id: Value(First(referencedProject).ID),

Value: First(referencedProject).ProjectName

},

DeliverableType:

{

Id: 17,

Value: "Header"

},

DeliverableOrder: LookUp(localDeliverableTypes, Type="Header").Order,

RowOrder: 0,

RowType:

{

Value: "Header"

},

Status:

{

Value: "In Progress",

Id: 4

},

DeliverableDataDef:

"{

""Updates"":

{

""Last"": """",

""Next"": """ & Text(DateAdd(Today(), 14 + (4-Weekday(Now()))), "m/d/yyyy") &"""

},

""Freight"": " & wizFreightTotal & ",

""Bonded"": false

}"

}

);

Was this reply helpful? Yes No
JasonD 60 on at

Like
a
(0)

Report
Copy link

Link copied!

I added the Defaults(Datastore) call to the patch method and nothing changed. I am sure that I can change the lookup field to not be required and that will address the issue, but I do not want to lift that restriction as the status field is required based on the business logic.

Was this reply helpful? Yes No
Verified answer

JasonD 60 on at

Like
a
(1)

Report
Copy link

Link copied!
I was able to enact a fix for this...

The root of the problem was the Status field was set to required. When I added the other lookup fields (ToDo, Pending and Action) they too came over as required. Problem is these other fields are also read-only. So you have a field that requires you to enter information, but will fail if you enter information as it is read only.

Solution:

Remove the added lookup fields.

Set the initial lookup with just the one field to not be required.

Go back and add the extra lookup fields

Go back and set the original field to be required

Bring up the list settings to verify that the original lookup is required and the others that were added are still set to not be required.

I have tested the patch function after putting it back to what it was earlier and it is working.

Was this reply helpful? Yes No