Send an email with OneNote pages that have been recently modified

[DesmondDekker]

Hi

I'm looking for an experienced Power Automate user who would be able to help me with creating a more advanced version of this template:

So this template works fine, but there is one problem - it sends a modified page in this way:

I would like to create a flow which could detect if the same page was modified a few times and send an email only with one unique name of a page and one link to it - so the "Ideas - Test 4" wouldn't be repeated 4 times. Now, as I understand, the flow is taking into account all changes made in the page.

I'm also sending screenshots of the whole flow:

Really appreciate any help!

[robofski · Accepted solution]

In the Iterate current OneNote section you need to modify the compose action in the Yes branch of the condition to add a delimiter to the end of the string, in my case I used a ~ it needs to be something that won't appear in your page names.

Then before you send the email you want to add two compose actions, the first will split the list of pages into an Array based on the delimiter we used earlier and the second will take the output from that action and merge to leave only unique records:

For clarity, the expression used for the split was:

split(substring(variables('ListOfPages'),0,sub(length(variables('ListOfPages')),1)),'~')

and for the union:

union(outputs('Compose_2'),outputs('Compose_2'))

After this we need to clear out the ListofPages Variable by using a set variable action and just entering a space (it insists on entering something for the value

Finally we want to populate the ListofPages variable with the results from the Union so we can use an apply to each loop to loop through the output of the union and just append that as text to the variable.

Hopefully you can follow but if you need any clarity, please let me know. 

[DesmondDekker]

Everything is working! Thank you very much and have a nice weekend 😃

[lucasto]

Thank you for this!! I have a question, what if I want to send a notification to a team of associates (I know I can add the email addresses) but for only one folder in a OneNote book, not any others? What would I change in this? I would appreciate any help you can offer. 

[bcharette]

Hi,

Can you give me more info, Where to add this part of your solution :

"Then before you send the email you want to add two compose actions, the first will split the list of pages into an Array based on the delimiter we used earlier and the second will take the output from that action and merge to leave only unique records:"

Is it also in the Iterate current OneNote section. Same for this part : 

"After this we need to clear out the ListofPages Variable by using a set variable action and just entering a space (it insists on entering something for the value"

and the last one : 

"Finally we want to populate the ListofPages variable with the results from the Union so we can use an apply to each loop to loop through the output of the union and just append that as text to the variable."

Also, you have a "Compose 5" in your answer, but what is the compose 4 ?

Thanks a lot

[ga1nz]

Hi @robofski, I am trying to fix a similar issue in a notebook with multiple sections. I tried your fix above, but I get:


The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@outputs('Compose_3')' is of type 'String'. The result must be a valid array.

Any tips on how to fix this?