Hello
I have a flow that compares an excel file with a sharepoint list and row by row determines if a new record should be created or an existing record be updated with new information.
I first ran into the issue of excel dates being an integer which i found could be solved with
Here is a screenshot of the final condition
Any ideas? as i mentioned earlier, if i remove the Incident Date expression from the update items, the flow runs fine. also if i remove all items from the sharepoint list (and each item needs to be created), the flow runs fine. There is something i am doing wrong with the date expression (which is identical to the 'create item' Incident date expression.
Solved! Go to Solution.
Hi @barryburke ,
When using Excel Online connector, the date value will be returned as String, which could not be saved to other date and time format columns.
Please take a try with the following workaround.
In the Excel table, please format the Date column as Text first, then input the date in each field.
Then start the flow with the similar configuration with what you’ve provided.
When there are no existing items, it will create new item in the list. When there are existing items, it will update the items with corresponding value.
Images for your reference.
By the way, when sharing images with us, please remove/hide your personal info including email addresses, organization names, user names, etc. for security purpose. Thanks for your understanding.
Best regards,
Mabel
Hi @barryburke ,
When using Excel Online connector, the date value will be returned as String, which could not be saved to other date and time format columns.
Please take a try with the following workaround.
In the Excel table, please format the Date column as Text first, then input the date in each field.
Then start the flow with the similar configuration with what you’ve provided.
When there are no existing items, it will create new item in the list. When there are existing items, it will update the items with corresponding value.
Images for your reference.
By the way, when sharing images with us, please remove/hide your personal info including email addresses, organization names, user names, etc. for security purpose. Thanks for your understanding.
Best regards,
Mabel
Hi Mabel
Thanks for the tip, i didnt see my web adress was still there, i know for future.
I tried your method and found the date did show up in the list. Thank you
Barry
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
40 | |
36 | |
35 | |
34 | |
27 |
User | Count |
---|---|
39 | |
38 | |
34 | |
31 | |
25 |