Unanswered

Using Excel data in PA

(0) Share

Report

Posted on by Johnnyoc

I'm reading about ways to expose all data in an excel file for use in power automate - however I'm struggling to find credible detail.

Is there a way to easily use excel data as an array/json or such to then filter and further use the data?

Categories:

Using connectors

All responses (5)

Answers (0)

Sort by

v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @Johnnyoc

According to your description, you want to get the table from your excel. If this , you can use the "List rows in a present table" action in Power Automate.

For more information, you can refer to :
Excel Online (Business) Actions: List Rows Present In A Table (youtube.com)

Best Regards,

Yueyun Zhang
Johnnyoc 41 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi sorry I neglected to mention there is no ta le in the data
v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi , @Johnnyoc

If your Excel file has no table , you need to use the office script to auto-create the table in your excel file due to the "list rows in a present table" action needs to create a table in the excel file!

function main(workbook: ExcelScript.Workbook) { let selectedSheet = workbook.getActiveWorksheet(); let newTable = workbook.addTable(selectedSheet.getUsedRange(), true); }

For more information, you can refer to :
How to Use Office Scripts with Power Automate - Xelplus - Leila Gharani

Best Regards,

Yueyun Zhang
Johnnyoc 41 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your help, however I seem unable to select the as yet uncreated table in the list rows present in table. I can't seem to add a dynamic output from add table or default it to Table1?
v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @Johnnyoc

Thanks for your quick response! First you can try to use the "Table1" as static table mane. Second , you can use the "Get tables" action after running the office script to get the table name.

And you can use this expression to extract the name of the table:

outputs('Get_tables')?['body/value']?[0]?['name']

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang