override sharepoint list item in canvas app

(0) Share

Report

Posted on by varun123

HI ,

Have a quick question regarding overriding the sharepoint list item by using power apps

in below example for an instance if users enter same ID with some comments instead of giving different line item can we override or remove old one and replace it with new comment?

any help would be highly appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @varun123

Yes it is posible, you can use Patch() function for this.
To update your record you will need to put forumla your Button.OnSelect property:
Patch( YourSharePointList, LookUp(YourSharePointList,IDColumn = IdentificationVariable), { ColumnComment:TextBox1.Text } )

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
varun123 14 on at

Like (0)

Report
Copy link

Link copied!

hey thanks for the response what is Identification variable? do have script already in on select like below where do i write above script?

Was this reply helpful? Yes No
SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
You need to change the Defaults() to a LookUp()
Documentation says: You can combine the Defaults function with the Patch function to create a record.
It will not update the existing record.

I think something like this:

Patch( TestList, LookUp(YourSharePointList,MOID = TestList[@MOID]), {MOID: DataCardValue12.SelectedText.MO_ID}, {FUID: DataCardValue13.SelectedText.FU_ID}, {Lob: DataCardValue14.SelectedText.Value}, {Comments: DataCardValue10.Text} );

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
varun123 14 on at

Like (0)

Report
Copy link

Link copied!

HI,

Thanks for your reply am getting an issue like "Error in retrieving data from network"

any ideas please?

Was this reply helpful? Yes No