Combining text formulas

(0) Share

Report

Posted on by slhangen

356

Need to set a default value of a datacard.

Currently I have Substitute(varSupplementalNumber.Title, "IH", "SP") which works fine.

But now I need to add to the formula, I need to replace the last 2 values (at the 15 position) of the new text string with the Users initials (set on App Start as varUserInitials).

I think both of these work but I have no idea on how to combine.

Substitute(varSupplementalNumber.Title, "IH", "SP")

Replace(varSupplementalNumber.Title, 15, 2, varUserInitials)

Thx community!

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

KrishnaV 5,023 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @slhangen ,

Try this:
Substitute(Replace(varSupplementalNumber.Title, 15, 2, varUserInitials), "IH", "SP")

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @slhangen

The combining of formula depends on the action you want to perform first.

If you want to perform Replace action first, then the formula will be:

Substitute(Replace(varSupplementalNumber.Title, 15, 2, varUserInitials), "IH", "SP")

If you want to perform Substitute action first, then the formula will be:

Replace(Substitute(varSupplementalNumber.Title, "IH", "SP"), 15, 2, varUserInitials)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
slhangen 356 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much! I love this forum. Would have given up on Powerapps a long time ago without you guys.
slhangen 356 on at

Like
a
(0)

Report
Copy link

Link copied!

Wonderful explanation! Thanks so much. Still trying to wrap my head around compound formulas.