Add & Update Excel Data to SharePoint List with Date Field using Power Automate

Not working for me :(

Getting dupliacte rows when ran the flow

Great video! But, if a column blank, the flow doesn't create the record in SharePoint list? How to solve that? Thanks!

Thanks, that's so helpful!!
I have only one problem: the date field in Excel is not mandatory, and when it's empty, it causes an error. How to avoid this error?
I've tried to apply the condition, but not sure how and when I should write the condition.. could you help with this, please?

If one data is deleted in excel sheet, it is not deleted from List, is there any suggestion?

Is there a way to create a flow that would check if any document in a document library is modified, then add/update item to SharePoint list based on that?

I plan to have 14 similarly named documents (with different last name appended at end), and would like to update a SharePoint list any time one of those documents is modified.

Hi,
After about a week of trying to get this to work properly, I've finally managed to get it functioning, but only to a certain degree.
I am getting errors if one of the excel fields is blank, which then cancels the operation for that item.

Does anyone know how to overcome this?

In Get itesm filter query i am unable to adda any expression of dynamic value.When i click on pop up id just disappears.

This isn't working for me. I am using the excel sheet of a form in sharepoint (Forms for Excel) since it automatically captures the name. When the form is updated, it is captured immediately in the excel sheet. When this is done, I want that information to go to a list. I have followed this video and a previous one. I can't get it to work. Please help!

I have empty values in date field to overcome with this issue

genius, and in 16 mins, legend, very helpful!!

Great help, your videos are very useful. If u can also share tutorial as to how to send emailer to employees post new item is updated in this process and another email post 30 days from joining date, it ll be very helpful

Hi, is there a way to update/ add sharepoint list to excel online with automated query

InvalidTemplate. Unable to process template language expressions in action 'Update_item' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

This is really helpful, would you be able to show how to do something similar for a document library?

It won't work if the date column is empty. what is the solution

Thank you so much for this tutorial and the one about updating a sharepoint list using power automate so you don't have to copy cell by cell. Total lifesaver

Nice, any suggestions for blank date errors.

i am trying to do the same but the automate is able to check only for the first row in the excel file...i have 4 items in my excel and i see only first one being executed and the rest is not recognised and i have to do it via mannually.

Nice video, only issue I have is, some reason table name does not pop up, I have tried giving table name but still table name does not show, any idea? Thank you

Thanks... You helped me a lot!!! Regards from Brazil

spent hours and hours, watching over and over doing everything the same !!! JUST WILL NOT CREATE NEW ITEMS!!!

I have watched and tried your method, but when I run my flow it duplicates each row by the amount of records in the excel sheet.. only on create, not update file. How do I get around the Apply to Each on create item?

Thank you so much for explain it deeply I used to have an issue in my flow every time I make the same flow and it never worked until you showed the date function trick

Hey, thank you so much for posting this! Solved me a massive headache!! :D

Sorry if this has already been answered - If you delete a row in the table of the excel file, will this be removed in the SharePoint List?

Hi there, I really need to use this solution, but in my test in the Condition section > If Yes and If no > Apply to each. When using value from Get Items it doesn't load any data to my sheet, and if I use the value from List Rows Present in Table it prints duplicates. Any suggestions as to what I may be doing wrong? for the Get Items I am using the title column as my ID is this causing the issue?

Excellent!

Is there a way to do the same but using Smartsheet instead of excel file?

amazing

How to triggered this flow when a button is pressed in power apps canvas app. ??

Really amazing content and nicely explained, Will this flow work effectively for large number of records approx 8k?

In addition to adding and modifying excel data, there are instances where I have rows . Could you add a step to this video to show how to delete a sharepoint row that no longer exists in the excel file? Thanks in advance

Amazing, thank you for this great video....... 🤟

What do you have your columns set to within your sharepoint?

Hi. And thank you very much for this excellent video. I would like to ask you two things and I hope you can point me in the right direction: 1. My date column in excel is like this and that is why I think is not going for me "7/2/2015 9:59 AM" etc. If I remove the time then I get a day i advance or the day before. And 2: My data in excel is over 8K rows how can I pass this to go over 256 rows. Thanks in advance

will it work with multiple excel sheets located in the same folder? that has the same table structure?

Hello - I'm an avid subscriber of yours for a very fact that I continuously learning from your selfless act of sharing knowledge. This particular video helps me a lot.

I have one case requiring your kind suggestion/recommendation when it comes to updating or adding items from excel to SharePoint list:



📌1. I have used the excel repository of MS Forms to bring the responses to SharePoint list



📌2. I do this coz i have multiple 'upload files controls' which excel(tied up to forms) create a URL to each 'upload files controls'



📌3. when updating or creating new item to SharePoint, the flows skip those upload files that are empty, and i'm getting this error message:

❗OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/FileUpload002' is required to be of type 'String/uri'. The runtime value '""' to be converted doesn't have the expected format 'String/uri'.



❓ My question is, how to still update/create item to SharePoint even the value under each 'upload file controls' are 'empty'?

Hello sir thanks for video but i have issue about my flow and the issue is "Unable to process template language expressions in action 'Create_item' inputs at line '1' and column '29383': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'" can u help me abiut this ?

is there a way to convert excel file dropped a folder to a list ? For example , when I upload an excel file in to a folder , i want those fields in the excel file to populate in a sharepoint list . Is that possible? As always thank you for your great videos!!

thank you thank you thank yoU!!!

Hi, thanks for the video. I'm having a specific problem could you help me please? When running the flow in the conditional section of creating new items in shaire point a problem occurs. the flow says it completed successfully, however the data is not transferred to the shairepoint list. there are no error messages however, does not work to transfer new data to the list.

Hi Lernen Tech, how about delete from excel row and auto update into the list? Can you kindly advise. Thanks.

Hi Thank you this is exactly what I was trying to do.. But can you advise tell me how to include time? as I have a column Date - the field is display DateandTime. Thanks

Thanks for the video! If I delete a row from excel, is there a way to remove that data automatically from the list?

Can you share some efficient way to add bulk items (more than 5000). It takes more than 2 hours currently.

Thank you!

Thank you, This exactly what I was looking for.
However, whenever an excel data is updated and a flow is run, the outcome is a new record/ row (as seen in the video)
Can you please tell me, how to update on the existing row in SharePoint list.

Thanks for posting this. how would we deal with a table which has date and time? use float instead of int perhaps?