Watching again and AGAIN it's wonderful! My only issue is that the second List (Let's say Order or Order details) has too much data and I need to filter it first to bring only order for Customers get item (which has fixed filter). I'm looking for some way without damage (Apply to each) all this beautiful flow!
But what if for example a customer didn't place an order. His id will not be found in the orders tabel. When I try this method, i get an error. How can i handle this?
You could watch this ? Create Excel File and Add Rows Fast | Graph API | Office Scripts | Power BI | Power Automate ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gtlklzi6MDg.html
Hi Damien, quick question - I'm trying to merge two lists from Sharepoint, my trigger is when an item is modified or created in the first list, and the second list is 2 columns, one unique ID and an email column. I'm trying to have the second table's email's appear as an option in the "Send an Email V2" operator but haven't had luck. Do you know if this is possible? Thank you!
Really Nice Learning.! I had to go through it twice and build the solution. I only used 10 orders and made the mistake of using the SharePoint Title column (which always gets in the way) for CustomerID--thus it was Title. Didn't know you could use objects like this. Also, didn't know the Select could draw from different arrays at the same time.
Good, clear explanation Damien! I remember doing this type of join in the SharePoint Batch Update template, but deciding it would be too much to go through how it works. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-l0NuYtXdcrQ.html I’m glad I can point people to this piece now.
Great minds think alike. I've used it a couple times before, like for Planner GUIDS. I notice you have done it slightly different but the same idea of Id:Object. Good to see another example out there 👍 shaving some time off of our flows.
Love the video--still working through. Had to setup some lists. One point of confusion--you say semicolon when I think you mean colon. (Just trying to get the syntax right)
Possibly, the physical expression onscreen should be correct? My poor brain during all of this. Sometimes hard to coordinate my mouth and my hands at the same time.
Год назад
👍 I always feel so lucky when you type out those lengthy concat expressions and just click update without copying it first into your clipboard. #norisknofun
Living on the edge there 😂 I’ve also seen power automate tell me my expression is wrong and I click update a 2nd time and accepts. Come on Power Automate, I know how to write an expression. I am sure I dropped repurpose in there today too.
Just want to add to the chorus by thanking you for an excellent video. Had a couple of hiccups - with semi-colons rather than colons - but that was user error. Absolutely first class - thanks again!
The timing of this video couldn't be more perfect!!! Trying to figure out how to pull data from 2 fields base a common location code and then perform certain actions on it. I think understanding this technique will be ideal for my use case. Thanks for sharing.
In my mind, this video compliments ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PD980sKKx0E.html which demonstrates how to use an external data source to simplify branching. Glad it's been helpful Douglas 👍
I followed your steps but using two arrays instead of Get Items. My key field is called 'jobNumber' as that's the only field between the 2 arrays that match. So in the final Select action I'm either referencing item()?['fieldName'] or the long outputs formula you provided. All works except it's only returning results for a single 'jobNumber' when I have many 'jobNumber's in my arrays. Is my need excluded from this method, leaving me with looping?
Are you saying you have, for example 10 job numbers but the final output is 1? You must have a mistake in your build. The job number in input should match the number of objects in output.
I have the same problem dealing with a 1 to many tables. The culprit is the json() expression where it omits duplicate key object, and the key object from your case is the jobNumber.
Similar approach can be achieved using xpath inside Select expression - which one would be faster for large lists (what do you think @Damien / @Paul) ?
@@piotrrusak I haven’t tested but I think they would be similar - there is a video on my channel on the xpath method. They would both only consume a single action, and the select action always seems to do it’s work fast.
You’ll need to test it for your scenario. I have had performance issues with xpath. I had considered featuring side by side in the video as larger data sets get slower exponentially in xpath. But like any solution, test and go with what suits your scenario. It’s worth knowing about both options. When I tried to map multiple fields using xpath it took 10s of minutes. This method was over and done with in 10s of seconds. But maybe Power Automate was having an off day.
For some reason all of the values I add from the second array all come up null. EDIT: I figured this out. You are merging two object arrays into another array, I only needed to merge one object into another array.
@@AdamHaas it’s because ? in an expression returns null if the path is not found. Most likely a typo in a key name or your expression isn’t quite right.
I was creating a flow to sync some data between devops and sp list, initially tried loops but it was painfully slow. With your method the whole thing takes few seconds.
Thank you so much for the great information. Can I use the same method for Dataverse? Example: I want to collect all activities of related to the account and sort the last 5 activities based on the created on field.
Assuming two identical Array’s, how would you merge records based on their position in the array. i.e. item()?[0] from one into item()?[0] of the other? In my Flow, I’m stuck on this part `outputs(‘Compose_Customer_Object’]?[item()?[‘CustomerID’]]?[‘FirstName’]`. What is I don’t want to do `item()?[‘CustomerID’]` to merge based on ‘CustomerID’? What if I simply want to do `item()?[0]`, where [0] is the index for each line? I can’t do any Apply to Each actions. My array’s are like 200k long lol.
Hi Damo, I have the same procedure and i am getting error for compose action. Unable to process template language expressions in action compose inputs at line 0 and column 0. I used the same expression as you mentioned and the same is working with json() but when i am trying to use json() i am getting the above exception. Can you please help me with this
I was looking for the equivalency of sql join statement for API calls to start building a power app for our field crews. The API returned one data set with an id field that needed to be mapped to another api call that had the english translation for the id field. @@DamoBird365
I know it was a year ago I first watched this, but I finally had a need for it so rewatched it. It really is a great bit of teaching and if I think how I might have tried to do what I'm doing without knowing this (apply to each) it would have taken significantly longer. I've managed to get my array of 4000 items matched to another array and the items where there is a difference reported in minutes. 👍👍
Hi Damien. I'm getting the following error when I attempt to create the Object in a compose action. Any ideas where I went wrong? "InvalidTemplate. Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language function 'Json' parameter is not valid."