Hi @tinkerbellpixie
You can do.
1. You need to read the headers from Excel first, you get them like this.
Add a Select action
a) From Field
split(string(first(outputs('List_rows_present_in_a_table')?['body/value'])),'",')
b) Map Field
split(replace(replace(replace(item(), '"', ''), '}', ''), '{', ''), ':')[0]
Originally Here:Solved: Re: Is there any way to get the column headers fro... - Power Platform Community (microsoft.com)
This will give you an Array of headers, BUT it will have 2 additional things which you dont want
[
"@odata.etag",
"ItemInternalId",
"Heading 1 ",
"Heading 2",
"Heading 3"
]
c) add a compose
-
skip(OutputArrayFromSelect, 2)
This will create an array output, that has SKIPPED the first 2 items in your header list, so that they wont be used to create the SharePoint lists.
2. You need to use the Send an HTTP request to SharePoint to create the list as there are no actions to do it directly.
The only issue I am not sure how you plan to know the Column Types. This code gives you the headers, but not the Types etc.
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
