web

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

News and Announcements icon

Power Platform CommunityForums Power Apps need to patch or updat...

Power Apps

Answered

need to patch or update only the first record of the first column of a sharepoint list.

(0) Share

Report

Report

Posted on by Sormick

566

Hi,

i need to patch or update only the first record of the first column of a sharepoint list. i don't want to add new records each time.

Please find my current formula:

Patch(
 Renommagesavepower;
 LookUp(Renommagesavepower; ID=1);;
 {
 Titre: varCounter
 }
)

How to save my variable "Varcounter" to only first line of my sharepoint list Renommagesavepower ?

Could you also help me to know what is the formula also to get my saved variable on the first line of sharepoint list on a label on my power app?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Sormick,

After LookUp the code only requires 1 semicolon instead of 2. After this adjustment, your code should work as long as a record with ID 1 exists within that list. Alternatively you could try:

Patch( Renommagesavepower; First(Renommagesavepower); { Titre: varCounter } )

In order to display this value on a label, use the following code in the Text property:

LookUp(Renommagesavepower; ID=1).Titre //Alternatively First(Renommagesavepower).Titre

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Sormick 566 on at

Like (0)

Report
Copy link

Link copied!

Thank you!

Was this reply helpful? Yes No

Join the conversation