web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Get Multiple ID from a...

Power Automate

Unanswered

Get Multiple ID from a string and append to array

(0) Share

Report

Report

Posted on by YamiteKudasai

195

Hello Everyone,

Good day!

I would like to ask if there's any way to get id's on a string and make it an array.

Example string:

#1234 loreim xd test #1422

I have manage to get id using expression split(split(trim(items('apply_to_each_here')['Short Description']),' ')[0],'#')[1]. This will get #1234.

But what I need is to get all ids staring with '#' and make it in array. How to make these possible?

Thanks in advance for your help guys!

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!
@YamiteKudasai

One option is to use a Select action and some split expressions.
So in the From field of the Select action, use

Split(Insert String Here, '#')

So that will split the string so each array line starts with an Id.
From there, select the alternate view in the top/mid right of the action so the main input section goes from a 2 column table to a blank box.
In the box use the expression

First(split(item(), ' '))

That should split on spaces & grab the 1st item before the 1st space, in this case the Id.

Then the output of that Select action should be just an array of the Ids that had a # before them.

Was this reply helpful? Yes No

Join the conversation