Variable in Power Automate Desktop

(0) Share

Report

Posted on by claudia

208

Hello everyone,

I have a folder with 3 files. The files have the same naming convention: nnnnnn-E1_Product name_LBL

I need to extract from the file name the Product name

I have split a text as below:

If I want to set a variable, I receive an error " Index '1' is out of range

Does anybody knows what is wrong?

Thank you for your kind support.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (10)

Answers (2)

Sort by

MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

No...mine is working just fine.

Are you splitting text with the underscore?

Was this reply helpful? Yes No
claudia 208 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

yes I am splitting with underscore

Was this reply helpful? Yes No
Verified answer

MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

It's so weird. Mine is working just fine with [1]. This is weird, but have you tried deleting the command and redoing it. Also, show me your total flow screen. I want to make sure it's reading it correctly.
I'm heading into a meeting, so you won't hear from me for about an hour. Good luck!

Was this reply helpful? Yes No
JamesP_MSFT Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@claudia from what you are showing, the index number you are using is within limits.
Could you paste a screenshot of your flow?

Was this reply helpful? Yes No
Verified answer

Waylold 106 on at

Like
a
(1)

Report
Copy link

Link copied!
@claudia

Have you tried simply extracting with RegEx? It would save time with steps.

Copy and paste the below into the flow builder window and replace the text to parse with the file name variable.

Text.RegexParseForFirstOccurrence Text: Filename TextToFind: $'''(?<=_)(.*?(?=_))''' StartingPosition: 0 IgnoreCase: True Match=> varProductName

Was this reply helpful? Yes No
claudia 208 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Michael,

I have checked the flow one more time and I saw that, the order of the actions was wrong 😬. I have made the correction and now is working.

Thank you for taking time to answer.

Was this reply helpful? Yes No
claudia 208 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

RegEx is something very new and very interesting for me. I know it can be used, but it is not so easy for me to handle it. Please, beside the Microsoft documentation, do you know some sources from where a beginner like me could learn some things?

Please can you explain this expression:
(.*?(?=_))

Thank you
Claudia

Was this reply helpful? Yes No
Highboy 1,187 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

https://regexr.com/

Was this reply helpful? Yes No
Waylold 106 on at

Like
a
(1)

Report
Copy link

Link copied!

@claudia, It looks like @Highboy and I share the same site. Great site for building/testing on the fly with real world data.

Was this reply helpful? Yes No
Waylold 106 on at

Like
a
(0)

Report
Copy link

Link copied!
The totality of the expression is doing a few things:
(?<=_)(.*?(?=_))
We are looking for an occurrence of underscore, the using the positive lookbehind function both using it as the start point and leaving out of the result.
We then use a capture group to consolidate functions. We need to instruct the computer to continue looking until the next function. (.*) represents that.
?(?=_) We're looking for the next occurrence the underscore and finding everything in between to the last argument as a string.
Hope that helps.

Was this reply helpful? Yes No