cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

JSON Flow

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 

 

Capture.PNGCapture1.PNG

 
 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: JSON Flow

 

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:

154.PNG155.PNG

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

8 REPLIES 8
Highlighted
Super User III
Super User III

Re: JSON Flow

hi @rjarc  where is shared_office365 variable?



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
Highlighted
Frequent Visitor

Re: JSON Flow

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.
Highlighted
Frequent Visitor

Re: JSON Flow

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

Re: JSON Flow

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Highlighted
Community Support
Community Support

Re: JSON Flow

 

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: JSON Flow

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

Highlighted
Community Support
Community Support

Re: JSON Flow

 

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:

154.PNG155.PNG

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,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Frequent Visitor

Re: JSON Flow

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (6,548)