Unanswered

Pass variables from excel as input to a CLI based application

(0) Share

Report

Posted on by Community Power Pla...

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.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

NikosMoutzou Microsoft Employee on at

Like (1)

Report
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

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:
https://docs.microsoft.com/en-us/power-automate/desktop-flows/manage-variables
https://docs.microsoft.com/en-us/power-automate/desktop-flows/variable-data-types
https://docs.microsoft.com/en-us/power-automate/desktop-flows/variable-manipulation
https://docs.microsoft.com/en-us/power-automate/desktop-flows/ui-elements

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No