![]() ![]() Find out about new features, capabilities, and best practices for connecting data to deliver exceptional customer experiences, collaborating using AI-powered analytics, and driving productivity with automation. ![]() Sign up below for an in-depth look into the latest updates from across Microsoft #PowerPlatform and #Dynamics365. Microsoft Business Applications Launch Event - On Demand You can subscribe to the News & Announcements and stay up to date with the latest news from our ever-growing membership network who quickly discover that "Community is bigger on the inside". Welcome to our April 2023 Community Newsletter, where we'll be highlighting the latest news, releases, upcoming events, and the great work of our members inside the Biz Apps communities. To view the final output, I've added a Compose outside all the loops to show the contents of the output array variable. Then we append the owner object to the output array variable. We then build up the owner object using the Current Item (OwnerID) from the Apply to each owner loop, and the output of Select Properties. Next, we use a Select to get the property details for the owner using the output of the Filter array. The full Apply to each owner is below:įilter array takes in the value from List rows present in a table, and filters on the OwnerID equal to the Current Item. Within the loop we filter the items returned from Excel for each owner, then select each of the owner's properties, and build up our objects. ![]() Now we can loop over each of the unique owners (using output from Compose Unique Owners). Union(variables('owners'),variables('owners')) We can use a union expression to remove duplicates, so we have a unique list of OwnerIDs. This will contain duplicate OwnerIDs which we'll remove in the next step. Next, we loop over the rows and append each OwnerID to the owners array. List rows present in a table gets the Excel items. Owners of type array that will hold each of the owners. Output of type array that will contain the final output. I've built a flow that gets what you're after.
0 Comments
Leave a Reply. |