Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Is it possible to copy excel tables in power app text input field ?

(0) ShareShare
ReportReport
Posted on by 6

Requirement is to copy excel tables and paste it in text input field as table with borders. We trying to append the text input field to send email as body.

 

We tried in rich text editor, but it is not allowing the border lines while paste in power app. 

  • AndrewR1 Profile Picture
    1,572 Super User 2025 Season 1 on at
    Re: Is it possible to copy excel tables in power app text input field ?

    You could try using the HTML text control and then using this create a table and input your data directly in to the HTML? for Example: 

    "<table>
     <tr>
     <th "&TDStlye&">Company</th>
     <th "&TDStlye&">Contact</th>
     <th "&TDStlye&">Country</th>
     </tr>
     <tr>
     <td "&TDStlye&">Alfreds Futterkiste</td>
     <td "&TDStlye&">Maria Anders</td>
     <td "&TDStlye&">Germany</td>
     </tr>
     <tr>
     <td "&TDStlye&">Centro comercial Moctezuma</td>
     <td "&TDStlye&">Francisco Chang</td>
     <td "&TDStlye&">Mexico</td>
     </tr>
     <tr>
     <td "&TDStlye&">Ernst Handel</td>
     <td "&TDStlye&">Roland Mendel</td>
     <td "&TDStlye&">Austria</td>
     </tr>
     <tr>
     <td "&TDStlye&">Island Trading</td>
     <td v>Helen Bennett</td>
     <td "&TDStlye&">UK</td>
     </tr>
     <tr>
     <td "&TDStlye&">Laughing Bacchus Winecellars</td>
     <td "&TDStlye&">Yoshi Tannamuri</td>
     <td "&TDStlye&">Canada</td>
     </tr>
     <tr>
     <td "&TDStlye&">Magazzini Alimentari Riuniti</td>
     <td "&TDStlye&">Giovanni Rovelli</td>
     <td "&TDStlye&">Italy</td>
     </tr>
    </table>"

    AndrewR1_0-1694775932078.png

     


    Where TDStlye = Onstart of the app 

    Set(TDStlye, "style='border: 1px solid black;'")

    I would recommend setting up variables for the Styles and then insetting them like above as then you have one place for and changes need otherwise yo would need to make the change across all the TDs

     

    You would have to tweak the styling to suit what you want but this is a good way of approaching this  as the html table can then be directly inserted in to the email. 

    If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

    If you like my response, please give it a Thumbs Up.

     

    Many Thanks
    Andrew




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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard