The requested operation is invalid. Server Response: A value must be provided for item. clientRequestID: ...

(0) Share

Report

Posted on by WebPortal

2,297

I've seen a lot of other posts like this, so I guess this is a common problem, but, I'm unable to fix it!

All I want is a multi-screen app that collects data from a bunch of fields and fills in an Excel table, nothing more than a basic form.

This is what I have:

Anotação 2020-04-27 121306.jpg

The error I get when clicking the button is:

"The requested operation is invalid. Server Response: A value must be provided for item. clientRequestID: ..."

But what is wrong with this button?

Thanks for helping!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @WebPortal ,

Could you please share more details about the application scenario? Do Sec4 and Sec5 submit data to the same record?

There may be several factors contributing to this error. We need more information about two edit forms and their data sources.

To work around this, please first check that the required fields for the data source are being submitted on the form. If this still doesn't work, try to re-create a new excel table as the data source of EditForm to see if the issue is fixed.

Hope this helps.

Sik

Was this reply helpful? Yes No
WebPortal 2,297 on at

Like (0)

Report
Copy link

Link copied!

Hello, Thanks for the feedback, I think the problem is related to the submission to the same record (row) of the table.
How to control that?

Thanks!

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @WebPortal ,

I would suggest you try this code instead of two SubmitForm funcitons, replace <> part by the Item property of EditForm.

Patch('Table Name', <Item property of Form put here>, Sec4.Updates, Sec5.Updates )

It will save two Forms' data to the specific record at the same time. Please have a try to see if it works for you.

Sik

Was this reply helpful? Yes No
WebPortal 2,297 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-siky-msft

The Item property of the form is empty.
Since this is a multi-page form connected to a single Excel table, it should identify the row being edited, but how?

Thanks

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @WebPortal ,

OK. If the Items property is blank, it seems that Form mode is New and you want to submit two Form data to a new record, so there is no need for row identify, and try this:

Patch('Table Name',Defaults('Table Name'), Sec4.Updates, Sec5.Updates )

Hope this helps.

Sik

Was this reply helpful? Yes No