Power Platform Community Forum Thread Details

Hello all,

I have a Power App to request vehicles on my company. This Power App is supported on sharepoint lists and now, for performance and cost division reasons, I need to create a power automate that allows me to copy the past items to an aggregate list. I have 6 lists that are related by lookup columns and I will put my question based on just 2 lists that I need to conciliate.

Request List - Contains all the requests, including user e-mail that made the request and additional passengers.

Users - Contains all info about that user (Company, cost center...)

I need to put both on the same list. But when I try to add Cost Center field on the aggregate list, flow automatically creates another apply to each that runs for each user that exists creating duplicated items for the same request, only varying the cost center.

I need a way to do like a lookup between the user name on request to the users list and get the correct one.

Categories:

Building flows