web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Using both Substitute ...

Power Apps

Answered

Using both Substitute and Proper syntax

(0) Share

Report

Report

Posted on by RM-30040732-0

551

Hi!

Can someone help me combine Substitute and Proper please? I can't get it to work - If I use both I get false instead of the wording!

The two statements I want to combine are:

Proper(DataCardValue1)

&

Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(DataCardValue1," ", ""),"!",""),"&",""),"'",""),"&",""),"#","")

Thanks in advance!

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @RMD211 ,

Like this

Substitute( Substitute( Substitute( Substitute( Substitute( Substitute( Proper(TextInput9.Text), " ", "" ), "!", "" ), "&", "" ), "'", "" ), "&", "" ), "#", "" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
RM-30040732-0 551 on at

Like
a
(0)

Report
Copy link

Link copied!

That's done it! Thanks so much!

Join the conversation