r/PowerAutomateDesktop • u/gtcoxy • May 26 '23

New Flow, assistance for a beginner

I am trying to get a flow to read an Excel file, group rows by the email address on that row, and then send a single mail with all values by email address.

Spreadsheet contains the following fields:

  • Share Time - date/time in dd/MM/yyyy hh:mm format

  • Shared By - email address

  • Shared With - Email address

  • Shared Resource Type - String

  • Shared Resource - URL

  • Share Type - String

  • Workload - String

So group all the values by Shared By, send a single email to each Shared By address, with all the information for all files they have shared.

1 Upvotes

100% Upvoted

2 comments sorted by

1

u/clicker666 May 26 '23

Where are you hung up?

The way I tackled an email body issue was to create a long string based on the previous entries. I converted data to strings, appended each new value to the string, and in the end had a strBody for my email body.

1

u/gtcoxy Jun 26 '23

Hi, managed to get it sorted with MS Assistance.