Power Automate: Inner Joins like in SQL | Merge lists based on 1 or more keys

Рет қаралды 2,014

Untethered 365

Күн бұрын

Пікірлер: 18

@PaulieM 10 ай бұрын

Neat video, nice one! 💯

@Untethered365 10 ай бұрын

Thanks man! You were the inspiration.

@PaulieM 10 ай бұрын

@@Untethered365 I saw that and appreciate you! Looking forward to see your future videos.

@snipermanx53gonemad 3 ай бұрын

Took me a solid two hours but got it working, many thanks

@Untethered365 3 ай бұрын

Superstar!

@travistaylor742 4 ай бұрын

Hey there - Great video, just had a question: at 4:39, you are passing an XML object into a Select node - right as you are adding the "addproperty" into the map. I am getting an error at this stage, the select node only wants to take an array, not an object. Are you wrapping your XML output in something else to make the Select work properly?

@Untethered365 4 ай бұрын

Great question! In this case it should be an array in both settings so make sure you're selecting the node properly in the xpath expression.

@clariananogueira2233 3 ай бұрын

I had the same error. Try using the Select body as the *From input instead of the XML in the last expression (where we created the inner join itself). It worked for me :)

@Untethered365 3 ай бұрын

@@clariananogueira2233 way to be on it!

@markweyman 8 ай бұрын

I already subscribe to PaulieM and have seen his video; love your use case. I have to combine several CSVs, and this is how I will do it. TY both :)

@SeanAstro 8 ай бұрын

Glad to hear! Paul is the man.

@PavanCh-q2u 23 күн бұрын

Hi, great content... I have similar use, but where I need to show Types or SubTypes from Column5 related and other columns on top in the same (one column) with corresponding numerical fields. I was able to achieve this till column5 using xpath expression as part of json structure, but struggling a lot to get the child values of/from Column5. Name Sales Profit Column1 500 200 Column2 500 200 Column3 500 200 Column4 500 200 Column5 500 200 Type1 200 50 Type2 100 50 Subtype1 100 50 Type3 200 100 Subtype1 100 50 Subtype2 100 50 Any suggestions or help...Thanks in advance.

@Untethered365 23 күн бұрын

@@PavanCh-q2u what does your source data look like?

@PavanCh-q2u 23 күн бұрын

@@Untethered365: The source data (I am getting in Power BI report and same needs to be exported to csv/excel in the output as I mentioned previous comment and the source data: Category SubCategory Column3 Column4 Column5 Type Task Sales Profit Office Supplies Appliances ABC XYZ XABS AG-1 Task1 10 5 Office Supplies Appliances ABC XYZ XABS AG-1 Task2 15 10 Office Supplies Appliances ABC XYZ XABS AG-1 Task3 25 10 Office Supplies Appliances ABC XYZ XABS AG-1 Task4 15 5 Office Supplies Appliances ABC XYZ XABS AG-1 Task5 15 10 In total there will be 8 dimensions/categorical fields as of now I have mentioned only 7 from Category to Task (The user has the fleixibility to select the list of fields from Category to Task) at least they will select till Column5 for sure so need to show aggregated value that I was able to achieve and there will be 8-10 measures and currently I have mentioned (Sales/Profit)...The main child values will need to show as a child/append rows from Column5....Till Column5 I was able to achieve using json structure with xpath, but struggling to get from Type and Task... Thanks in advance.

@PavanCh-q2u 22 күн бұрын

@PavanCh-q2u 18 күн бұрын

Hi, Any suggestion...I am still got stuck...not finding solution...any help/suggestions really appreciated and will be helpful. Thanks.