Create or Update if exist a row

(0) Share

Report

Posted on by nagestiada

504

I have this code but only updates a row if a row does not work, so I used if statement and lookup if exist it will patch if not collect. But seems it's not working.

If(LookUp('ItemList', Title = ID.Text),
Patch(ItemList, LookUp('ItemList', Title = ID.Text), {
 Title: ID.Text,
 ENM: ENM.Text, 
 CNM: CNM.Text,
 }),

Collect(ItemList, {
 Title: ID.Text,
 ENM: ENM.Text, 
 CNM: CNM.Text,}))

Is this okay to use or is there another way of doing this? Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@nagestiada
You are simply missing the logical comparison in the 1st argument of your IF statement.

If(
!IsBlank(LookUp('ItemList', Title = ID.Text)),

Patch(ItemList, LookUp('ItemList', Title = ID.Text), {
Title: ID.Text,
ENM: ENM.Text,
CNM: CNM.Text,
}),

Collect(ItemList, {
Title: ID.Text,
ENM: ENM.Text,
CNM: CNM.Text,
})
)

Was this reply helpful? Yes No