web

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

News and Announcements icon

Power Platform CommunityForums Power Apps It is possible to use ...

Power Apps

Unanswered

It is possible to use the Substitute function to replace a part of a string in all the rows of a sharepoint list

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

How are you, I would like to know if this is possible, what happens is that I have a field in which initially the data is taken from a combobox to text, concatenating what the user chooses with commas, the field is more or less as follows

Text1,Text2,Nancy,Andres,Pedro,Carlos,Juan,Lucia

and so several rows with different texts

I would like to know if it is possible with the function for all () to go through all the elements of the list and update this part of the string with a new name, for example, where there is only Andres in all the rows of the list, update it for Camilo

Is this possible plus the patch + substitute function for example to update only that part of the string ?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
@Anonymous

Yes, but your statement implies using the ForAll incorrectly. ForAll is a function that returns a table - it is not a for loop function.

So, your ultimate formula would be similar to the following:

Patch(yourDataSource, Filter( ForAll(yourDataSource, If("Andres" in yourColumnName, {ID: ID, yourColumnName: Substitute(yourColumnName, "Andres", "Camilo") } ) ), !IsBlank(ID) ) )

In the above, the ForAll creates a table to pass to the filter (in order to remove blank records based on the If statement) which then returns the table of records to "fix" for patch.

I hope this is helpful for you.

Was this reply helpful? Yes No

Join the conversation