Hi all,
My goal is to send a recurring email to mgmt with a table that pulls from a SharePoint list. I have it mostly set up and the email works and the table comes together... but certain list columns allow for the user to select multiple options from a dropdown list. Because there are multiple selections a user can choose, the table generates a row for each selection instead of combining them into one row.
Here's the flow (sensitive info blocked):
Then here's my append to array:
The "apply to each 3" for the Category input is automatically added by the flow, and I cannot remove it. I think this is causing the problem.
Here's the end:
Here's an example of what the email produces:
Here's what I'm hoping to get out of it:
I've tried a few trial and error tests, like doing an initialize variable/append to variable (string and array) for the category field and then adding that variable to the array table.. but those don't seem to work.
Also, if someone could help me translate the Created Date field into a Month/Day/Year format, that would be appreciated as well..
Thanks!
