Search code examples
power-automatepowerapps

Integration with excel in powerautomate

I want to make a excel sheet data into a table using automate. The excel has first row to be used as header and rest as data but to be made table in automate like we do using Ctrl +T in excel manually.

Data is already in the excel file.If not possible please provide valid sources

Solution

  • you can use the Create Table connector in Excel. but you may need to specify the range of the table manually.

    enter image description here

    sample data

    before running: enter image description here

    after running:

    the table name is also updated enter image description here

    Note: when power automate succeeded, wait to reflect the changes in file. it may take around 1 minute or less to reflect.