Answered

PowerApp update one, and only one, value in a record

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am having trouble trying to find and replace a value in a record. I have tried many combinations of Replace and Substitute, but to no avail. I can't seem to get it quite right.

The record is called myChosenLlist. myChosenList.items is a table nested within that record.

The myChosenList.items table looks like "Oregon, Washington, California, a". Note that the last value is just "a".

I want to change "a" to "Arizona", so the end result will be "Oregon, Washington, California, Arizona"

I want to set it to the renamedItemsList variable.

myChosenListItem is a variable with the value "Arizona" in this example.

The logic that I am using is:

Set(renamedItemsList,Substitute(Left(Concat(myChosenList.items,Value&", "),Len(Concat(myChosenList.items,Value&", "))-2),myChosenListItem,Trim(NewNameTextInput.Text)))

or, formatted

Set(
renamedItemsList,

Substitute(
Left(
Concat(
myChosenList.items,
Value & ", "
),
Len(
Concat(
myChosenList.items,
Value & ", "
)
) - 2
),
myChosenListItem,
Trim(NewNameTextInput.Text)
)
);

However, the result is now "Oregon, WArizonashington, CArizonaliforniArizona, Arizona". Note that the 1 a in "Washington" and the 2 a's in "California" are also substituted, which I do not want.

Am I approaching this incorrectly? Converting the table to string first, then substituting? Is there a cleaner way that works?

Thanks a lot in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

You could try using Split to do what you need? Split returns a single column table with 'Result' as the column name.

Here, I'm using Split on a string to create this table called colString:

Set( vString, "Oregon, Washington, California, a"); ClearCollect( colString, Split(vString,", "))

If you then add a gallery (galString) and set it's Items property to colString, you can then use UpdateIf() to do what you need:

ForAll(galString.AllItems, UpdateIf(colString ,Result="a", {Result: "Arizona"}))

Granted, this isn't the exact code you need but I think it will give you all the pieces you need to do this?

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Sorry for the long wait.
This is the code that I wrote.

ForAll( myChosenList.items, UpdateIf( myChosenList.items, Value = myChosenPicklistItem, {Value: NewNameTextInput.Text} ) ); Set( renamedItemsList, Left( Concat( myChosenList.items, Value & ", " ), Len( Concat( myChosenList.items, Value & ", " ) ) - 2 ) );

It works fine!

Thanks for the help!!

Was this reply helpful? Yes No