Answered

Substitute / with " "

(0) Share

Report

Posted on by Jk14

I have a form connected to a SharePoint list and I've added one of the fields (Contract Reference) which is a Data Input control.

Whenever someone copy pastes a text there containing a "/", I want it to automatically change the "/" to a " " (blank space).

Everywhere I look suggests to use this formula in the Default field: Substitute(ContractReference.Text, "/", " "). However, it says that .Text isn't a valid argument.

Can someone please help me figure out what is the issue with this formula? Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

v-mingkz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Jk14,
Could you please tell me what the type of fields (Contract Reference)?
If it is number Please try

Substitute(Text(ContractReference), "/", " ")

Best Regards,
Kyrie

Was this reply helpful? Yes No
timl 36,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Jk14 - In a form, you would access the field value through the ThisItem keyword like so:

Substitute(ThisItem.ContractReference, "/", " ")

Was this reply helpful? Yes No
Jk14 8 on at

Like (0)

Report
Copy link

Link copied!

Hi!

the field is set as a text (single line of text).
I've tried the formula and it says that it expects a text and not the field name (contract reference).

Was this reply helpful? Yes No
Jk14 8 on at

Like (0)

Report
Copy link

Link copied!

Hi!

Thank you for the explanation, I has actually tried that one before, and while I don't get any errors, it simply doesn't work. The "/" remain there in the text.

Was this reply helpful? Yes No
v-mingkz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Jk14
Could you please show some screenshots about your control?

Was this reply helpful? Yes No
Jk14 8 on at

Like (0)

Report
Copy link

Link copied!

@v-mingkz-msft

Here are the screen shots. thank you for the help.

Was this reply helpful? Yes No
Verified answer

v-mingkz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
@Jk14
You can set the OnChange property of DataCardValue1 as:
Set(var,Substitute(DataCardValue1.Text, "/", " "))
And set the Default property as:
var

Was this reply helpful? Yes No
Jk14 8 on at

Like (0)

Report
Copy link

Link copied!

Thank you @v-mingkz-msft. It worked!

Was this reply helpful? Yes No