Power Platform Community Forum Thread Details

Hi all,

does anyone know if it is possible to add a unique counter/reference number on to the email form that is exported from MeetingCapture?

Thanks in advance

Categories:

Building Power Apps

Hi @tabs99 :

Do you want to create a unique and incremental number for each exported meeting record?Like this:

It’s possible, but it’s a little troublesome.Because the format of the email has been preset using the hypertext language, I do not recommend you to adjust the email format, which will be very troublesome. My plan is to add a number directly after the subject of the meeting.I'v made a test for your reference:

1\Create a SharePoint List-unique counter(Used to store unique numbers)

'Title'-Text

'UN Counter'-Number

2\Add a new Record into this record(Like this)

3\Add unique counter as the data source

4\Set the ConfirmScreen's OnVisible property to(I have marked the changes in red😞

If(ExportConfirmed,
Set(Loading, true);

    /*Collects the dynamic data which will be substituted into the Email/OneNote templates and associates it to the {placeholder} values in the templates
       At {Field: "{1}" at <tr><td colspan='3'> changed <td colspan='3' style='height:10px;'> to <td colspan='3'> because OneNote stopped displaying the export content with the inline style content present
    */
        If(CheckEmail.Value || CheckOneNote.Value,
             ClearCollect(TemplateData, {Field:"{MeetingName}", Data:SelectedMeeting.Subject & " No."& Patch('unique counter',First('unique counter'),{UNCounter:First('unique counter').UNCounter+1}).UNCounter}, {Field: "{MeetingStartDate}", Data: Text(SelectedMeeting.Start, "[$-en-US]mmm. dd, yyyy")},
            {Field: "{MeetingStartTime}", Data: Lower(Text(SelectedMeeting.Start, "[$-en-US]hh:mm am/pm"))}, {Field: "{MeetingEndTime}", Data: Lower(Text(SelectedMeeting.End, "[$-en-US]hh:mm am/pm"))},……

Best Regards,

Bof