Forum Discussion
Unexpected error. Unable to fetch
I will try to answer to the best of my ability, as I am new at this and followed a video.
The trigger is Manual Run or Test flow
The data is in Excel sheet all columns are single lines of text except the date column. And I used ISO 8601 for date format. It uses Intersection Var Array to see if Item is there and writes it to list. I will watch the video again on the explanation and hope to come up with a better answer to your questions. btw the video is on youtube if interested https://www.youtube.com/watch?v=aNoPNcXIg08&t=10s Date format is the only thing I did not incorporate in my flow as it worked by changing it to ISO 8606 in list rows present in table.
I just dont understand why everything works as intended if under 50 items. And it still writes 95% if over 50.
Thank you for the detailed description. This video seems to be a part 2 out of 3. Are all three videos released? have you followed them as shown in the video, or have you made any customizations?
Is there a reason you would like to work in Excell first and then have a script to update it in SharePoint Online? Because, if you could consider working from SharePoint first, there is a standard function to export to Excell.
ArefHalmstrand Hi thank you for getting back. Yes, it is a 3 part. 1 st shows what it does, 2nd describes the flow, and 3rd step by step follow. And I did not modify it except for Date formula.
I work with Excel because I extract info from multiple excel files I receive and do a series of merges and formulas with other files to come up with a single excel file as a db.
I've discovered an interesting situation with my flow. I noticed that it randomly fails random items to create. Each run/test fails different items and different number of them. In 3 last tests I had 1st produced 3 failed items, 2nd test 9, and 3rd 5. Failed items were never same items from previous fails. It feels like like SP make a connection to that excel file (SP documents or OneDrive) and randomly fails to connect to it. Attaching screenshots.
- bump