Create record on sharepoint list, from Excel file seems that works but no line is added to the sharepoint list

[TheGallons]

Hi all,

I've an Excel file needs to be uploaded into a sharepoint list.

In that Excel file I have two rows:

In my flow, I check ID_PERFORMANCE column, if exists into sharepoint list I update the record, if does not exixst I create a new record.

When I run the flow, the existing line while successfully updated! The new line is not created and I don't have any errors!

The strange thing is that in Flow log, in create record session, I see the green flag but I can not see the creation log because is not expandible, see image below:

Please, any suggestion will be most appreciated!!

Thanks

Davide

[HenriDesmet59]

Hello @TheGallons , 

you put the "create item" action inside a "Apply to each" Action. On which element are you looping in this "Apply to each" action ?

[TheGallons]

Hi Henri,

thanks for the answer. 

This is the schema I have in my Flow. 

Update session works properly, Add session not work. 

[HenriDesmet59]

Thanks, 

I think for the "No" parts of the condition, you need to pull out the "Create item" action of the "Apply to each" Action.

In the "Yes" part, the "Apply to each" action is used because the output of your "get items" is a collection (even if there is only 1 element returned)

[TheGallons]

Henri,

The flow is already how you mean: 

I try to create another flow without existint test and only the Create part and it works properly.

The strange thing is that in the log of flow, no error occurred but the "Create" part is not available, like my first post. 

[HenriDesmet59 · Accepted solution]

You first flow is correct. 

In the "No" part, you have to delete the "Apply to each" action.

And then you can add your "Create element" action 🙂 

[TheGallons]

Many many thanks Henri, seems that's work!! 

Best regards

Davide

[HenriDesmet59]

Nice ! Tell me If you got another problem Davide ! 

Best regards