JSON Flow

[rjarc]

Hi Guys, 

Im building a purchasing app in powerapps, i need a flow to email different suppliers depending on the supplier all from one collection. 

Ive tried to do a parse JSON out of powerapps and then use a switch to look at the supplier and email on that outcome. 

I cant figure if its the Parse Json or the variables or if ive just got it completely wrong 

[ChristianAbata]

hi @rjarc  where is shared_office365 variable?

[rjarc]

Hi,

Not got a clue it, it’s not one I’ve made only gives that error in email when nested in the apply to each.

[rjarc]

Just to clarify the error (top picture) appears once the flow runs. The switch fucntion works but errors in the send email

[abm]

Hi @rjarc 

Are you testing the Power Automate using Test using previous runs. If you changed the connection start testing flow using "I will perform the trigger action".

Thanks

[v-bacao-msft]

Hi @rjarc ,

If you use the Power Apps button as a trigger, this error will appear when you add a new connector to this Flow.

Please check the similar thread and refer to the method in it to solve this problem:

https://powerusers.microsoft.com/t5/General-Power-Automate/Flow-Error/td-p/352714

You may need to remove the Flow from the App and re-add this Flow again, then this problem will be solved.

Please take a try.

Best Regards,

[rjarc]

Hi, 

Thats great that solved that!!, 

Last thing is because its nested in a apply to each i get an email multiple times so if i have 3 x items for Supplier A and 2 x items for Supplier B i get x 5 emails. 

Is there any way of filtering or merging to one? 

Appreciate the help

[v-bacao-msft · Accepted solution]

Hi @rjarc ,

You could configure Filter array in each case to filter records and create an HTML table.

Then configure the HTML table in the email body.

You need to get all Suppliers in an array variable and use union() function to remove duplicate elements.

Then iterate the result of the above step and filter records.

Image reference:

You could configure the same process in other cases as Case A.

Please take a try and check if it can achieve your needs.

Best Regards,

[rjarc]

Hi thanks for the help everyone, really dug me out a hole