Answered

Extract Number From Text Field

(0) Share

Report

Posted on by ausdenwolken6

Hello,

I need to build a power automate that takes pre existing data and adds a column as well as automatically adding this information to new submissions.... here is the backstory.

I have a Sharepoint list with a field that has multiple lines of text separated by Char(10).. basically people are allowed to pick certain bullets that pertain to the submission. For example the multi line of text in Sharepoint may look like this...

1.1 tex text text text
1.2 text text text text

2.1 text text text text

4.2 text text text text

4.4 text text text text.

I need to use power automate or Sharepoint or power apps to extract the numbers from the text field and concat them... essentially I need the outcome to be this

1,2,4

I have tried a lot of things but can't seem to get it to work. Any ideas?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-hanytian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ausdenwolken6 ,
We made a sample for you.
SharePoint List.

Flow:
split(outputs('Compose'),outputs('Compose_2'))
slice(item(),0,1)
contains(variables('Result'),outputs('Compose_4'))
join(variables('Result'),',')
Result:

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
ausdenwolken6 2 on at

Like (0)

Report
Copy link

Link copied!

Wow this is great! I am running into an error at compose 3. It says it 'Split' expects its first parameter to be a type of string. The provided value is of type 'Null'.

Could this be because some people put nothing in the boxes and therefore the value for some of the rows would be null and others contain multiple or one? For instance rows may also look like these

2.3 text text text (one value)

or

(blank)

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

Like (0)

Report
Copy link

Link copied!

Hi @ausdenwolken6 ,

Please try this in the Apply to Each:
Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No