Power automate flow

[Aliam]

So i have given a list in form of sharepoint and then created a Microsoft excel template out of it. After that i have created a flow in power automate to make sure when i add a data entry as a row in my excel sheet it should update in sharepoint when i’ll run the power automate. I am able to successfully created and run the flow but when i add the 2nd entry it will create the previous entry again as a row and cause duplication along with the new entry or row. How can i tackle it as i am new to the power automate platform.

[SudeepGhatakNZ]

This situation involves a dual looping problem.

Referencing an item from "Get items" creates a loop due to the multiple rows retrieved.

Similarly, referencing Excel fields generates a loop for each row in the Excel file.

Could you provide more details about your goal? An example would help in understanding what you're attempting to achieve.

[Aliam]

As i have show in the pdf when i enter a new entry in an excel sheet it updates in the sharepoint when i run the power automate but along that it also create the previous entry as a duplicate which I don’t want. I just want the old entry to stay in share point and when i enter a new one in excel only that entry or row should update in share point.

[David_MA]

I have to agree with @SudeepGhatakNZ , more explanation of what you are trying to accomplish is needed. The screen shots are helpful, but they don't really explain what you are trying to accomplish. It looks like you are getting the properties of all the files in a document library, then you are going through each file and listing the rows in a spreadsheet, then you are creating an item in a SharePoint list with the data from the Excel spreadsheet. If you already know the spreadsheet where you need to get the rows to populate into your list, why do you need to get the file properties?

And when you say, "So i have given a list in form of sharepoint and then created a Microsoft excel template out of it." Do you mean you have a SharePoint list that you exported to Excel? If so, that is probably your issue. When you do this, it creates a connection to your SharePoint list, so when you refresh the data in the Excel spreadsheet, it updates it with the data from your SharePoint list.

Or do you mean that you have a SharePoint list, and you separately created an Excel spreadsheet that mimics the SharePoint list? If so, are you just trying to keep the Excel spreadsheet in sync with the SharePoint list? If so, just export your spreadsheet to Excel and refresh the data when you want it updated.

[IAmIntractable]

I would question the need to keep an Excel document in sync with a SharePoint list. Send people to the list and look for ways to avoid using Excel as a database.