You’re offline. This is a read only version of the page.
Announcements
19
Hello,
I am new to PowerAutomate.
I was able to get my data as CSV. However I cannot find a way to properly convert this CSV to an XLSX excel sheet and put all the data in a formated table.
Here is how the CSV data looks like
I want to convert this file and to xlsx as formatted table shown below and save it as xlsx file in sharepoint. Everthing should be done via PowerAutomate Flow. The flow should go and read the CSV file then parse the data and add create table and add the rows and finally save the file as XLSX in the sharepoint.
Bonus : If I could get only the lastSignInDateTime in SignIn Activity column that would be much much appreciated :).
Looking forward to any help. I have been working on it for 2 days but nothing worked as I expected. Thats why I refered here to seek help.
Regards
Hey @lG_2022
Check out this video:
https://www.youtube.com/watch?v=9J6ThPWGaG0
My Method: [Not sure will work well]
For my case I used split function, and then saved it in another excel.
But before I had converted the excel into a table.
Here is how the data looked like:
and how it got added:
First I used list rows in a table action.
After that:
I used a compose to store the column 1 in it. Then used split function to split it where ever it finds a comma.
Then I stored it in another excel's table:
used output's index value to store.
Share
Report
All responses (
Answers (
