Today I tried to use the replace function. I had 3 variables and I tried to replace one text with another.
first I had a variable longstory ( with a value long story)
then I had a variable long and a variable short.
And now to make a long story short all I had to do is use the following expression:
replace(variables(‘longstory’),variables(‘Long’),variables(‘Short’))
Discover more from SharePains
Subscribe to get the latest posts sent to your email.
Pieter Veenstra
Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There's a better way — and I can show you exactly what it looks like. I'm the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide. For over 30 years I've been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions. You can contact me using contact@sharepains.com