How to get number of item from list (xls match function)

(0) Share

Report

Posted on by Michs

Hi,

i`d like to get position of item from list in PA. I`ve list:

1. A

2. B

3. C

i`d like to get position of "C" element. How i can get it? In excel there is the formula "=MATCH", which returns position of item in the list. There is possible in PA?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

MichaelAnnis 5,727 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Unfortunately no, at least not one I have found yet. You could open a blank Excel, paste the list to Column A, write the Match formula to B1 and then read from B1.

Or, you can loop though the list saying, if %List.LoopIndex% = ‘thematchtextIneed’ then set variable %matchIndex% to %LoopIndex%

if you use the excel method be sure to -1 cuz PAD index starts at 0, not 1.

Was this reply helpful? Yes No
Benny_1857 124 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi，
1.If you just want to get the position of the item. I complicated the problem. I want to get every postion contains 'C'
You could change 'if... then' equal the text you input or contain the text you input.

2 if you just want to get number from the list
Outcome will be a little strange which I get 2 columns.

Was this reply helpful? Yes No
Michs 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

thank you @MichaelAnnis and @Benny_1857 for your solutions.
I wish, I can use xls formulas to PA, but I solved problem the same way as Michael, copy data to excel and using =match.

Regards,
Michal

Was this reply helpful? Yes No