cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rafi02
Frequent Visitor

Not able to solve the duplicate share point list item creation from excel and also update item is not working

Below is the flow configured, kindly help to solve this issue please.

I am trying to transform row items from a excel table to list items in share point list

when i am trying to create its working and whenever its Run and its create duplicate records and when i am trying to update its not updating instead its failing. kindly review and suggest what mistakes i am doing here.

1.PNG2.PNG

 

 
2 ACCEPTED SOLUTIONS

Accepted Solutions
v-bacao-msft
Community Support
Community Support

 

Hi @Rafi02 ,

 

There seem to be some unnecessary steps in your Flow configuration. In addition, you only configure one parameter in Filter Query, which seems to be infeasible. Please refer to the following blog for more details about Filter Query:

https://sharepains.com/2018/11/12/sharepoint-get-items-odata-filter-query/

 

To briefly summarize your needs is to insert the excel rows into the List, if the corresponding item already exists, then update the item.

You are updating the item with the Incident ID as the key column. Please refer to the method below to update Flow and see if it works. Suppose the type of Incident ID is a string.

Image reference:

14.PNG

Details in Condition:

15.PNG

Hope this helps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Rafi02
Frequent Visitor

Issue got resolved, below is the final outcome of the flow to create and update sharepoint list using excel(online).

 

1.PNG2.PNG

View solution in original post

5 REPLIES 5
v-bacao-msft
Community Support
Community Support

 

Hi @Rafi02 ,

 

There seem to be some unnecessary steps in your Flow configuration. In addition, you only configure one parameter in Filter Query, which seems to be infeasible. Please refer to the following blog for more details about Filter Query:

https://sharepains.com/2018/11/12/sharepoint-get-items-odata-filter-query/

 

To briefly summarize your needs is to insert the excel rows into the List, if the corresponding item already exists, then update the item.

You are updating the item with the Incident ID as the key column. Please refer to the method below to update Flow and see if it works. Suppose the type of Incident ID is a string.

Image reference:

14.PNG

Details in Condition:

15.PNG

Hope this helps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hello Dear,

 

Still the problem persists, i followed advised steps and got the below results but dint create items nor updated.

 

4.PNG

 

3.PNG

Rafi02
Frequent Visitor

Below is the output for the same:

 

{"statusCode":200,"headers":{"Transfer-Encoding":"chunked","Vary":"Accept-Encoding","X-SharePointHealthScore":"1","X-MS-SPConnector":"1","X-SP-SERVERSTATE":"ReadOnly=0","DATASERVICEVERSION":"3.0","SPClientServiceRequestDuration":"76","SPRequestGuid":"887479aa-2a64-4b97-8836-54b3353124b7","request-id":"887479aa-2a64-4b97-8836-54b3353124b7","MS-CV":"qnl0iGQql0uINlSzNTEktw.0","Strict-Transport-Security":"max-age=31536000","X-FRAME-OPTIONS":"SAMEORIGIN","MicrosoftSharePointTeamServices":"16.0.0.19805","X-Content-Type-Options":"nosniff","X-MS-InvokeApp":"1; RequireReadOnly","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"true","Cache-Control":"max-age=0, private","Date":"Mon, 24 Feb 2020 09:35:25 GMT","P3P":"CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"","X-AspNet-Version":"4.0.30319","X-Powered-By":"ASP.NET","Content-Type":"application/json; charset=utf-8","Expires":"Sun, 09 Feb 2020 09:35:26 GMT","Last-Modified":"Mon, 24 Feb 2020 09:35:26 GMT","Content-Length":"12"},"body":{"value":[]}}

 

Hi @Rafi02 ,

 

Please follow the screenshot I provided to configure Flow.

 

There is no need to configure Top count, and there is no need to add Apply to each outside of Create item because when you create an item, you don't need to use the content output by Get items action.

 

Please take a try again.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Rafi02
Frequent Visitor

Issue got resolved, below is the final outcome of the flow to create and update sharepoint list using excel(online).

 

1.PNG2.PNG

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (1,014)