You’re offline. This is a read only version of the page.
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 ?
@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:
Share
Report
All responses (
Answers (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.
#1
WarrenBelz
177
Most Valuable Professional
#2
MS.Ragavendar
99
#3
stampcoin
80
