web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps The request operation ...

Power Apps

Answered

The request operation is invalid.

(0) Share

Report

Report

Posted on by Jose_LuisA

31

Hi yall!

Im having an issue, but first let me explain my app and my code

What im trying to do is basically an app to check if the information that its uploaded from another app to my azure sql database is correct

What im thinking its to have a gallery with a check box, and check only those that are correct, and after checking the ones that are correct I want to patch a column in this database that register the name of the usser in a column, to see who check the information

So my formula goes like this

If(Checkbox1.Value = true, Patch(tblDataBase,Gallery1.Selected, {CheckColumn: USER}))

But when I try to patch like this, the formula displays an error that says:

The request operation is invalid. Server Response: tblDataBase failed. A Value must be provided for item. clientRquestId

Im kinda lost in this

Any help would be much apreciated

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Jose_LuisA ,

May be something like below might work in your case.

If(Checkbox1.Value = true, UpdateIf(tblDataBase, ID=ThisItem.ID, {CheckColumn: User().Email})) Or ForAll(Filter(Gallery1.AllItems,Checkbox1.Value = true),Patch(tblDataBase,Defaults(tblDataBase),{CheckColumn: User().Email}))

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Jose_LuisA ,

It's because you actually have not select any item when check the check box of this item in the gallery.

To achieve your need, you could leverage the OnCheck and OnUncheck properties of the check box:

OnCheck:

Patch(database, ThisItem, {CheckColumn: USER})

OnUncheck:

Patch(database, ThisItem, {CheckColumn: Blank()})

So once check will write current user into SQL data base and once uncheck will clear it.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No

Join the conversation