I follow your tutorial but when I run it again to update new row from excel to list, the old data duplicate into the List. How can I prevent this and only allow new row created in excel to be import to List?
This was very good. However, I have a slightly different use case: I have thousands of files in a Shared network drive. People track attributes of the file in an Excel spreadsheet (Department, Category, Last Review Date, Next Review Date, etc.), so I'd like to be able to upload all the files, then import the spreadsheet data to the columns in the document library. Can you help?
Hi, thanks for the easy video! How can I set up a flow that does this same process every time a new file is added to a particular folder? I may have a file every few weeks that I may have to do this for... would this require creating a new flow every time?
Hi, I have the problem with the string/date with sharepoint. After list a row tables , DateTime Format is ISO 8601 and create item field "convertTimeZone(formatDateTime(items('Apply_to_each_2')?['Ngày hợp đồng'],'yyyy-MM-dd'),'UTC','SE Asia Standard Time','yyyy-MM-dd')" but it failed "Unable to process template language expressions in action 'Create_item' inputs at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string '' was not valid. The datetime string must match ISO 8601 format.'." How I can fix this problem because I want to format is dd-mm-yyyy
@@Maxfeng-o6r yes, i used this "if(equals(items('Apply_to_each_2')?['Your name field],''),null, formatDateTime(items('Apply_to_each_2')?['your field name'], 'yyyy-MM-dd'))"
Is there a way to update existing an existing row in my Sharepoint list based on what is contained in the Excel file? Or can you only create a new item?
Hey Nate, thanks a lot for the useful video. QUESTION: would it be possible to select the file path to be transfer to the SP List during the flow execution ? The goal being to avoid editing the flow in power app for every single xls file we want to import. Selecting several files to be transferred would be also be great.
Formatting numbers? You can use the same approach as my currency example if you're not seeing the field pop up as dynamic content. Float() works for any decimal number, currency or not.
This was the first non-intimidating tutorial I have seen for this import process. Well done!
I'm glad it was helpful! Thank you.
Muchas gracias me fue muy util para el trabajo :)
Is it possible to update rows that already exist, without duplicating items on the list?
I would also love to know how to do this
I think we need to use if clause ; loop function
If you find something helpful for this please let me know
I follow your tutorial but when I run it again to update new row from excel to list, the old data duplicate into the List. How can I prevent this and only allow new row created in excel to be import to List?
This was very good. However, I have a slightly different use case: I have thousands of files in a Shared network drive. People track attributes of the file in an Excel spreadsheet (Department, Category, Last Review Date, Next Review Date, etc.), so I'd like to be able to upload all the files, then import the spreadsheet data to the columns in the document library. Can you help?
Hi, thanks for the easy video! How can I set up a flow that does this same process every time a new file is added to a particular folder? I may have a file every few weeks that I may have to do this for... would this require creating a new flow every time?
Is it possible to make the step with creating a table from range in Power Automate?
Thanks!
Hi, I have the problem with the string/date with sharepoint. After list a row tables , DateTime Format is ISO 8601 and create item field "convertTimeZone(formatDateTime(items('Apply_to_each_2')?['Ngày hợp đồng'],'yyyy-MM-dd'),'UTC','SE Asia Standard Time','yyyy-MM-dd')" but it failed "Unable to process template language expressions in action 'Create_item' inputs at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string '' was not valid. The datetime string must match ISO 8601 format.'." How I can fix this problem because I want to format is dd-mm-yyyy
I have the exact same issues; did you get it figured out?
@@Maxfeng-o6r yes, i used this "if(equals(items('Apply_to_each_2')?['Your name field],''),null, formatDateTime(items('Apply_to_each_2')?['your field name'], 'yyyy-MM-dd'))"
@@meyo10240 tengo una BD de 16 columnas con 2000 filas de registro, pero solo me agregar 256 filas, como hagao para enviar todo, podrias ayduarme?
Is there a way to delete rows this way?
This is good for uploading net new rows. I also am trying to automate removing rows that no longer are needed.
Hi Nate great video.
is it possible to import merged rows & columns of excel into Lists? I am trying since long but unable to...
Is there a way to update existing an existing row in my Sharepoint list based on what is contained in the Excel file? Or can you only create a new item?
Hey Nate, thanks a lot for the useful video. QUESTION: would it be possible to select the file path to be transfer to the SP List during the flow execution ? The goal being to avoid editing the flow in power app for every single xls file we want to import. Selecting several files to be transferred would be also be great.
what about numbers
thank you for tutorial
Formatting numbers? You can use the same approach as my currency example if you're not seeing the field pop up as dynamic content. Float() works for any decimal number, currency or not.
Is it possible to also do this process but with a column for attachments?