Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Translation Quality Feedback / How to refer to a list...
Power Automate - Translation Quality Feedback
Answered

How to refer to a list item in Power Automate Destop Premium

(0) ShareShare
ReportReport
Posted on by JL-17121049-0 11
Related to Power Automate Desktop (version 2.51.344.24350): I wonder why %-mark or {-mark doesn't work any more when to refer variables. How to refer eg.  list item?
Categories:
General
  • Verified answer
    Expiscornovus Profile Picture
    Expiscornovus 31,967 Most Valuable Professional on at
    How to refer to a list item in Power Automate Destop Premium
     
    Great to hear the reference is working.
     
    Regarding the video you linked to, that one is from 1 year ago. Probably a lot of the videos aren't using the Power Fx functions yet, because Power Fx has been introduced in the December 2023 release:
  • Verified answer
    JL-17121049-0 Profile Picture
    JL-17121049-0 11 on at
    How to refer to a list item in Power Automate Destop Premium
    Thank you Expiscornovus !!!
     
    Power fx was enabled but I didn't realize that index fx-function is available (I am just beginner with Power Automate).
    Your link to examples helped me to solve my problem.
    Now I can refer to data table elements  ......  =Index(Index(DataTableVar, 1), 2)
     
    I am still little bit confused.
    You can find many Youtube videos, like https://www.youtube.com/watch?v=IurF01TE-0E 
    There Anders Jensen is using %-mark refering variables (eg. see 25:37).
    He is using %Emloyees[1][1]%. I wonder why this method doesn´t work for me. 
    I have tried to use also =%Emloyees[1][1]% but it gives me an error message "Parameter 'Value': Unexpected characters. Characters are used in the formula in an unexpected way."
    When I use just %Emloyees[1][1]% it behaves like a text.
     
    Br, Jukka
     
  • Expiscornovus Profile Picture
    Expiscornovus 31,967 Most Valuable Professional on at
    How to refer to a list item in Power Automate Destop Premium
     
    Did you enable Power Fx on your desktop flow, by any chance? If that is the case, you might want to use an index function to refer to an item in the list.
     
    A couple of changes in the language are shared in this section:
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans