Unanswered

Creating Item in SharePoint List from Excel

(0) Share

Report

Posted on by Gazsim

Hi All,

I would like to build a flow that will allow users to create an item in a specified sharepoint list from selected data on a per row / item basis in Excel and auto populating some of the fields in the list. I've created a custom list in Power Apps which works fine and have at this moment added a hyperlink to the list for users to be able to add or view an existing item but thats where my knowledge ends. I have a colleague who could do this in the SharePoint 2010 but not in 365 that we now operate from so is a flow the right solution to this? I'm not able to add any screen shots / attachments for some reason so if you need any further information please let me know,

Many thanks,

Gary

All responses (6)

Answers (0)

v-yamao-msft on at

Like (0)

Report

Re: Creating Item in SharePoint List from Excel

Hi @Gazsim ,

I am afraid that it would be not possible to use the trigger For a selected row without Excel Add-ins.

Best regards,

Mabel
Gazsim 57 on at

Like (0)

Report

Re: Creating Item in SharePoint List from Excel

Hi Mabel,

Apparently our company settings do not permit us downloading from the Store and so I am unable to install the add-in! I guess its back to the drawing board for me!?

Thanks,
Gaz
v-yamao-msft on at

Like (0)

Report

Re: Creating Item in SharePoint List from Excel

Hi @Gazsim ,

Thanks for updating.

Are you trying to create item in SharePoint list from Excel using Microsoft Flow?

Have you created a flow? If yes, could you share a screenshot of it?

By the way, if you want to work with Excel, I am afraid that Pivot table is currently not supported. The workable Excel table under Excel connector is Data table likes below:

https://support.office.com/en-us/article/Overview-of-Excel-tables-7AB0BB7D-3A9E-4B56-A3C9-6C94334E492C?ui=en-US&rs=en-US&ad=US

Best regards,

Mabel
Gazsim 57 on at

Like (0)

Report

Re: Creating Item in SharePoint List from Excel

Hi Mabel,

Just also wanted to add that I am trying to install the add in but are continually receiving the error loading add-ins message?

Thanks
Gazsim 57 on at

Like (0)

Report

Re: Creating Item in SharePoint List from Excel

Hi Mabel, my current setup is basically working from a pivot table from which I update the data each month. By means of the URL (copy hopefully attached) the user is given the option to add a new comment which opens the sharepoint list add item - however where as before we used this to auto populate some of the data on the concerned row this doesnt seem possible any longer with 365. Ultimately the list is also connected to the excel document so the comments from the list are always current and viewable once complete on the pivot table. This then gives the user the option to open the item in the sharepoint list to view / amend etc.

Hope this makes sense?
Thanks,
Gaz
v-yamao-msft on at

Like (0)

Report

Re: Creating Item in SharePoint List from Excel

Hi @Gazsim ,

Do you want to trigger the flow by selecting a row in the Excel table then add the selected item into a SharePoint list?

If possible, please share some screenshot for better understanding. Please click the Camera icon in Reply mode, then select the images from local.

By the way, I have made the following flow for your reference.

The following blog on introducing Microsoft Flow integration in Excel would be helpful:

https://flow.microsoft.com/en-us/blog/introducing-microsoft-flow-integration-in-excel/

Best regards,

Mabel