Can someone help me?
I have two related tables in Sahrepoint where Principal is taxi solicitation and second is passenger.
Taxi Request List Fields:
- Round trip
- Aging Date
- Reason for Solcitation
Passenger List Fields:
- Arrival time
- Place of departure
My flow after the taxi request, which may have several passengers, goes for approval. Once approved, you must email the transportation industry with the completed standard form so that the transportation industry can make taxi schedules.
I managed to create the whole flow, but my problem is in the form of the standard form, I thought of using table, but the responsible sector did not accept, so below is what should be the form that should go in the body of the email.
Anyeone help me?
Hi @abm ,
The third party did not accept the first email sent by the stream, which was with the normal HTML table.
They want the same image ie it is not a table but a form in my understanding where I highlighted in red should grow according to the number of passengers.
See that I put in the form where are the fields in the list
could you help me?
Thank you you are helping me.
I don't think I could express myself well before.
The third part accepted in the e-mail body in HTML or attached email as long as the form conforms to the image I am sending, where the information is not columns and repeats every 3 lines.
Coud you help me?
These images above are as I need the repetition part of the passengers, there it is as if they were 2 passengers,
if they were more passengers would repeat.
I can do a table with a column by calling the HTML TABLE action in FLOW, but I don't know how to do this format above.
Thanks for your reply.
I don't think you can achieve this using HTML Table action. You could construct the HTML format in a table using a string or compose statement for each results then append the results into another string. This way you could append all the formats under one string. Finally use the append results (HTML Table Rows and rows) into your email.
Follow the below steps:
I have used a manual trigger and declared a string variable
Next I have a compose step. Here I have used a HTML format. Instead of hard coded values you can map your fields here.
Next I have another compose similar like above. So in your case you can manage in this a loop using one compose only.
Next I have used another compose and used expression concat to combine both compose outputs.
Here is the expression I used.
Above send email set HTML as Yes.
Finally my email test result:
Hope this is useful and let me know if you need any further help in this.
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!