Unanswered

Send order in a single email through a Flow

(0) Share

Report

Posted on by MartinVargas

312

Hi community, I am having a hard time implementing my flow. It happens that for every OrderLine that I add, the mail is sent immediately.

Basically what I'm looking for is that when all the order lines have been added and the "Submit" button is clicked, the order along with its order lines are mailed out.

This is an example of an order with its respective order lines.

This is my flow:

Can anybody help me out here?

Cheers folks.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Ram Prakash Duraisamy 5,699 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @MartinVargas,

Based on your requirement there are 2 ways we can implement the same.

Register Flow as HTTP Request and Pass Order ID as Parameter from Dataverse using SUBMIT button

This Link will help you : https://www.inogic.com/blog/2019/10/how-to-run-microsoft-flow-through-custom-ribbon-button-using-http-request/

Note : in this Link they are passing name as Parameter but you need to Pass ORDER ID as parameter.
Then Use Get Row using Order ID.
Then List Rows to Get Order Line Items.

2. Create a Field in Order Called TRIGGER PROCESS with YES/NO Field.
Create a Flow For Update Operation like below

Then Make a Condition
If(booleanField = Yes) then Process it.

That's it 🙂 If you need any more help, let me know the same

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
MartinVargas 312 on at

Like (0)

Report
Copy link

Link copied!

Hi @rampprakash thanks, I got a bit lost with option 2, could you provide an example please.

Note. So when submit is pressed should the column "booleanField" be activated?

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,699 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello @MartinVargas,

Yes your understand is correct.

(Eg)

Consider the field name as new_booleanfield

On Click of a button --> formContext.getAttribute("new_booleanfield").setValue(true);

Configure FLOW to trigger only on the field change as per my above screenshot and make sure you are checking new_booleanfield is TRUE

because at last all the flow ran we need to update it again to FALSE because we can run multiple times after new changes too.

NOTE:

if you dont want a button, Make the Field visible in form ask the user the change it manually thats it 🙂

Let me know if you need more clarity

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
MartinVargas 312 on at

Like (0)

Report
Copy link

Link copied!
Hi @rampprakash, Thanks I'm having a conflict as putting the following custom javascript doesn't make the change to the boolean column.

function OnSubmit (executionContext) { var formContext = executionContext.getFormContext (); formContext.getAttribute ("crd4f_estadodelpedido"). SetValue (verdadero); }

This is the boolean column:

This is the submit button:

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,699 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @MartinVargas,

Could you please send me in English 🙂

Was this reply helpful? Yes No
MartinVargas 312 on at

Like (0)

Report
Copy link

Link copied!

Hello @rampprakash, I'm sorry, I still have the problem.

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,699 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Wow cool @MartinVargas,

Could you please approve as answer of any of our answer helps else please provide your answer so that community can do the same further.

Was this reply helpful? Yes No
MartinVargas 312 on at

Like (0)

Report
Copy link

Link copied!

Sorry, I still have the problem.

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,699 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @MartinVargas,

That's my bad, my understanding was wrong, I thought you are triggering from DataVerse.

If you are sending from portal, try setting the field from portal to this Boolean field from Portal.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
MartinVargas 312 on at

Like (0)

Report
Copy link

Link copied!

Hi @rampprakash, In fact I'm looking for the next post. But I require it with the "Send" button

https://powerusers.microsoft.com/t5/Power-Apps-Portals/Adding-Flow-to-Power-Portal-Button/td-p/676307

Was this reply helpful? Yes No