cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TheGallons
Helper II
Helper II

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

Hi all,

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

In that Excel file I have two rows:

TheGallons_1-1646739743318.png

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:

TheGallons_2-1646739984147.png

 

Please, any suggestion will be most appreciated!!

Thanks

Davide

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
HenriDesmet59
Super User
Super User

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 🙂 

HenriDesmet59_0-1646756215469.png

 

 

View solution in original post

7 REPLIES 7
HenriDesmet59
Super User
Super User

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 ?

Hi Henri,

thanks for the answer. 

This is the schema I have in my Flow. 

TheGallons_0-1646754278254.png

Update session works properly, Add session not work. 

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)

Henri,

The flow is already how you mean: 

TheGallons_0-1646755731330.png

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
Super User
Super User

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 🙂 

HenriDesmet59_0-1646756215469.png

 

 

TheGallons
Helper II
Helper II

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

Best regards

Davide

HenriDesmet59
Super User
Super User

Nice ! Tell me If you got another problem Davide ! 

Best regards

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,133)