You’re offline. This is a read only version of the page.
30
Hi Everyone,
I am trying to create a flow where I need to get data from excel uploaded in Library to SharePoint list, Although it's a very simple and I've watched many videos but I always got errors or the flow failed.. I will share latest flow I created and I need someone to tell me where the problem because when I test it ,it run successfully , but when I upload excel in library the flow doesn't run therefor I cant detect where the error. I need when user upload excel it reflects on SharePoint dynamically.
@FLMike Sorry I didn't share any errors as I mentioned the flow didn't run, So I couldn't figure out where the problem is .Now I fix the issue and it was because the upload files wasn't dynamic and fix it by adding file name with extension. But now I face another problem that the flow run successfully and data reflected in SharePoint correctly but the item duplicate ,e.x If I upload file with 12 raw , I found 80 rows created in SharePoint, it duplicates all items many time, Do you know why ? And if you need any further attachments plz let me know..
Thanks a lot for your support
Hi,
You say you are getting errors and failures, but you didn't share a single error or screen shot. This also doesn't appear to be the whole flow as I dont know how/why you have 2 Apply to each's
We cannot run or replicate your flow so you have to give us details, we can't just look at a partial flow and know whats wrong. Help us help you 🙂
[Responses to your previous post]
1. You have a Filter Condition Under ... then Settings and its causing the issue
No, since we are talking about the trigger. I am saying click ... then Settings to validate if you have any custom filters at the bottom that might be doing it.
For the other, you would need to change the trigger to be
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Thanks for replaying ,, I can' get point N 3 "3. You are overwriting a file that already exists and that would trigger an UPDATE not a create" I think it might be a problem too but I don't know how it fix it. Also what do you mean regarding N1 "1. You have a Filter Condition Under … then Settings and its causing the issue" You mean I need to remove filter query from Get data as when I do this the flow failed .
Hi,
It sounds like the trigger is not firing.
Here are reasons why it might now
1. You have a Filter Condition Under ... then Settings and its causing the issue
2. You are putting them in the wrong folder
3. You are overwriting a file that already exists and that would trigger an UPDATE not a create
4. They are in the wrong Site
5. The flow is off
If its truly not firing, there are only so many reasons it wont fire and it usually the ones I listed.
Please quadruple check. I have to check 12222 times myself and I still miss stuff 🙂
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
