Answered

Extract data from predefined cells in excel and adding to sharepoint list

(0) Share

Report

Posted on by scodyWF

I have a excel sheet that is used as a form and results are filled in (the same certain fields everytime) and i want to be able to receive a copy of that file, extract the values from the predefined cells, and store the results in a single sharepoint list row, each cell will be mapped to a specific column. Next time a form/file is received, it extracts the predefined cell values and maps to the columns in a new sharepoint list row. is this possible? Does anyone have any advice please?

Thanks 🙂

Categories:

General topics

All responses (6)

Answers (1)

Sort by

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@scodyWF

Most what you want to do is pretty straight forward but in order to extract data from Excel, your data must be in an Excel table. Is the data already in a table in Excel?
scodyWF 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, the data can be in a table yes, for the point of solution, let's say yes. If they are in a table, how do you map the cell values to predefined sharepoint list columns? Thanks for the help so far 🙂
ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@scodyWF will provide an example ASAP. It's Thanksgiving so it might be a while 🙂
Verified answer

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@scodyWF

See my example below. Don't be confused by the compose action. You likely won't need it.

Let me know if you have any questions.
ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@scodyWF

See my example below. Don't be confused by the compose action. You likely won't need it.

Let me know if you have any questions.
scodyWF 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, the problem seems to be I want to automatically do this when a file is emailed in, the file isn't saved somewhere already so it can't connect to the file in the flow, I need to trigger the flow when an email is received, then save it to SharePoint I think to be able to list rows. Is this possible? Thanks for the help.