Power Platform Community Forum Thread Details

Hi,

I have a flow that firstly pulls in the custom data from Project Online via a Sharepoint HTTP connection and then populates a Sharepoint list with the outputs of the field data I need to have access to.

This part runs fine, however when the flow runs thereafter it duplicates items already in the list and I need to achieve the following

1) Avoid duplicated being created in the list item when the flow runs

2) Run a flow that allows me to check the HTTP OData coming in from Project Online against what is already held in the Sharepoint list and if there is a match, then do nothing e.g. do not create and item or if there is no match, then create the new item

I use this Sharepoint List data as a data source in a power app, this is bit is fine and all works I just want the clean data to be shown hence the above.

So to provide some context to this, the following is the flow I have generated so far:-

I've noticed the output from the Get Project Online Data on the left hand branch, differs in terms of the field names. In the data the main ID field I need to reference is ProjectIdentifier e.g., however on the output of the SPListdata on the right hand branch, the field name for this ProjectIdentifier is "field 0" e.g.

The issue I am facing is from the information returned from the get data options on both branches, is what the structure of the rest of the flow should be and look like to enable me to check if the item exists in the SP List first and only append any new items from the Project Online get data option if no match exists, but this is where I am confused and or missing a trick somewhere as I am struggling to put the bits together to reference the conditions needed to achieve the desired result. I'm not sure if this is achieved using arrays, filer arrays, compose, unions etc???

I would welcome any thoughts on this please and demonstrable flow examples of how I can close this out and ensure a robust and repeatable flow that run seamlessly. This happens to be the last part of my puzzle but one that is giving challenges.

Many thanks in advance

Stu

Categories:

Building flows