When an Excel row is created, modified, or deleted

Power Automate template workaround for "When an Excel row is created", "When an Excel row is modified", and/or "When an Excel row is deleted" triggers.
Community Thread & Template Download Page: powerusers.microsoft.com/t5/P...
HTML Table Styling: ryanmaclean365.com/2020/01/29...
Venmo
venmo.com/u/Tyler-Kolota
PayPal
www.paypal.com/paypalme/takol...
Buy Me a Coffee
www.buymeacoffee.com/takolota
Thanks for any feedback,
And reach out on LinkedIn ( / kolota ) if you want to hire me to consult or build more custom Microsoft solutions for you.

[@faizangulzar1973]

Hi! Great tutorial, but I am stuck with a point if you could help me out. I want to pass all the values dynamically in all the actions, so In action List rows present in a table how can I get Table name dynamically like which file is triggered it should get table name of that file dynamically, rest of I had configured values to set dynamically. Thanks

[@tylerkolota]

You’ll want to check the Get tables action kzbin.info/www/bejne/joKXiZ2FaK2ibdUsi=pYu_6oDzED-kWIyE

[@Rexntulsa-kx3no]

Building on Dustyn2429's question, the flow currently batches the notifications when it runs, sending the same group of change notifications to each person. Is it possible to have each row that is assigned to a specific person only go to that person (rather than all who were in the same batch of changes when the flow triggered)? This is a very useful tutorial but I'm stuck on this tweak. Thanks!

[@tylerkolota]

You’ll want to do a Select on the items coming out of the Filter array, switch the Select to a single box input using the right-side button, use an expression in that single input box of item()?[‘InsertEmailAddressColumnName’] so it will output an array of just the email addresses, then do an Apply to Each on the Union( ) of that Select so it loops once for each unique email address, then in the loop use a Filter array on all the items with changes where the email address column equals the Current Item of the loop so it gets all the changed items each given email address it loops over, then you can input the outputs of that Filter array into an HTML table action & Send email to show only the items changed for that given email address.

[@Rexntulsa-kx3no]

@@tylerkolota Thanks a bunch!

[@jeroenvankasteren9338]

Great video! Will this also work for a xlsm format?

[@tylerkolota]

Looks like you may have to add some more actions if the file/table don’t appear in the Excel List rows action: powerusers.microsoft.com/t5/General-Power-Automate/List-all-rows-from-a-MACRO-ENABLED-excel-file/td-p/764594

[@jeroenvankasteren9338]

@@tylerkolota thanks for the quick response, will try that

[@Pootski21]

If I was trying to change how the date was pulled from the excel file how and where would I put in that step? I know it can be changed to ISO 8601 but is there a step I can put in for a specific format without breaking the flow?

[@tylerkolota]

You could put a Select after the final Filter array actions & change the date format in that Select before passing the output body of the Select to the loop or to the HTML table.

[@dustynallen2429]

How would I pull out a specific column of the modified row? My table rows are assigned to specific people. Therefore, when this row is modified that person needs to be notified. The column contains the assigned persons email. Thanks!

[@tylerkolota]

In the apply to each you can set a Send email action to send To the item()?[‘InsertAssignedEmailColumnName’] to reference the assigned column email address (Don’t copy directly from above, the single quotes ‘ ‘ will be different) That should send an email for each item to the assigned email address.

[@dustynallen2429]

Thank you! @@tylerkolota

[@danielsepulveda2548]

This is helpful and valuable thank you! I am just starting this path and I am not a technical person my background is mostly in business. I am getting this error: Selected column name 'ID' not found in Excel table. clientRequestId: 3486357b-6173-4973-90b4-47e90dd4521d serviceRequestId: f483af1d-1f97-4f24-8403-2faae7c4641f;e9d5c58c-e4b0-41fc-9502-cb2d827bb46d;3269ab32-1e6e-4e8c-86be-e0c8d2da9571 I am supposing this is a table format error, Do you have a different video of how to set up this kind of tables or excel documents to work properly? Thanks a lot PD: Sorry if its a really basic/dumb question!

[@tylerkolota]

Do you have a column in Excel named “ID”? If not, what is your primary key column? A column or combination of columns that is unique for every row in your Excel table?

[@danielsepulveda2548]

@@tylerkolota Yes I added a column named ID. It is now succesfully running but it doesn't track any changes :(. Is there a way to pay you for a couple minutes session to help me fix it? Thanks a lot!

[@tylerkolota]

@@danielsepulveda2548 did you just add like a blank ID column? Does it actually act as a primary key column or no? www.techtarget.com/searchdatamanagement/definition/primary-key

[@tylerkolota]

@@danielsepulveda2548 You can email me at [e-mail] or post to the community thread to share screenshots powerusers.microsoft.com/t5/Power-Automate-Cookbook/When-an-Excel-row-is-created-modified-or-deleted/td-p/2264670

[@user-wx7th5gn7d]

Can you show us simply trigger a email notification when new Row added with ID Number>

[@tylerkolota]

Do you want a different email notification for each created row, or do you want a single email notification with an HTML table of all the newly created rows?

[@elijahd.spragueph.d8905]

I am getting an error indicating "The compressed file must contain the following files at its root:solution.xml,customizations.xml, and [content_types].xml. Customization files exported from previous versions of Microsoft dynamics 365 are not supported.

[@tylerkolota]

Did you download the solution package with the 1.0.0.x.zip at the end, or did you download one of the V1 import packages for the legacy Power Automate import method?

[@elijahd.spragueph.d8905]

@@tylerkolota I believe I used the V1 options.

[@elijahd.spragueph.d8905]

@@tylerkolota I attempted the 1.0.0.X.Zip file but it's not appearing in my flows-power automate

[@tylerkolota]

@@elijahd.spragueph.d8905 That's strange it should show up once you import the solution. Well you could go back to one of the V1 packages, go to make.powerautomate.com/flows & select Import > Import Package (Legacy) then upload that V1 file to go through the legacy flow import process.