In this guide, you'll learn how to create a flow and update an Excel Table directly from Microsoft Power Automate.
You could also watch:
Microsoft Power Automate Tutorials • Microsoft Power Automate Beginners Co...
Get Forms responses to Excel with Power Automate • Microsoft Power Automate How to get...
00:18 Inspect Excel data
The data for our simple Power Automate use case is quite simple (ID, Name, Sale). It is important, that you have formatted your Excel data as a table.
00:52 Create Instant Flow
We create a manually triggered flow, but you could fine schedule or trigger your Power Automate flow.
01:20 Manually Trigger a Flow (Text and Number)
A unique identifier and then two columns of sales data will be inputted, when the Power Automate flow run.
02:18 Add a Row Into a Table
To update our Excel table with a new row, we chose 'Add a Row Into a Table'. Specify Location, Document Library, File, and Table. Finally specifying the dynamic content.
FOLLOW ME:
LinkedIn: / andersjensenorg
Twitter: / andersjensenorg
Instagram: / andersjensenorg
Facebook: / andersjensenorg
Discord: / discord
Email Newsletter: https://andersjensen.org/emailnewsle...
#powerautomate #microsoft #excel