web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Split the strings on t...

Power Automate

Unanswered

Split the strings on the same cell to different colums

(0) Share

Report

Report

Posted on by lkylerl0228

Is there any way to split this strings into the create file? I wanted the SampleId to H only (e.g. "1036H") and others in different columns.

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@lkylerl0228 within apply to each action, you can add Compose action with below expression to split
split(items('Apply_to_each'),' ')
This will give you array of words that are split by space, then you can use indexer as follows to get the value of first word, second word and so on
outputs('Compose')[0] outputs('Compose')[1] outputs('Compose')[2]

Was this reply helpful? Yes No

Join the conversation