cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
TomLu1231
Level: Powered On

How to form the data to a table in Excel via Flow?

Dear experts, 

 

I have an excel file which contains the data generated from system. This row data is an excel file that has column header and one record per row. The row data is not in Table format. Is there any way that we can form the excel's data to a table automatically via Flow?

 

Many thanks!


Best regards,

Tom

2 REPLIES 2
Dual Super User
Dual Super User

Re: How to form the data to a table in Excel via Flow?

Hey @TomLu1231 

 

To use the excel online connector to get individual row items, the data needs to be formatted as a table only. Can you share more details on the data schema you currently have? Maybe you can manually format the data to a table by selecting the entire data set in excel and formatting it as a table. And then you can get it in flow row wise and perform any further operations as intended. 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

TomLu1231
Level: Powered On

Re: How to form the data to a table in Excel via Flow?

Hi @yashag2255  thanks for your answer! The data I got is just an Rxcel file like below. It has the column headers and one record per row. But it is not a table format.  

Employee IDHire DateGenderDepartmentLocation
1231231242019-09-01MaleFinanceSingapore
1231232132019-10-22MaleHRChina

 

Currently, I am doing exactly you what you mentioned which is to manually format the data to a table by selecting the entire data set in that Excel and formatting it as a table. Then upload to a shared folder to trigger the flow to list down all the records in that Table. 

 

I am wondering whether it is possible that we can use Flow to automate the formatting table part. So that I can just upload the Excel file without any manual actions. Is it possible to achieve that?

 

Many thanks!

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,540)