Check if a value exist within a Select

(0) Share

Report

Posted on by osolbakk

Hi.

I'm fairly new to power automate and I'm struggling with a good way to check if a value exist with in a Select.

I have a variable that I set to "123456789". Is there a way to check if this values is in "SAP_VENDOR_KEY" within the select? I can compare against SAP_VENDOR_KEY & VENDOR_NAME but not the one value alone.

Hope someone can help me with this issue. 🙂

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@osolbakk are you using Get Items action in your flow. In the Get Items output do you want to check if any items has Vendor ID which equals to the variable value? Also any reason why you are using Select action?

Was this reply helpful? Yes No
osolbakk 8 on at

Like (0)

Report

I actually have two Get Items.

What I'm doing here is compare the two lost an check if there are any new ones in "Initial list"
The filter array will compare the two select against each other and gives me new list items. It check if the combo of "SAP_VENDOR_KEY & VENDOR_NAME" exist. and if it don't it will add it to the master list.

But there might be a scenario where VENDOR_NAME has changed but SAP_VENDOR_KEY is the same. Then I want to update the list item with the new VENDOR_NAME instead. This check will be "over" the create list item..

Not Correct... it is here I'm struggling

Was this reply helpful? Yes No
Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
@osolbakk
1. In the apply to each action above Create Item action, add Filter Array action
2. In this Filter Array, select output of master list Select action from Dynamic content
3. On the left side input box of filter array use below expression from dynamic content

item()['SAP_VENDOR_KEY']

4. On the right side input box of filter array use below expression from dynamic content

items('Apply_to_each')?['SAP_VENDOR_KEY']

5. Select equals to from dropdown

6. Then add condition action, use below expression on left input, select greater than from dropdown and on right side provide 0 value

length(body('Filter_array_2'))

7. In Yes branch of condition action, you can get the name of the vendor (the vendor name that has updated) using following expression in Compose action

body('Filter_array_2')[0]['VENDOR_NAME']

8. In No branch of condition action, you can move the Create Item action that you have currently. As the no branch of condition indicates that the Vendor with that ID doesn't exists in the master list.

Screenshot of how your whole Apply to each action will look

Was this reply helpful? Yes No
osolbakk 8 on at

Like (1)

Report

Thank you for the help. This solved my issue.. 😀

Was this reply helpful? Yes No