Unanswered

Find text and get value after that text - Only works for the first value

(0) Share

Report

Posted on by Celia

Hi all,

I have a PDF document with several rows that gives a projectnumber. So I parse that text: Find project number and get subtext of 8 characters.

This works fine, but just for the first found projectnumber.

So, I thought I just switch off the 'Only first one' and then it would loop untill it has all projectnumbers. But when I switch it off I still get just one value, but that value doesn't make any sense.

That's when I noticed the variable changes from Position to Positions when I disable Only first one. So, I changed the other actions from %Position% to %Positions% but still no success.

Can anyone help me how to get all the values?

Categories:

Power Automate Desktop

All responses (3)

Answers (0)

Sort by

momlo 1,527 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Celia
Can you give me example of text? I have a feeling we can get what you need with positive/geatvie lookaheads in regex.
MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

When you turn off “first one only” you then get %Positions% instead of %Position%. %Positions% is a list, so you would have to do another for each on %Positions% and run your subtext logic through the for each loop so that it does it for each value in %Positions%.

good luck.
Pavel_NaNoi 1,074 on at

Like
a
(0)

Report
Copy link

Link copied!

With your method you'll need another "For each" loop that goes through each position and stores the found subtext into a list. A better method would probably to switch to regular expressions in Parse Text, in which the text you'll be looking for would be something like "Work Order :.+($|\n)" as this produces a "Matches" list that contains all the found text straight away without you having to obtain subtext in the first place.