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 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????
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?
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.
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 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?
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.