Unanswered

Can't get a variable item from an array - Power automate Desktop

(0) Share

Report

Posted on by BrianSici

Good morning,

I'm pretty new to power automate, and I was trying some stuff, but for some reason i can't get a item from an array.

I'm trying to get a array created by a split text, and displays the array correctly, but the moment of getting a certain item from a array it says "Parameter 'Value': Unexpected characters. Characters are used in the formula in an unexpected way.", using =TextList[1] or =%TextList[1]%

For instance, I tried even to search on learn.microsoft wiki on understand Variable manipulation such as to set an variable as "%5 * 3%" but it dosen't do any calculation. And on the action list (the left menu)

Screenshot 2024-02-07 163332.png

I don't find any "list" to add to my flow.

Any help would be appreciated.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

eetuRobo 4,549 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You should create new flow without Power Fx enabled. Its in preview and doesn't support many features or even if it does its not very easy to figure out how do them.

In Power Fx you need to use equals sign to create variables:
=[1,2,3]

Was this reply helpful? Yes No
KakaFernandez 2 on at

Like (0)

Report
Copy link

Link copied!

Hey there,

I have Power Fx enabled and this should solve your issue: '=Index(TextList, 1)'

As for my case:

If you have Power Fx enabled, some formulas you have to think of them as if you were using Excel. To retrieve an item from a list, in Excel you would use INDEX formula.

Hope it helps 🙂

Was this reply helpful? Yes No