Hi everyone, I use a flow to append an excel file to a Sharepoint list, and it has always worked.
Today I try to append some data using the same Flow, which has not been modified, but does not queue anything. No errors are reported and the flow completes successfully.
In the flow I make a comparison on an "ID" field present in the excel file and in the Sharepoint list.
If the IDs are the same, I update the record otherwise I append it.
Based on your experience, what check can I do to understand why no records are queued?
Thanks
Hi @TheGallons
Check the run history of flow. Then expand every single step and look into it.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogThanks Abm. I've another question. I recreated the flow as new.
On excel file there are 1600 records. After 25 minutes, the flow has added around 1300 records and then, an error is occurred. My question is, can be that the flow does not able to update sharepoint list because the list is opened from application????
Hi @TheGallons
What's the error you getting? Also what you meant by list is opened from application?
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi Abm,
thanks for the answer.
The error il this:
Seems that the error is on "Condition" section but I don't found the reason of the error.
Is there a way to find it?
Hi @TheGallons
Thanks for posting the screenshot. Could you please post that error message in English?
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi,
the error on the right page is:
The 'Condition' action failed
and the description is:
An action failed. None of the dependent actions have been completed.
Thanks Abm
Hi Abm,
below the complete tranlsation of the error:
Invalid model. Model language expressions cannot be processed in the 'Create_element' action inputs at row '0' and column '0': 'Model language' int 'function was invoked with an invalid parameter. The value cannot be assumed in the target type. '.
Now the excel file I am trying to upload to the sharepoint list has only 2 lines beyond the header.
I don't understand what can be the problem.
Thanks
Davide
Hi @TheGallons
Thanks for your reply.
From your flow run history click the the above link which I highlighted in red above. That will give you which step is failing. Looks like there is an issue with the mapping with some int values?
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blog