How to do "VLOOKUP" in PowerAutomate

(0) Share

Report

Posted on by Sami Stranius

Greetings

how would you go about the following task:

using Power Automate, we need to send an email to persons who have not approved invoices assigned to them in the vendor invoice workflow in a given time. The information about the pending tasks is available through the entity WorkflowWorkItems, while the correct emails are available through another entity.

How do you do lookup in the Power automate query language using one Entity record list as lookup value and another record list as search matrix?

Possibly there's need to use a temporary object like a sharepoint list to work like a view, to hold the combined information, and that's fine, but I still struggle to find the right function out of PowerAutomate universum. In Excel I would use VLOOKUP or XLOOKUP.

Appreciate any input.

Here's a sample of dummy data:

2021_2D00_08_2D00_19-14_5F00_09_5F00_16_2D00_Mappe2-_2D00_-Excel.png

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Sami,

Thanks for asking your question. This is a Dynamics 365 Finance forum. There is a Microsoft Power Automate Community where you can ask specific questions about Power Automate.

From a Dynamics 365 point of view, you can create a data entity combining all information in one entity, or first export data to BYOD and create a view with the combined data. In Power Automate, you can also retrieve the user email in the loop by using the Get a record action.

Was this reply helpful? Yes No