Power Automate Fundamentals # 45: Usage of HTML Table in Power Automate

Introduction:

In Power Platform for certain scenarios data needs to be represented in HTML Table , in those cases we can work with HTML Table Action, as an example we will show list of contacts in an HTML Table.

Step 1:

Login to the required Power Apps environment using URL make.powerapps.com by providing username and password and click on Flows on the left-hand side as shown in the below figure.

Step 2:

After Step 1, Click on New Flow and select instant cloud flow and provide the trigger as Manually trigger a flow and click on Create as shown in the below figure.

Step 3:

After Step 2, name the flow as Working with HTML Table  take another step  under Dataverse Connector ,  select List Rows action and name it as List rows – Get Contacts and provide the following inputs

Table name : contacts

Filter rows : (cr5bc_vaccinationcompleted eq true)

as shown in the below figure.

Step 4:

After Step 3, look for the action Create HTML table and name that Step as Create HTML table – For Each Record and select the following values

From : [@{body(‘List_rows_-_Get_Contacts_’)}]

Columns : Custom

And provide

one set of Header and Value as Name , items(‘Apply_to_each’)?[‘firstname’]

other set as VaccinationCompleted, if(items(‘Apply_to_each’)?[‘cr5bc_vaccinationcompleted’],’Yes’,’No’)

where firstname and ‘cr5bc_vaccinationcompleted’ were taken from apply to each loop output value  as shown in the below figure.

Step 5:

After Step 4, save and run the flow and observe the result and you can see html table in apply to each loop as shown in the below figure.

Note:

  1. Make sure to keep enclose body part of list table inside [] array.
  2. Select Custom in Step 4, to define which columns that are needed, otherwise all columns will be shown.
  3. Always save flow and test it.
  4. Apply to Each automatically comes when firstname was selected in Step 4 .

Conclusion: In this way we can work on HTML Table easily that is present in Power Automate.

2 thoughts on “Power Automate Fundamentals # 45: Usage of HTML Table in Power Automate

  1. Pingback: Rewind January 2022 – Common Man Tips for Power Platform, Dynamics CRM,Azure

  2. Pingback: Rewind January 2022 - Microsoft Dynamics CRM Community

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s