I have created a meeting request form in sharepoint, and I am trying to set up a flow that will send the meeting organizer an email with the meeting information in the body. Several of the columns are choice, and I have been having trouble showing the selected choices. I initially tried to set it up using get items, select, and create HTML table with output in the body of the email. I have attached screenshot for reference.
The problem is that when I set it up this way, the body of the email looks really weird. Another screenshot for reference.
So I am thinking of another way, which is to do it with intializing string variables and appending. Another screenshot as an example, but this was for another flow that creates a calendar invite. I would use the same approach for the email generating flow.
This way would require me to set up a string variable for each column, which I don't mind doing, but I am just wondering if there is a better way to tackle this.
I am also going to set up a flow where if a user modifies their meeting request, it will generate a notification to our team with the revised meeting details. I am a relative newbie to all this, so any help would be greatly appreciated. Thank you!
Thank you for posting.
According to your requirement, you would like to send meeting information as html table to channel but currently stuck due to weird output. If I misunderstood, please kindly let me know.
While going through your flow, it looks like no issue. I’m afraid the issue may be caused by data format in SPO list. Here is mine for your reference:
First, this is my SPO list:
Here is my flow similar to yours:
After running the flow, I’m able to get correct html table as you required.
For your secondary query, when somebody modify or create new record in this list, the html table will be sent to channel automatically. That’s simple as we just need to change trigger to ‘when an item is created or modified’ and configure flow like the previous one.
Hope the content above may help you.
Thank you so much for your reply, and apologies for the delay in responding; I had some bigger 'fires' to put out first. I have done what you suggested, but when I run the flow and send output to post message in channel, it fails with bad request. When I send it to create an email, I am still getting the weird output, but I am wondering if that is because it gets nested into an "apply to each," which happens when I try to add in the meeting organizer's email address in to 'to' field. I am not sure how to separate it out so that does not happen.
Thank you for reply.
I double checked your flow, the weird output has nothing to do with ‘apply to each’ action. Please pay attention to the ‘select’ action. The correct selection should be like as below:
If you didn’t select according property, you would get that irregular output.
Hope it helps.
Thank you for your reply.
Could you please follow my flow steps and reconfigure your flow? Mine works fine now and I didn't realize you have so many nested loops before. Sorry for that. ಠ_ಠ
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.