Unanswered

Columns in UpdateIf() doesn't work without ' '

(0) Share

Report

Posted on by Pedro_Henrique

Hi guys, I'm having a problem with my UpdateIf() it's not sending the data to my SharePoint List and it changes all the rows too, also, I wish to know what defines the column inside the UpdateIf() to have the ' ' , gonna send a generic code just for you guys see what I'm saying. Also, a have a few Columns that are from choice type

Heres is the code ->

UpdateIf('SharePointList',ID=Form.LastSubmit.ID,

{
Column:{Id: 1, Value:If(Icon_Name.Icon = Icon.Send,DropDown.Selected.Value,First(Filter('SharePointList',ID = id)).Column.Value,

'Column_2': DropDown2.Selected.Value
}

)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,397 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Pedro_Henrique ,

If you are only updating one record, Patch is a better option - also Choice columns do not need an ID. Try this (I am not sure where you are getting id from for the reference)

Patch( 'SharePointList', { ID: Form.LastSubmit.ID, Column: { Value: If( Icon_Name.Icon = Icon.Send, DropDown.Selected.Value, LookUp( 'SharePointList', ID = id ).Column.Value ) }, 'Column_2': DropDown2.Selected.Value } )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Pedro_Henrique 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Good morning sir, I'll try your solution. Just for answer your doubt, the id it's a variable that was set inside the .OnSelect property from a few Buttons that are inside a Gallery, this variable is set the same way inside every button

Sintax: Set(id,ThisItem.ID)

And about the other doubt, do you sir have an explanation for some columns inside the UpdateIf() use or not use the '' ? Thanks for the answer in advance 🙂

Was this reply helpful? Yes No
WarrenBelz 156,397 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Pedro_Henrique ,

I have never needed to use ' ' around field or data source names unless they contained spaces or special characters, however using them will work in all cases.

Was this reply helpful? Yes No