Announcements
Guys,
I would like to ask you if it is possible to download the value of column A from Excel, which is in the Library in SharePoint. and pasting them into the SP list where I have the Code column
To the best of my knowledge, you can only retrieve data from Excel tables. If you prefer not to use tables in your document, you can write a script in the file, and return the data you need as an array. Then call that script from PA to import the values into your sharepoint list.
Can I open Worksheet using Power Automate and use rows to get all the items from column A only and paste them as an update item of the SharePoint action?
As mentioned, this will only work on defined tables within your excel sheet. You will need to turn your excel data into a table, give it a name. Then use the "List rows present in a table" action.
Do you have a simple script on how to do this?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 259 Super User 2026 Season 2
11manish 227 Super User 2026 Season 2
Valantis 134 Super User 2026 Season 2
