Answered

Sharepoint List: automatic search and replacement of elements via PowerApps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everyone,

I have several SharePoint lists. I want to build a menu that allows you to replace old names with new names. By clicking on a button, the Sharpepoint lists should first be filtered by the old name and then the old name should be replaced by the new one.

The following is my current code. This also works, but only for 1 element at a time. But I would like the name substitution to be carried out directly on all associated lines by clicking on the button. Unfortunately I can't get it to work...

TextInput3 corresponds to the old name, TextInput4 to the new name, the variable BewerteteAbteilung corresponds to the column in the sharepoint lists that contains the name.

If(
!IsBlank(TextInput4.Text) &&
!IsBlank(LookUp('Sharepointlist1'; BewerteteAbteilung = TextInput3.Text));

Patch(
'Sharepointlist1';
LookUp('Sharepointlist1'; BewerteteAbteilung = TextInput3.Text);
{ BewerteteAbteilung: TextInput4.Text }
);;

Patch(
'Sharepointlist2';
LookUp('Sharepointlist2'; BewerteteAbteilung = TextInput3.Text);
{ BewerteteAbteilung: TextInput4.Text }
);;

Patch(
'Sharepointlist3';
LookUp('Sharepointlist3'; BewerteteAbteilung = TextInput3.Text);
{ BewerteteAbteilung: TextInput4.Text }
);;
Set(Var_Haken;true);
Set(Var_Kreuz;true)
);;
Reset(TextInput3);;
Reset(TextInput4)

I use the German version of PowerApps. That's why , here are ;

Thanks in advance

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

MarkRahn 1,424 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous

I took a look at what you were trying to do. It is an interesting problem. While I would think that we could get Patch to work, I think you should switch to using UpdateIf.
https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-update-updateif

Change your Patch from:

Patch( 'Sharepointlist1'; LookUp('Sharepointlist1'; BewerteteAbteilung = TextInput3.Text); { BewerteteAbteilung: TextInput4.Text } );;

To UpdateIf

UpdateIf( 'Sharepointlist1'; BewerteteAbteilung = TextInput3.Text; { BewerteteAbteilung: TextInput4.Text } );;

I did a test and it seemed to work as you needed.

-Mark
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @MarkBandR , it solved my problem! 😊