Good evening, everyone.
Please, Could you help me with the following question?
From Monday to Friday, I have a new data table with the similar structure (I attacht an example image about it).
I would like to generate a HTML table and insert it to an email body and next send it to each provider (I attacht an example image, also).
The HTML table will be generated from filter every "Provider Code" on the table in excel file.
Is posible make that flow and can automate its?
Thank you very much in advance.
Greetings,
Jhonatan Ora
DataTable
Example HTML table with Code_01
Example HTML table with Code_03
Please provide the final flow of this query
Good morning, @DamoBird365
Thanks for your answer, It helped me with a good idea and I could run the flow.
Have a good Sunday.
Regards,
Jhonatan Ora
In my example I have used an excel data source but you could use a list or CDS. You need to filter an array based on the body of your data source and then use the create HTML action.
You can then include the HTML Table in your Send Email Action.
If you are performing this action on multiple suppliers, you could consider using a config table with a list of supplier names and emails. You could trigger the flow using a schedule and then retrieve the list of suppliers and emails. You can then use an apply to each on the list of suppliers and apply the above steps so that the single flow will deal with all existing (and new as you dd them to the list) suppliers.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here