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?

1 ACCEPTED SOLUTION

Accepted Solutions
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!



View solution in original post

10 REPLIES 10
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?

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!



View solution in original post

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!



hiranfilho
Level: Powered On

Re: HTML table with form format

@abm 

 

First I was studying to understand how to do what you said.
I created a variable and then, in the passenger filter I made a compose applying the line format for each item, then made an append for the variable later, made another compose to put this variable within a larger table, with other information.

Thanks a lot for the help.

I only have another question you have some link on filter on ODATA for GET ITEM

Super User
Super User

Re: HTML table with form format

Hi @hiranfilho 

 

 You asked "you have some link on filter on ODATA for GET ITEM". I didn't understood this correctly. Could you please explain?



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
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,901)