Unanswered

HTML table with form format

(0) Share

Report

Posted on by hiranfilho

@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.

Anyeone help me?

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @hiranfilho

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

Was this reply helpful? Yes No
hiranfilho 44 on at

Like (1)

Report

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?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @hiranfilho

Thanks for the reply.

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

Thanks

Was this reply helpful? Yes No
hiranfilho 44 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
hiranfilho 44 on at

Like (0)

Report

Hi @abm,

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.

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @hiranfilho

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.

concat(outputs('Compose_-_First_Table'),outputs('Compose_-_Second_Table'))

Again, you can change this logic accordingly in your for loop.

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.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @hiranfilho

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

Thanks

Was this reply helpful? Yes No
hiranfilho 44 on at

Like (1)

Report

@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

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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?

Was this reply helpful? Yes No