News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Replace/Substitute all...

Power Apps - Building Power Apps

Answered

Replace/Substitute all values in a Collection Column

(0) Share

Report

Report

Posted on by christian12

178

Hi Guys,

I want to find and replace a string in all rows in a particular column.

For example replace the string "be" with "" for all values in column "Task".

Tried the below code although doesn't work.

UpdateIf(Col,
"be" in Task,
{Task: Substitute( "Task", "be", "" ))}
)

Any help is greatly appreciated.

Thanks

Categories:

General Questions

Using Apps Using Formulas

All responses Img

All responses (2)

Answers Img

Answers (1)

christian12 178 on at

Like (0)

Report

Re: Replace/Substitute all values in a Collection Column

@v-liwei-msft thanks.

Just wanted to confirm that this function is available and thats the correct formula structure. I will give it a try and hopefully i get the correct results.
Verified answer

v-liwei-msft on at

Like (1)

Report
Re: Replace/Substitute all values in a Collection Column

Hi @christian12

Please modify your formula to:

UpdateIf(Col, "be" in Task, {Task: Substitute(Task, "be", "" )} )

Best Regards,

Levi