Replace String to Number in Sharepoint list

(1) Share

Report

Posted on by SK-02100553-0

Hi All,

I want to replace this string to number, can you please help me

like where seldom with value as 1, usually with value 2, never with value 3, often with values 4

Categories:

AI Builder

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Looking at the above column values- this seems to be choice column type, for this before replacing values - could you let me know whether, the value 1, 2,3 has been added as choice values in these columns ? so that flow can replace it with correct number ?

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

HI,

Since its does appear to be a choice, you have a couple of options. I wanted to follow up and ask, do you mean you want the Screen to show the value 1 or 2 or 3 instead of the words?

Or do you mean you want to store the values 1,2 or 3 in your backend versus the value of the Choice above?

What you can do, if its a choice, is to simply go to your Choice and update the words to be 1 2 or 3. Then have a clear guide on the screen that says what 1 2 or 3 means.

Or if this is a choice, and you want the numbers for some reason you have other options but it depends on when the use of the # is.

Because you could have another column that has a Number type. Then when you go to Patch the back end you can validate if the selected option is seldom often or never and then in THAT spot, but the number instead.

Was this reply helpful? Yes No