web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Using data in datatabl...
Power Automate
Unanswered

Using data in datatable to be set as variables

(0) ShareShare
ReportReport
Posted on by 22

Hi all,

 

I'm new to Power Automate Desktop and would greatly appreciate your expertise and assistance.

 

I have stored my Excel data in a 'datatable,' and I'm looking for guidance on how to set up the extracted data into a variable. My ultimate objective is to compare the extracted data using the 'if greater than' condition against another set of data. Any guidance you can provide would be highly valuable. Thank you!

 

Extracted Data:

Xaviier_0-1694398540801.png

 

Best regards,

Xavier

 

 

 

I have the same question (0)
  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    Can you please provide some more context as to what exactly you are trying to accomplish?

     

    The data you retrieved from Excel is stored in a variable of type data table. You can access a value in a data table by providing indexes like this: %ExcelData1[rowIndex][columnIndex]% where rowIndex and columnIndex are variables storing numeric values. You can also pass the indexes literally - %ExcelData1[0][0]% will return the value at row 1 and column 1 (because indexes are 0-based).

     

    So, if you know which specific cell you want to compare with some other value, you can simply use hard coded indexes, or you can build a loop and loop to generate indexes for you and iterate through the entire table.

     

    For more reference, I would suggest watching this tutorial: https://www.youtube.com/watch?v=urFyD7QOkac&ab_channel=AndersJensen 

    -------------------------------------------------------------------------
    If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

    I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

  • Xaviier Profile Picture
    22 on at

    Hi @Agnius ,

     

    From 2 columns, I have a 'Start date' & 'End date'. If End date is earlier than Start date, it will for example, highlight the specific cell. 

     

    Xaviier_0-1694412239704.png

     

  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    Well, I have already described how to get those values. Try reading my reply again and also watching the tutorial video.

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

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 463

#1
Valantis Profile Picture

Valantis 463

#3
11manish Profile Picture

11manish 264

Last 30 days Overall leaderboard