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
Resolver IV
Resolver IV

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
Resolver IV
Resolver IV

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
Resolver IV
Resolver IV

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
Resolver IV
Resolver IV

Nice ! Tell me If you got another problem Davide ! 

Best regards

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (1,769)