Answered

Inserting new column from Excel spreadsheet to SharePoint list

(0) Share

Report

Posted on by noneother

I have an Excel spreadsheet that is identical in content and columns to that of a SharePoint list.

The Excel spreadsheet has been updated with an addition +1 column for region. How can I use flow to insert this new column to the SharePoint list from Excel so that they now both match?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

hi @noneother what you need to do is schedule a run. See unfortunally there are no trigger like when a new row is added in excel to execute a flow, so thats the reason you need to schedule you can run your flow once a day or when ever you need.

Was this reply helpful? Yes No
noneother 53 on at

Like (0)

Report
Copy link

Link copied!

I'm not referring to +1 new records. I'm talking about +1 new column. My question is not about scheduling.

I want a manual trigger.

Was this reply helpful? Yes No
ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

oh @noneother sorry but the answer is the same, you can not add columns to sharepoint dynamically you need to created manually to have the same columns in both places excel, and sharepoint

Was this reply helpful? Yes No
Verified answer

noneother 53 on at

Like (0)

Report
Copy link

Link copied!

I got the answer.

Trick is to have a condition in filter query

Was this reply helpful? Yes No
Mohammed24 8 on at

Like (0)

Report
Copy link

Link copied!

ignore-

Was this reply helpful? Yes No
Mohammed24 8 on at

Like (0)

Report
Copy link

Link copied!

Hi,

How are you adding a column/field on SharePoint here ?
You had a new column Region added in excel right?
why are you filtering the Title with the value from excel?
I believe we need to use send an http request to SharePoint list to create a new column ....
Could you please give a quick explanation of the flow?

Was this reply helpful? Yes No