When an Excel row is created, modified, or deleted
HTML-код
- Опубликовано: 31 окт 2023
- 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. - Хобби
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?
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.
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
You’ll want to check the Get tables action
ruclips.net/video/XQ4XjO3Ho7s/видео.htmlsi=pYu_6oDzED-kWIyE
Great video! Will this also work for a xlsm format?
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
@@tylerkolota thanks for the quick response, will try that
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!
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.
@@tylerkolota Thanks a bunch!
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!
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.
Thank you!
@@tylerkolota
Can you show us simply trigger a email notification when new Row added with ID Number>
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?