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!
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
14 | |
11 | |
8 | |
6 | |
6 |