Lookup one value in list against another

(0) Share

Report

Posted on by Kmayes

754

look at Hi Community

I have a situation where I'm trying to create a flow that checks through one list of items against another list.

The first list of data is collected from running a query against a dataset (Power BI) and the second list is a SP list. I want it then to add the item from the Power BI Dataset to the SP list if it doesn’t already exist. So really need to look at the items in the Power Bi data and check it against those in the SP list.

What is the best way of creating a flow that meets this criteria.

Categories:

Business Process Flows

All responses (4)

Answers (0)

Kmayes 754 on at

Like (0)

Report

Lookup one value in list against another

@DJ_Jamba Im not sure if im being daft or done something wrong but there seems to be alot of items which makes me think it has collected all items that are on the SP list as I would only expect a few items
Suggested answer

DJ_Jamba 2,815 Super User 2025 Season 1 on at

Like (0)

Report
Lookup one value in list against another

OK, so you already have the data from Power BI in one action (Parse JSON) and the data from SharePoint in another action (Get items).

1. After the Get Items action, add a Select action, switch to Map text input mode and configure as follows:

From: @{outputs('Get_items')?['body/value']} Map: @item()?['Ticket ID']

2. Add a Filter array action and configure as follows:

From: @body('Parse_JSON') Filter (edit in advanced mode): @not(contains(body('Select_SharePoint_Ticket_Id_only'), item()?['Ticket ID']))

This will result in all Power BI rows where the Ticket ID does not exist in your SharePoint list
Kmayes 754 on at

Like (0)

Report

Lookup one value in list against another

@DJ_Jamba There is a Ticket ID on both sides
DJ_Jamba 2,815 Super User 2025 Season 1 on at

Like (0)

Report

Lookup one value in list against another

What is the common id, key or foreign key on both sets of data?