web

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

News and Announcements icon

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

Power Apps

Answered

Replace/Substitute all values in a Collection Column

(0) Share

Report

Report

Posted on by christian12

204

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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-liwei-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @christian12

Please modify your formula to:

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

Best Regards,

Levi

Was this reply helpful? Yes No
christian12 204 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No

Join the conversation