web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Create record on share...
Power Automate
Answered

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

(0) ShareShare
ReportReport
Posted on by 89

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

 

 

Categories:
  • HenriDesmet59 Profile Picture
    295 on at

    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 Profile Picture
    89 on at

    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. 

  • HenriDesmet59 Profile Picture
    295 on at

    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 Profile Picture
    89 on at

    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. 

     

  • Verified answer
    HenriDesmet59 Profile Picture
    295 on at

    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 Profile Picture
    89 on at

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

    Best regards

    Davide

  • HenriDesmet59 Profile Picture
    295 on at

    Nice ! Tell me If you got another problem Davide ! 

    Best regards

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 377

#2
11manish Profile Picture

11manish 302 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 130

Last 30 days Overall leaderboard