Patch Issues

(0) Share

Report

Posted on by GF-02121351-0

239

Hi,

I have a store app that keeps returning an unknown error message when I click the button that is patching the data to the Dataverse Table. Any ideas?

Patch(
 'BeneStore Customer Details',
 Defaults('BeneStore Customer Details'),
 {
 Name: "Store Visit",
 FirstName: TextInputFirstName_1.Text,
 LastName: TextInputLastName_1.Text,
 Email: TextInputEmail_1,
 Address: AddressInput2_1,
 PhoneNumber: TextInputPhone_1,
 'Number of Children': NumberofChildren,
 'Child 1 Date of Birth': TextInputChildDOB_1,
 'Child 2 Date of Birth': TextInputChildDOB_2,
 'Child 3 Date of Birth': TextInputChildDOB_3,
 'Child 4 Date of Birth': TextInputChildDOB_4,
 'Child 5 Date of Birth': TextInputChildDOB_5,
 'Child 6 Date of Birth': TextInputChildDOB_6,
 'Child 7 Date of Birth': TextInputChildDOB_7,
 'Child 8 Date of Birth': TextInputChildDOB_8,
 'Child 9 Date of Birth': TextInputChildDOB_9,
 'Child 10 Date of Birth': TextInputChildDOB_10
 }
)

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi

Check the data source: Ensure that the data source ('BeneStore Customer Details' in this case) is properly connected and accessible. Verify the connection settings and permissions to make sure you have the necessary rights to perform the patch operation.

Validate field names: Double-check that the field names used in the Patch function match the actual field names in the 'BeneStore Customer Details' table. Ensure there are no typos or discrepancies in the field names.

Verify data types: Confirm that the data types of the values being patched match the expected data types in the 'BeneStore Customer Details' table. For example, if a field expects a number, make sure you are passing a number and not a string.

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.
Nehal3 32 on at

Like
a
(0)

Report
Copy link

Link copied!
Try the following. If it works please hit the thumbs up and accept it as a solution.

ame: "Store Visit", FirstName: TextInputFirstName_1.Text, LastName: TextInputLastName_1.Text, Email: TextInputEmail_1.Selected Address: AddressInput2_1.Selected, PhoneNumber: TextInputPhone_1.Selected, 'Number of Children': NumberofChildren.Selected, 'Child 1 Date of Birth': TextInputChildDOB_1.SelectedDate, 'Child 2 Date of Birth': TextInputChildDOB_2.SelectedDate, 'Child 3 Date of Birth': TextInputChildDOB_3.SelectedDate, 'Child 4 Date of Birth': TextInputChildDOB_4.SelectedDate, 'Child 5 Date of Birth': TextInputChildDOB_5.SelectedDate, 'Child 6 Date of Birth': TextInputChildDOB_6.SelectedDate, 'Child 7 Date of Birth': TextInputChildDOB_7.SelectedDate, 'Child 8 Date of Birth': TextInputChildDOB_8.SelectedDate, 'Child 9 Date of Birth': TextInputChildDOB_9.SelectedDate, 'Child 10 Date of Birth': TextInputChildDOB_10.SelectedDate
Nehal3 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Apologies, your dates are text, so use .Text instead of .SelectedDate. Should work - just tested it.
GF-02121351-0 239 on at

Like
a
(0)

Report
Copy link

Link copied!

No worries, I made those changes and now I am getting this error: The requested operation is invalid. Server Response: BeneStore Customer Details failed: Error identified in Payload provided by the user for Entity :'cr0d7_benestorecustomerdetailses'

Everything is spelled correctly, I refreshed that database, deleted and reconnected the Dataverse table and closed and reopened the app.