cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hiranfilho
Level: Powered On

HTML table with form format

@Pstork1 ,  @yashag2255 ,  @abm @RezaDorrani  ,  @ScottShearer 

 

Hi all,
Can someone help me?
I have two related tables in Sahrepoint where Principal is taxi solicitation and second is passenger.

Taxi Request List Fields:
- Department
- Round trip
- Aging Date
- Reason for Solcitation
- Requester
- Function
- Telephone

Passenger List Fields:
- Passenger
- Telephone
- Arrival time
- Place of departure
- Destination

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.

 

taxi.PNG

 

Anyeone help me?

8 REPLIES 8
Super User
Super User

Re: HTML table with form format

Hi @hiranfilho 

 

Is that HTML table with email is not going to accept by the third party?

 



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!



hiranfilho
Level: Powered On

Re: HTML table with form format

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.

 

taxi.PNG

 

See that I put in the form where are the fields in the list

 

could you help me?

Super User
Super User

Re: HTML table with form format

Hi @hiranfilho 

 

Thanks for the reply.

 

So which format they expecting this as? You can only send this as email?

 

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!



hiranfilho
Level: Powered On

Re: HTML table with form format

Hi @abm 

 

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?

Highlighted
hiranfilho
Level: Powered On

Re: HTML table with form format

Hi @abm,

 

taxi2.PNG

 

taxi2.PNG

 

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.

Super User
Super User

Re: HTML table with form format

Hi @hiranfilho 

 

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. 

 



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!



Super User
Super User

Re: HTML table with form format

Hi @hiranfilho 

 

Follow the below steps:

 

I have used a manual trigger and declared a string variable

tabe1.png

Next I have a compose step. Here I have used a HTML format. Instead of hard coded values you can map your fields here. 

 

tabe2.png

 

Next I have another compose similar like above. So in your case you can manage in this a loop using one compose only.

 

tabe3.png

 

Next I have used another compose and used expression concat to combine both compose outputs.

 

Here is the expression I used.

concat(outputs('Compose_-_First_Table'),outputs('Compose_-_Second_Table'))
 
Again, you can change this logic accordingly in your for loop.
 

tab4.png

 

Above send email set HTML as Yes.

 

Finally my email test result:

 

tab5.png

 

Hope this is useful and let me know if you need any further help in this.

 



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!



Super User
Super User

Re: HTML table with form format

Hi @hiranfilho 

 

How you progressing with this? Do you need any further help in this?

 

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!



Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 369 members 6,602 guests
Please welcome our newest community members: