Split Function

(0) Share

Report

Posted on by d31

Bot will update Department ID using Level 8-Name column, capture last 6 digits

If no value for Level 8, use Organization Level 7
If no value for Organization Level 7, use Organization Level 6

Bot should use split if value 5 i snull then pick 6 of not pick 7 how to do that?

I am comparing Excel and sharepoint and getting output and inserting excel into sharepoint

Nursing G16 502400(Value for Level6)

I have to split above value numeric and text seperately plus if one is null should go to next

split(split(string(body('SelectExcelItem')),',')[8],':')[1]

Categories:

AI Builder

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

CU23070558-1 2 on at

Like (0)

Report
Copy link

Link copied!

The best way of doing like, if something is not null use that value otherwise use some other value is coalesce().

Compose 1 null
Compose 2 "something"

Compose 3 null

Compose 4 null

Compose 5 "something else"

coalesce(outputs('Compose_1'), outputs('Compose_2'), outputs('Compose_3')) = "something"

coalesce(outputs('Compose_1'), outputs('Compose_3'), outputs('Compose_4'),outputs('Compose_5')) ="something else"

So, you can do all your string manipulation in Compose actions to keep it simple and easy to support later, then use coalesce() to decide the final output.

Was this reply helpful? Yes No
Verified answer

WillPage 2,323 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

The best way of doing like, if something is not null use that value otherwise use some other value is coalesce().

Compose 1 null
Compose 2 "something"

Compose 3 null

Compose 4 null

Compose 5 "something else"

coalesce(outputs('Compose_1'), outputs('Compose_2'), outputs('Compose_3')) = "something"

coalesce(outputs('Compose_1'), outputs('Compose_3'), outputs('Compose_4'),outputs('Compose_5')) ="something else"

So, you can do all your string manipulation in Compose actions to keep it simple and easy to support later, then use coalesce() to decide the final output.

Was this reply helpful? Yes No
d31 8 on at

Like (0)

Report
Copy link

Link copied!

Thank you Willpage and i reasearched coalesce and it worked

I have one more question How do i split Numeric and text for this value below

Nursing Resource Pool 600535

I have to split at Numeric value.

Was this reply helpful? Yes No