You’re offline. This is a read only version of the page.
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.
When you query the Users List, You can add Filter Expression to filter the list item where your title matches the User name. And then you can add Cost Center. It will still add Apply to each but it should only run once since you will have only one record in the Users list that matches. Something like below...
Another best option is to add Lookups in all the list that points to the user list. And when you add Lookup column, add other columns like cost center along with it.
Share
Report
All responses (
Answers (
784
