PowerAutomate - Compare arrays with objects

  Рет қаралды 1,894

Markus Schiller

Markus Schiller

Күн бұрын

Пікірлер: 7
@HPZOT
@HPZOT 7 ай бұрын
Thanks, i've been banging my head with this for about 3 days.
@MarkusSchiller
@MarkusSchiller 7 ай бұрын
Believe me, I've been there. I know it's not a perfect solution, but it gets the job done in most of the cases. :-)
@anna-878
@anna-878 5 ай бұрын
Very good video! Thanks a lot, will be testing it in my setup now
@wassim2k
@wassim2k 3 ай бұрын
Flow checker error for the formula. Says correct to include a valid reference to 'select name' for the input parameters of action
@MarkusSchiller
@MarkusSchiller 3 ай бұрын
@@wassim2k Well, what is the name of the action that you're referencing on and what is in your formula?
@timelliot8463
@timelliot8463 6 ай бұрын
Yo! I.... Barely grasp the logic... you filter array A using values from Array B with condition saying does not include item().... item () - current item in each iteration of a looped action. So..... Filter array deep inside of its architecture is a loop? While combing through items of an array A, it checks if array B has it or not? Wow. Thank you. It's advanced. P.S. Didn't know you can filter something by using values from some other actions in the left operand of the condition... So... instead of conventional approach to filter array A, where items from array A are on the left and specific value on the right, we can use specific value on the left and items from array A on the right... Good to know!
@MarkusSchiller
@MarkusSchiller 6 ай бұрын
Exactly, you can look if an item of Array A is in Array B. But both arrays need to have the same structure, so it's comparable. I'm happy if I can help
Power Automate Flow filter array to create summary SharePoint Data
26:23
We Attempted The Impossible 😱
00:54
Topper Guild
Рет қаралды 56 МЛН
coco在求救? #小丑 #天使 #shorts
00:29
好人小丑
Рет қаралды 120 МЛН
Мясо вегана? 🧐 @Whatthefshow
01:01
История одного вокалиста
Рет қаралды 7 МЛН
How to compare Excel Tables/Sheets in Microsoft Power Automate
24:48
Power Automate | Apply to Each | Why? | Arrays and Objects
19:05
DamoBird365
Рет қаралды 47 М.
PowerAutomate   Get more than 5000 files or folders into a single array
11:52
Are you using the Microsoft Power Automate Filter Array Action wrong?
22:45
A Creative Opinion
Рет қаралды 29 М.
How to parse complex JSON in power automate
20:43
Alireza Aliabadi
Рет қаралды 86 М.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 284 М.
We Attempted The Impossible 😱
00:54
Topper Guild
Рет қаралды 56 МЛН