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 (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 (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 (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