Forum Discussion

rohitbajaj's avatar
rohitbajaj
Icon for Microsoft rankMicrosoft
Aug 27, 2024

Flow runs successfully but does not create item in SharePoint List

I have a scheduled flow that takes an excel file as an input and creates a item in SP list for each new entry in excel and updates the old items. 

 

However, on running the flow, it is not able to create an item in the SP List. The flow runs are successful. I cannot find a fault in the flow or its run history. By all accounts in Power Automate everything is working as usual, but my SharePoint List is missing the newest entries.

 

In flow run, the create item shows as disabled.  

 

Any ideas where the error might be?

Microsoft Flow

2 Replies

  • Rob_Elliott's avatar
    Rob_Elliott
    Silver Contributor
    Aug 27, 2024

    rohitbajaj you need to provide a bit more info about what's in the condition, the problem is most likely there.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

    • rohitbajaj's avatar
      rohitbajaj
      Icon for Microsoft rankMicrosoft
      Aug 27, 2024

      Hi Rob_Elliott, I am checking if the entry from excel already exists in SP list or not. If it exists, I update the SP list item. If not, I create a new list item. 

      Condition: length(outputs('Get_items')?['body/value']) > 0

       

      Image: 

       

      I am referencing this youtube tutorial: https://www.youtube.com/watch?v=-ZaktFuS1KA

       

       

Resources