Power Platform Community Forum Thread Details

I built a flow that reads the entire PDF name and checks if it contains a 5-digit ID. Now, I need to expand this functionality to find multiple IDs within the same PDF name. For example, in a PDF file named "14325 12345 78956 important document 2024." I want the flow to extract all 3 IDs.

Once the IDs are extracted, I need to use them in subsequent steps to filter a list.

Categories:

Building flows

Hi,

Try this approach if you are trying to use cloud flow

1. Assume the file name of pdf is stored in compose action for further processing (in real sceanrio, you can store the dynamic content which represent the file name- currently for demo purpose- i have hardcoded it in compose action as shown below)

2. Use filter array which helps to capture 5 digit IDs from file name present in compose action as shown below

Expression -

split(first(split(outputs('Compose'),'.')),decodeUriComponent('%20'))

Condition used

Expression used- and(isInt(trim(item())),equals(length(trim(item())),5))

Now see the output which would be in array format as shown below

Hope this helps - This array of values you can use in next action(s)

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!