Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Formatting of value in Create HTML table

(1) ShareShare
ReportReport
Posted on by 47
I have created a flow that will get a list of items and extract the values in a multi choice column, create an HTML table and send it via email. 
 
I have watched several videos and used a Select for the extraction of the multiselect.
 
It is extracting the values correctly.
 
When I get to the Create HTML Table step, I am uncertain what to put in the Value column  for "BizApps".  With everything I have attempted I either get the entire odata line of code or it is blank. 
 
I do not have the option to select "Business Apps Value" from the dynamic content. I do not have a "see more" option to expand the content.  
 
Could anyone provide advice on the formatting?  Thank you in advance.
Tracy
  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,115 on at
    Formatting of value in Create HTML table
    Hi 
     
    Try this as per video 
     
    Thanks & Regards,
    Nived N 
    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs
     Found my answer helpful? Please consider marking it as the solution!
     Your appreciation keeps me motivated. Thank you!
  • TMProgUser Profile Picture
    TMProgUser 47 on at
    Formatting of value in Create HTML table
    If you are asking about the results, it comes out as the odata string.
  • TMProgUser Profile Picture
    TMProgUser 47 on at
    Formatting of value in Create HTML table
    I am assuming you are asking about the column in the SharePoint table.  It is a Choice column set up as a checkbox.
    When you view the data in the table it is a list such as Biz1,Biz2,Biz3.
  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,115 on at
    Formatting of value in Create HTML table
    Also how the multi select choice column values appear in the html table ?
     
     
  • TMProgUser Profile Picture
    TMProgUser 47 on at
    Formatting of value in Create HTML table
    This is the only option available for business apps when I search for the column name in the create table.  
     
  • Suggested answer
    Nived_Nambiar Profile Picture
    Nived_Nambiar 17,115 on at
    Formatting of value in Create HTML table
    Hi 
     
    does it have value attribute present in it ?
     
    Thanks & Regards,
    Nived N 
    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs
     Found my answer helpful? Please consider marking it as the solution!
     Your appreciation keeps me motivated. Thank you!

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard