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 / Pass variables from ex...
Power Automate
Answered

Pass variables from excel as input to a CLI based application

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi Friends,

I am trying to automate an application where it should take inputs from an excel file and then paste it to the application. I am able to fetch the data from excel using "Read from excel worksheet" but after it reads i am not sure how to send this as a input to the application. Please can you let me know if its possible to do this in power automate or any other application similar to power automate which can accomplish this.

I have the same question (0)
  • Verified answer
    NikosMoutzou Profile Picture
    Microsoft Employee on at

    Hello @Anonymous !

     

    You should be able to view that action 'Read from excel worksheet' generates a variable as output. This variable can be used as input for a following action into the flow as the 'Populate text field in window'.

     

    Screenshot of example

    excel.PNG

     

     

     

     

     

    In this example, Power Automate Desktop reads from an excel all available cells, stores them in a variable, ExcelData, of Datatable type. This is used as input in the next action, for populating a text field in an app, where I have defined that I want to use the value of the first column and second row of the excel.

     

    Useful information:

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thanks Nikos i was able to apply the above solution to my flow. 😀

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard