Unanswered

Network error when using Patch function: Field 'Title' is required.

(0) Share

Report

Posted on by Vianka26

Good day

I have an awards app that is connected to an MS SharePoint DataSource, I am trying to update an existing record, on the first try (Clicking the save button) my patch runs into this error:

How ever when I click the save button again the patch runs successfully, and the updates are made to my MS SharePoint DataSource.

I have renamed the Title column in my SharePoint to "NominationID" which needs to be a required field.

Here is the code I am making use off:

Patch(

Summary_1,

If(IsBlank(_oldRecord), Defaults(Summary_1), _oldRecord),

{

NominationID: vNomination,

'Sum Score': vAverage,

'Members Score': vPanelMem,

//Category: {Id:LookUp(Category,Title= vCategory,ID),Value:vCategory},

NominationCategory:vCategory

}

);

May someone please assist me

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hey @Vianka26

title column always follow the titel name so try with title instead of the renamed name.

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
Vianka26 4 on at

Like (0)

Report
Copy link

Link copied!

Thank you @mmbr1606 for your prompt reply

I had changed it back to Title, however it is still giving the same error and still the same outcome, on the first click of the save button it through's the error, but when you click the save button again it is successful.

Was this reply helpful? Yes No
Meekou on at

Like (0)

Report
Copy link

Link copied!

Based on the error message, it seems "vNomination" is empty for the first operation. Could you add a "notify(vNomination)" before Patch to check whether vNomination is empty? In addition, not sure your value for _oldRecord, try to split the two condition and test which condition throw this error.
Best Regards,
Meekou
YouTube
PowerApps
PowerAutomate

Was this reply helpful? Yes No
Vianka26 4 on at

Like (0)

Report
Copy link

Link copied!

@Meekou

Here is the code under my Save Button, Additionally I made the text related to _oldRecord in Red for easier retrieval

Clear(colNominations);
//Clear(colSubmissions);
Patch(
Adjudication_1,
ShowColumns(
colScores,
ID,
'Criteria 1',
'Criteria 2',
'Criteria 3',
'Criteria 4',
'Criteria 5'
)
);
//Set(mySelectedRecord, Gallery7_1.Selected);
Collect(
colNominations,
Filter(
Adjudication_1,
'Nomination Link'.Value = Gallery7_2.Selected.'Nomination Link'.Value
)
);
Set(
vAverage,
Blank()
);
Set(
vAverage,
Average(
colNominations,
Total
)
);
Set(
vNomination,
Blank()
);
Set(
vNomination,
Gallery7_2.Selected.'Nomination Link'.Value
);
Set(
vPanelMem,
Blank()
);
Set(
vPanelMem,
Concat(
colNominations,
'Panel Member'.DisplayName & ":" & Value(Total) & Char(10)
)
);
Set(
vNominees,
LookUp(
Nominations,
Reference = Gallery7_2.Selected.'Nomination Link'.Value
).Nominees
);
Set(
vCategory,
Blank()
);
Set(
vCategory,
Gallery7_2.Selected.'Nomination: Category'.Value
);

//Collect(colSubmissions,{Title:vNomination,MemberScore:vPanelMem,SumScore:vAverage,Category:vCategory});
Set(
_oldRecord,
LookUp(
Summary_1,
Title = vNomination
)
);

//Set(varCategory, LookUp(Category, Title = vCategory));
Patch(
Summary_1,
If(IsBlank(_oldRecord), Defaults(Summary_1), _oldRecord),
{

Title: vNomination,
'Sum Score': vAverage,
'Members Score': vPanelMem,
//Category: {Id:LookUp(Category,Title= vCategory,ID),Value:vCategory},
NominationCategory:vCategory

}
);
Notify(
"Successfully Updated Nominations Scores",
NotificationType.Success,
3000
);
Clear(colScores);
Set(
_oldRecord,
Blank()
);

Was this reply helpful? Yes No