Help - Duplicating Items in a dataverse table

(1) Share

Report

Posted on by CU23071121-0

Hi,

I have a flow that runs daily for data that is within SharePoint. It initializes a variable for the Status > Gets all items from the Sharepoint List > Lists all the current rows from the dataverse table > Then initializes a variable for a Invoice Number

Then it a condition to check is the status in the list is the same as the variable and if the item in the sharepoint list is older or equal to 60 days ago (this condition check works)

Then if both those checks are correct, it should check to see if the item is currently in the dataverse table or not, but at the moment it is not working, it is just duplicating all items in the table and keeps adding them.

In the condition, I am checking to see if the invoice number from the dataverse table is the same as the number in the sharepoint list, if it isn't the same it shouldnt add it into the the table but it is.

How do I compare both lists and only add in items that arent in the dataverse list?

I can provide more information if needed.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Ninjasabi 122 on at

Like (1)

Report
Copy link

Link copied!

- trigger: Recurrence
inputs:
frequency: Day
interval: 1

- action: Initialize variable
inputs:
name: varStatus
type: String
value: "YourStatus"

- action: Get items
inputs:
siteAddress: "YourSharePointSite"
listName: "YourSharePointList"

- action: List rows
inputs:
tableName: "YourDataverseTable"

- action: Filter array
inputs:
from: "@outputs('Get_items')?['body/value']"
where: "and(equals(item()?['Status'], variables('varStatus')), lessOrEquals(item()?['Created'], addDays(utcNow(), -60)))"

- action: Apply to each
inputs:
items: "@outputs('Filter_array')"
actions:

- action: Filter array
inputs:
from: "@outputs('List_rows')?['body/value']"
where: "equals(item()?['InvoiceNumber'], items('Apply_to_each')?['InvoiceNumber'])"

- action: Condition
inputs:
condition: "@equals(length(outputs('Filter_array')), 0)"
ifTrue:
actions:

- action: Add a new row
inputs:
tableName: "YourDataverseTable"
data: {
"InvoiceNumber": "@items('Apply_to_each')?['InvoiceNumber']",
// Add other fields as needed
}

Was this reply helpful? Yes No
CU23071121-0 on at

Like (0)

Report
Copy link

Link copied!

I keep getting this error on the first Filter Array

Was this reply helpful? Yes No