Patch command error - Invalid argument

(0) Share

Report

Posted on by JOSHAX112

Hi all,

I have a power app that is being used by our business.

I have created a simple feedback page with a Input text field and Submit button.

I believe the patch command is the correct command to take the text that is inputted and enter it into a SharePoint list.

However I get formula error , The function 'Patch' has an invalid argument.

 Patch(
 PowerAppFeedback,
 Defaults(PowerAppFeedback),
 {
 TimeLogged: Text( Now(), "mm/dd/yyyy hh:mm:ss"),
 Comment: FeedbackInput.Text,
 Employee: 
 {
 '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
 Claims: "i:0#.f|membership|" & currentUser.Email,
 Department: "",
 DisplayName: currentUser.FullName,
 Email: currentUser.Email,
 JobTitle: "",
 Picture: ""
 }
 
 }
 );
Set(
 successMessage,
 "Feedback Submitted"
);Refresh(Feedback); 
Navigate(Success)

Any help will be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

There are several places where your Patch could have an issue, and it is most likely with a reference to a control's value. Could you share a screenshot of the error message and where in the statement the editor is flagging the problem?

Also, you may want to consider different logic around your Set() statement. As it stands now, it will execute no matter what happens with the Patch().

Bryan

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JOSHAX112,

Have you solved your problem?

Could you please tell me that if TimeLogged is a Date and time column or Text column?

If TimeLogged is a Date and time column, you could not use the Text() to save the format data string. To change the data time display format, you could only change it in your SharePoint Site Settings>Regional Settings.

By default, SharePoint Sites display the dates in US format (MM/DD/YYYY). So just choose the correct region as yours expected data display format.

In addition, you could consider removing your currentUser(guess it is a variable) and replace it with User() instead.

Patch( PowerAppFeedback, Defaults(PowerAppFeedback), { TimeLogged: Now(),// Assume that you have a Date and time column Comment: FeedbackInput.Text, Employee: { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & User().Email,// Try to replace with User(). Department: "", DisplayName: User().FullName, Email: User().Email, JobTitle: "", Picture: "" } } ); Set( successMessage, "Feedback Submitted" );Refresh(Feedback); Navigate(Success)

Was this reply helpful? Yes No