SkySoft Insights

Sales Follow-Up & Nurturing AI Agent

Cursus in id ut congue commodo. Arcu nullam nibh elit elementum dictumst ultricies turpis cras. Mattis elementum.

[fusion_builder_container admin_label=”Post Content” type=”flex” hundred_percent=”no” hundred_percent_height=”no” hundred_percent_height_scroll=”no” align_content=”stretch” flex_align_items=”flex-start” flex_justify_content=”flex-start” flex_wrap=”wrap” hundred_percent_height_center_content=”yes” equal_height_columns=”no” container_tag=”div” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” status=”published” link_color=”var(–awb-color2)” border_style=”solid” box_shadow=”no” box_shadow_blur=”0″ box_shadow_spread=”0″ gradient_start_position=”0″ gradient_end_position=”100″ gradient_type=”linear” radial_direction=”center center” linear_angle=”180″ background_position=”center center” background_repeat=”no-repeat” fade=”no” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_blend_mode=”none” background_slider_skip_lazy_loading=”no” background_slider_loop=”yes” background_slider_pause_on_hover=”no” background_slider_slideshow_speed=”5000″ background_slider_animation=”fade” background_slider_direction=”up” background_slider_animation_speed=”800″ video_aspect_ratio=”16:9″ video_loop=”yes” video_mute=”yes” pattern_bg=”none” pattern_bg_style=”default” pattern_bg_opacity=”100″ pattern_bg_blend_mode=”normal” mask_bg=”none” mask_bg_style=”default” mask_bg_opacity=”100″ mask_bg_transform=”left” mask_bg_blend_mode=”normal” absolute=”off” absolute_devices=”small,medium,large” sticky=”off” sticky_devices=”small-visibility,medium-visibility,large-visibility” sticky_transition_offset=”0″ scroll_offset=”0″ animation_direction=”left” animation_speed=”0.3″ animation_delay=”0″ filter_hue=”0″ filter_saturation=”100″ filter_brightness=”100″ filter_contrast=”100″ filter_invert=”0″ filter_sepia=”0″ filter_opacity=”100″ filter_blur=”0″ filter_hue_hover=”0″ filter_saturation_hover=”100″ filter_brightness_hover=”100″ filter_contrast_hover=”100″ filter_invert_hover=”0″ filter_sepia_hover=”0″ filter_opacity_hover=”100″ filter_blur_hover=”0″][fusion_builder_row][fusion_builder_column type=”2_3″ type=”2_3″ layout=”1_1″ align_self=”auto” content_layout=”column” align_content=”flex-start” valign_content=”flex-start” content_wrap=”wrap” center_content=”no” column_tag=”div” target=”_self” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” order_medium=”0″ order_small=”0″ hover_type=”none” border_style=”solid” box_shadow=”no” box_shadow_blur=”0″ box_shadow_spread=”0″ background_type=”single” gradient_start_position=”0″ gradient_end_position=”100″ gradient_type=”linear” radial_direction=”center center” linear_angle=”180″ lazy_load=”none” background_position=”left top” background_repeat=”no-repeat” background_blend_mode=”none” sticky=”off” sticky_devices=”small-visibility,medium-visibility,large-visibility” absolute=”off” filter_type=”regular” filter_hover_element=”self” filter_hue=”0″ filter_saturation=”100″ filter_brightness=”100″ filter_contrast=”100″ filter_invert=”0″ filter_sepia=”0″ filter_opacity=”100″ filter_blur=”0″ filter_hue_hover=”0″ filter_saturation_hover=”100″ filter_brightness_hover=”100″ filter_contrast_hover=”100″ filter_invert_hover=”0″ filter_sepia_hover=”0″ filter_opacity_hover=”100″ filter_blur_hover=”0″ transform_type=”regular” transform_hover_element=”self” transform_scale_x=”1″ transform_scale_y=”1″ transform_translate_x=”0″ transform_translate_y=”0″ transform_rotate=”0″ transform_skew_x=”0″ transform_skew_y=”0″ transform_scale_x_hover=”1″ transform_scale_y_hover=”1″ transform_translate_x_hover=”0″ transform_translate_y_hover=”0″ transform_rotate_hover=”0″ transform_skew_x_hover=”0″ transform_skew_y_hover=”0″ transition_duration=”300″ transition_easing=”ease” scroll_motion_devices=”small-visibility,medium-visibility,large-visibility” animation_direction=”left” animation_speed=”0.3″ animation_delay=”0″ spacing_left=”0″ spacing_right=”0″ last=”false” border_position=”all” element_content=”” border_color=”hsla(var(–awb-color2-h),var(–awb-color2-s),calc(var(–awb-color2-l) – 2%),var(–awb-color2-a))” first=”true” min_height=”” link=””][fusion_text hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” animation_direction=”left” animation_speed=”0.3″ animation_delay=”0″]

Overview

This guide walks through the implementation of an AI-powered Follow-Up & Nurturing Agent for Microsoft Dynamics 365. The solution uses Power Automate as the automation engine, Dataverse for data logging, and Outlook for email drafting with mandatory human approval at every step.

Solution Components:

Microsoft Dynamics 365 : CRM data source (Leads, Opportunities, Activities)
Microsoft Power Automate : Scheduled flow, conditions, and approvals
Microsoft Dataverse : Custom KPI log table (FollowUpAILog)
Microsoft Outlook : Email draft creation and sending after approval
Microsoft Teams : Approval notifications and manager escalation alerts

Status: Implemented & Tested Successfully

[/fusion_text][/fusion_builder_column][fusion_builder_column type=”1_3″ type=”1_3″ layout=”1_3″ align_self=”auto” content_layout=”column” align_content=”flex-start” valign_content=”flex-start” content_wrap=”wrap” center_content=”no” column_tag=”div” target=”_self” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” order_medium=”0″ order_small=”0″ hover_type=”none” border_style=”solid” box_shadow=”no” box_shadow_blur=”0″ box_shadow_spread=”0″ background_type=”single” background_color=”var(–awb-color5)” gradient_start_position=”0″ gradient_end_position=”100″ gradient_type=”linear” radial_direction=”center center” linear_angle=”180″ lazy_load=”none” background_position=”left top” background_repeat=”no-repeat” background_blend_mode=”none” background_slider_skip_lazy_loading=”no” background_slider_loop=”yes” background_slider_pause_on_hover=”no” background_slider_slideshow_speed=”5000″ background_slider_animation=”fade” background_slider_direction=”up” background_slider_animation_speed=”800″ sticky=”off” sticky_devices=”small-visibility,medium-visibility,large-visibility” absolute=”off” filter_type=”regular” filter_hover_element=”self” filter_hue_hover=”0″ filter_saturation_hover=”100″ filter_brightness_hover=”100″ filter_contrast_hover=”100″ filter_invert_hover=”0″ filter_sepia_hover=”0″ filter_opacity_hover=”100″ filter_blur_hover=”0″ filter_hue=”0″ filter_saturation=”100″ filter_brightness=”100″ filter_contrast=”100″ filter_invert=”0″ filter_sepia=”0″ filter_opacity=”100″ filter_blur=”0″ transform_type=”regular” transform_hover_element=”self” transform_scale_x_hover=”1″ transform_scale_y_hover=”1″ transform_translate_x_hover=”0″ transform_translate_y_hover=”0″ transform_rotate_hover=”0″ transform_skew_x_hover=”0″ transform_skew_y_hover=”0″ transform_scale_x=”1″ transform_scale_y=”1″ transform_translate_x=”0″ transform_translate_y=”0″ transform_rotate=”0″ transform_skew_x=”0″ transform_skew_y=”0″ transition_duration=”300″ transition_easing=”ease” motion_effects=”W10=” scroll_motion_devices=”small-visibility,medium-visibility,large-visibility” animation_direction=”left” animation_speed=”0.3″ animation_delay=”0″ last=”true” border_position=”all” element_content=”” padding_top=”20px” padding_right=”20px” padding_bottom=”20px” padding_left=”20px” first=”false” border_radius_top_left=”5px” border_radius_top_right=”5px” border_radius_bottom_left=”5px” border_radius_bottom_right=”5px” min_height=”” link=””][fusion_title title_type=”text” scroll_reveal_effect=”color_change” scroll_reveal_basis=”chars” scroll_reveal_behavior=”always” scroll_reveal_duration=”500″ scroll_reveal_stagger=”200″ scroll_reveal_delay=”0″ scroll_reveal_above_fold=”yes” marquee_direction=”left” marquee_mask_edges=”no” marquee_speed=”15000″ rotation_effect=”bounceIn” display_time=”1200″ highlight_effect=”circle” loop_animation=”once” highlight_animation_duration=”1500″ highlight_width=”9″ highlight_smudge_effect=”no” highlight_top_margin=”0″ title_link=”off” link_target=”_self” content_align=”left” size=”4″ text_shadow=”no” text_shadow_blur=”0″ text_stroke=”no” text_stroke_size=”1″ text_overflow=”none” gradient_font=”no” gradient_start_position=”0″ gradient_end_position=”100″ gradient_type=”linear” radial_direction=”center center” linear_angle=”180″ style_type=”default” animation_direction=”left” animation_speed=”0.3″ animation_delay=”0″ hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” text_color=”var(–awb-color1)”]Project[/fusion_title][fusion_text columns=”1″ hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” fusion_font_family_text_font=”var(–awb-typography4-font-family)” fusion_font_variant_text_font=”var(–awb-typography4)” font_size=”var(–awb-typography4-font-size)” line_height=”var(–awb-typography4-line-height)” letter_spacing=”var(–awb-typography4-letter-spacing)” text_transform=”var(–awb-typography4-text-transform)” text_color=”var(–awb-color1)” animation_direction=”left” animation_speed=”0.3″ animation_delay=”0″]

Sales Follow-Up & Nurturing AI Agent

Implementation Guide

Microsoft Dynamics 365 | Power Automate | Dataverse

[/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container admin_label=”Post Content” type=”flex” hundred_percent=”no” hundred_percent_height=”no” hundred_percent_height_scroll=”no” align_content=”stretch” flex_align_items=”flex-start” flex_justify_content=”flex-start” flex_wrap=”wrap” hundred_percent_height_center_content=”yes” equal_height_columns=”no” container_tag=”div” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” status=”published” link_color=”var(–awb-color2)” border_style=”solid” box_shadow=”no” box_shadow_blur=”0″ box_shadow_spread=”0″ gradient_start_position=”0″ gradient_end_position=”100″ gradient_type=”linear” radial_direction=”center center” linear_angle=”180″ background_position=”center center” background_repeat=”no-repeat” fade=”no” background_parallax=”none” enable_mobile=”no” parallax_speed=”0.3″ background_blend_mode=”none” background_slider_skip_lazy_loading=”no” background_slider_loop=”yes” background_slider_pause_on_hover=”no” background_slider_slideshow_speed=”5000″ background_slider_animation=”fade” background_slider_direction=”up” background_slider_animation_speed=”800″ video_aspect_ratio=”16:9″ video_loop=”yes” video_mute=”yes” pattern_bg=”none” pattern_bg_style=”default” pattern_bg_opacity=”100″ pattern_bg_blend_mode=”normal” mask_bg=”none” mask_bg_style=”default” mask_bg_opacity=”100″ mask_bg_transform=”left” mask_bg_blend_mode=”normal” absolute=”off” absolute_devices=”small,medium,large” sticky=”off” sticky_devices=”small-visibility,medium-visibility,large-visibility” sticky_transition_offset=”0″ scroll_offset=”0″ animation_direction=”left” animation_speed=”0.3″ animation_delay=”0″ filter_hue=”0″ filter_saturation=”100″ filter_brightness=”100″ filter_contrast=”100″ filter_invert=”0″ filter_sepia=”0″ filter_opacity=”100″ filter_blur=”0″ filter_hue_hover=”0″ filter_saturation_hover=”100″ filter_brightness_hover=”100″ filter_contrast_hover=”100″ filter_invert_hover=”0″ filter_sepia_hover=”0″ filter_opacity_hover=”100″ filter_blur_hover=”0″][fusion_builder_row][fusion_builder_column type=”1_1″ type=”1_1″ layout=”1_1″ align_self=”auto” content_layout=”column” align_content=”flex-start” valign_content=”flex-start” content_wrap=”wrap” center_content=”no” column_tag=”div” target=”_self” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” order_medium=”0″ order_small=”0″ hover_type=”none” border_style=”solid” box_shadow=”no” box_shadow_blur=”0″ box_shadow_spread=”0″ background_type=”single” gradient_start_position=”0″ gradient_end_position=”100″ gradient_type=”linear” radial_direction=”center center” linear_angle=”180″ lazy_load=”none” background_position=”left top” background_repeat=”no-repeat” background_blend_mode=”none” sticky=”off” sticky_devices=”small-visibility,medium-visibility,large-visibility” absolute=”off” filter_type=”regular” filter_hover_element=”self” filter_hue=”0″ filter_saturation=”100″ filter_brightness=”100″ filter_contrast=”100″ filter_invert=”0″ filter_sepia=”0″ filter_opacity=”100″ filter_blur=”0″ filter_hue_hover=”0″ filter_saturation_hover=”100″ filter_brightness_hover=”100″ filter_contrast_hover=”100″ filter_invert_hover=”0″ filter_sepia_hover=”0″ filter_opacity_hover=”100″ filter_blur_hover=”0″ transform_type=”regular” transform_hover_element=”self” transform_scale_x=”1″ transform_scale_y=”1″ transform_translate_x=”0″ transform_translate_y=”0″ transform_rotate=”0″ transform_skew_x=”0″ transform_skew_y=”0″ transform_scale_x_hover=”1″ transform_scale_y_hover=”1″ transform_translate_x_hover=”0″ transform_translate_y_hover=”0″ transform_rotate_hover=”0″ transform_skew_x_hover=”0″ transform_skew_y_hover=”0″ transition_duration=”300″ transition_easing=”ease” scroll_motion_devices=”small-visibility,medium-visibility,large-visibility” animation_direction=”left” animation_speed=”0.3″ animation_delay=”0″ spacing_left=”0″ spacing_right=”0″ last=”true” border_position=”all” element_content=”” border_color=”hsla(var(–awb-color2-h),var(–awb-color2-s),calc(var(–awb-color2-l) – 2%),var(–awb-color2-a))” first=”true” min_height=”” link=””][fusion_text hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” animation_direction=”left” animation_speed=”0.3″ animation_delay=”0″]

Step 1 : Create KPI Log Table in Dataverse

Create a custom Dataverse table called FollowUpAILog to track every AI-triggered follow-up event. This enables KPI reporting and audit visibility.

Table setup:

Navigate to Power Apps → Tables → New Table
Table Name: FollowUpAILog | Primary Column: Log Name (Text)

Add the following custom columns:

Opportunity : Lookup to Opportunity table
Risk Level : Choice: Low / Medium / High
Days Inactive : Whole Number
Email Generated : Yes/No
Escalated : Yes/No
Follow-Up Sent Date Only
AI Review Date : Date & Time

[/fusion_text][fusion_imageframe custom_aspect_ratio="100" lightbox="no" linktarget="_self" align_medium="none" align_small="none" align="none" hover_type="none" magnify_duration="120" scroll_height="100" scroll_speed="1" caption_style="off" caption_align_medium="none" caption_align_small="none" caption_align="none" caption_title_tag="2" animation_direction="left" animation_speed="0.3" animation_delay="0" hide_on_mobile="small-visibility,medium-visibility,large-visibility" sticky_display="normal,sticky" filter_hue="0" filter_saturation="100" filter_brightness="100" filter_contrast="100" filter_invert="0" filter_sepia="0" filter_opacity="100" filter_blur="0" filter_hue_hover="0" filter_saturation_hover="100" filter_brightness_hover="100" filter_contrast_hover="100" filter_invert_hover="0" filter_sepia_hover="0" filter_opacity_hover="100" filter_blur_hover="0" image_id="6398|full"]https://www.skysoftconnections.com/wp-content/uploads/2026/04/Create-KPI-Log-Table-in-Dataverse.png[/fusion_imageframe][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container admin_label="Post Content" type="flex" hundred_percent="no" hundred_percent_height="no" hundred_percent_height_scroll="no" align_content="stretch" flex_align_items="flex-start" flex_justify_content="flex-start" flex_wrap="wrap" hundred_percent_height_center_content="yes" equal_height_columns="no" container_tag="div" hide_on_mobile="small-visibility,medium-visibility,large-visibility" status="published" padding_top="50px" padding_bottom="50px" link_color="var(–awb-color2)" border_style="solid" box_shadow="no" box_shadow_blur="0" box_shadow_spread="0" gradient_start_position="0" gradient_end_position="100" gradient_type="linear" radial_direction="center center" linear_angle="180" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" enable_mobile="no" parallax_speed="0.3" background_blend_mode="none" background_slider_skip_lazy_loading="no" background_slider_loop="yes" background_slider_pause_on_hover="no" background_slider_slideshow_speed="5000" background_slider_animation="fade" background_slider_direction="up" background_slider_animation_speed="800" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" pattern_bg="none" pattern_bg_style="default" pattern_bg_opacity="100" pattern_bg_blend_mode="normal" mask_bg="none" mask_bg_style="default" mask_bg_opacity="100" mask_bg_transform="left" mask_bg_blend_mode="normal" absolute="off" absolute_devices="small,medium,large" sticky="off" sticky_devices="small-visibility,medium-visibility,large-visibility" sticky_transition_offset="0" scroll_offset="0" animation_direction="left" animation_speed="0.3" animation_delay="0" filter_hue="0" filter_saturation="100" filter_brightness="100" filter_contrast="100" filter_invert="0" filter_sepia="0" filter_opacity="100" filter_blur="0" filter_hue_hover="0" filter_saturation_hover="100" filter_brightness_hover="100" filter_contrast_hover="100" filter_invert_hover="0" filter_sepia_hover="0" filter_opacity_hover="100" filter_blur_hover="0" background_color="var(–awb-color2)"][fusion_builder_row][fusion_builder_column type="1_1" type="1_1" layout="1_1" align_self="auto" content_layout="column" align_content="flex-start" valign_content="flex-start" content_wrap="wrap" center_content="no" column_tag="div" target="_self" hide_on_mobile="small-visibility,medium-visibility,large-visibility" sticky_display="normal,sticky" order_medium="0" order_small="0" hover_type="none" border_style="solid" box_shadow="no" box_shadow_blur="0" box_shadow_spread="0" background_type="single" gradient_start_position="0" gradient_end_position="100" gradient_type="linear" radial_direction="center center" linear_angle="180" lazy_load="none" background_position="left top" background_repeat="no-repeat" background_blend_mode="none" sticky="off" sticky_devices="small-visibility,medium-visibility,large-visibility" absolute="off" filter_type="regular" filter_hover_element="self" filter_hue="0" filter_saturation="100" filter_brightness="100" filter_contrast="100" filter_invert="0" filter_sepia="0" filter_opacity="100" filter_blur="0" filter_hue_hover="0" filter_saturation_hover="100" filter_brightness_hover="100" filter_contrast_hover="100" filter_invert_hover="0" filter_sepia_hover="0" filter_opacity_hover="100" filter_blur_hover="0" transform_type="regular" transform_hover_element="self" transform_scale_x="1" transform_scale_y="1" transform_translate_x="0" transform_translate_y="0" transform_rotate="0" transform_skew_x="0" transform_skew_y="0" transform_scale_x_hover="1" transform_scale_y_hover="1" transform_translate_x_hover="0" transform_translate_y_hover="0" transform_rotate_hover="0" transform_skew_x_hover="0" transform_skew_y_hover="0" transition_duration="300" transition_easing="ease" scroll_motion_devices="small-visibility,medium-visibility,large-visibility" animation_direction="left" animation_speed="0.3" animation_delay="0" spacing_left="0" spacing_right="0" last="true" border_position="all" element_content="" border_color="hsla(var(–awb-color2-h),var(–awb-color2-s),calc(var(–awb-color2-l) – 2%),var(–awb-color2-a))" first="true" min_height="" link=""][fusion_text animation_direction="left" animation_speed="0.3" animation_delay="0" disable_idd="no" hide_on_mobile="small-visibility,medium-visibility,large-visibility" sticky_display="normal,sticky"]

Step 2 : Build the Scheduled Cloud Flow

Create a Scheduled Cloud Flow in Power Automate that runs daily to monitor all active opportunities.

Go to Power Automate → Create → Scheduled Cloud Flow
Flow Name: AI Sales Follow-Up & Nurturing Monitoring
Trigger: Recurrence Every 1 Day, starting at 8:00 AM
Inside the flow, add an Initialize Variable action: Name = RiskLevel, Type = String, Value = Low

[/fusion_text][fusion_imageframe custom_aspect_ratio="100" lightbox="no" linktarget="_self" align_medium="none" align_small="none" align="none" hover_type="none" magnify_duration="120" scroll_height="100" scroll_speed="1" caption_style="off" caption_align_medium="none" caption_align_small="none" caption_align="none" caption_title_tag="2" animation_direction="left" animation_speed="0.3" animation_delay="0" hide_on_mobile="small-visibility,medium-visibility,large-visibility" sticky_display="normal,sticky" filter_hue="0" filter_saturation="100" filter_brightness="100" filter_contrast="100" filter_invert="0" filter_sepia="0" filter_opacity="100" filter_blur="0" filter_hue_hover="0" filter_saturation_hover="100" filter_brightness_hover="100" filter_contrast_hover="100" filter_invert_hover="0" filter_sepia_hover="0" filter_opacity_hover="100" filter_blur_hover="0" image_id="6399|full"]https://www.skysoftconnections.com/wp-content/uploads/2026/04/Build-the-Scheduled-Cloud-Flow.png[/fusion_imageframe][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container][fusion_builder_container type="flex" hundred_percent="no" hundred_percent_height="no" hundred_percent_height_scroll="no" align_content="stretch" flex_align_items="flex-start" flex_justify_content="flex-start" flex_wrap="wrap" hundred_percent_height_center_content="yes" equal_height_columns="no" container_tag="div" hide_on_mobile="small-visibility,medium-visibility,large-visibility" status="published" border_style="solid" box_shadow="no" box_shadow_blur="0" box_shadow_spread="0" gradient_start_position="0" gradient_end_position="100" gradient_type="linear" radial_direction="center center" linear_angle="180" background_position="center center" background_repeat="no-repeat" fade="no" background_parallax="none" enable_mobile="no" parallax_speed="0.3" background_blend_mode="none" background_slider_skip_lazy_loading="no" background_slider_loop="yes" background_slider_pause_on_hover="no" background_slider_slideshow_speed="5000" background_slider_animation="fade" background_slider_direction="up" background_slider_animation_speed="800" video_aspect_ratio="16:9" video_loop="yes" video_mute="yes" pattern_bg="none" pattern_bg_style="default" pattern_bg_opacity="100" pattern_bg_blend_mode="normal" mask_bg="none" mask_bg_style="default" mask_bg_opacity="100" mask_bg_transform="left" mask_bg_blend_mode="normal" absolute="off" absolute_devices="small,medium,large" sticky="off" sticky_devices="small-visibility,medium-visibility,large-visibility" sticky_transition_offset="0" scroll_offset="0" animation_direction="left" animation_speed="0.3" animation_delay="0" filter_hue="0" filter_saturation="100" filter_brightness="100" filter_contrast="100" filter_invert="0" filter_sepia="0" filter_opacity="100" filter_blur="0" filter_hue_hover="0" filter_saturation_hover="100" filter_brightness_hover="100" filter_contrast_hover="100" filter_invert_hover="0" filter_sepia_hover="0" filter_opacity_hover="100" filter_blur_hover="0" padding_top="50px"][fusion_builder_row][fusion_builder_column type="1_1" type="1_1" layout="1_1" align_self="auto" content_layout="column" align_content="flex-start" valign_content="flex-start" content_wrap="wrap" center_content="no" column_tag="div" target="_self" hide_on_mobile="small-visibility,medium-visibility,large-visibility" sticky_display="normal,sticky" order_medium="0" order_small="0" hover_type="none" border_style="solid" box_shadow="no" box_shadow_blur="0" box_shadow_spread="0" background_type="single" gradient_start_position="0" gradient_end_position="100" gradient_type="linear" radial_direction="center center" linear_angle="180" lazy_load="none" background_position="left top" background_repeat="no-repeat" background_blend_mode="none" sticky="off" sticky_devices="small-visibility,medium-visibility,large-visibility" absolute="off" filter_type="regular" filter_hover_element="self" filter_hue="0" filter_saturation="100" filter_brightness="100" filter_contrast="100" filter_invert="0" filter_sepia="0" filter_opacity="100" filter_blur="0" filter_hue_hover="0" filter_saturation_hover="100" filter_brightness_hover="100" filter_contrast_hover="100" filter_invert_hover="0" filter_sepia_hover="0" filter_opacity_hover="100" filter_blur_hover="0" transform_type="regular" transform_hover_element="self" transform_scale_x="1" transform_scale_y="1" transform_translate_x="0" transform_translate_y="0" transform_rotate="0" transform_skew_x="0" transform_skew_y="0" transform_scale_x_hover="1" transform_scale_y_hover="1" transform_translate_x_hover="0" transform_translate_y_hover="0" transform_rotate_hover="0" transform_skew_x_hover="0" transform_skew_y_hover="0" transition_duration="300" transition_easing="ease" scroll_motion_devices="small-visibility,medium-visibility,large-visibility" animation_direction="left" animation_speed="0.3" animation_delay="0" spacing_left="0" spacing_right="0" last="true" border_position="all" element_content="" border_color="hsla(var(–awb-color2-h),var(–awb-color2-s),calc(var(–awb-color2-l) – 2%),var(–awb-color2-a))" first="true" min_height="" link=""][fusion_text hide_on_mobile="small-visibility,medium-visibility,large-visibility" sticky_display="normal,sticky" animation_direction="left" animation_speed="0.3" animation_delay="0"]

Step 3 : Retrieve Active Opportunities

Add a Dataverse List Rows action to query open opportunities that need follow-up.

Action: Dataverse → List Rows → Table: Opportunities
Add this OData filter: statecode eq 0 and closeprobability ge 50 and estimatedclosedate le addDays(utcNow(),10)
This returns active deals with ≥50% probability closing within 10 days
Add an Apply to Each loop using the Value array from the List Rows output

Step 4 : Calculate Inactivity & Classify Risk

Inside the loop, add a Compose action to calculate days since the opportunity was last modified:

div(sub(ticks(utcNow()),ticks(items(‘Apply_to_each’)?[‘modifiedon’])),864000000000)

Then add nested Condition blocks to assign risk level:

High Risk: Days Inactive > 10 AND Revenue > 50,000 → Escalation + Approval + Email
Medium Risk: Days Inactive 7–10 OR Close Date within 5 days → Approval + Email Draft
Low Risk: Days Inactive 5–7 → No email, no escalation

Step 5 : Generate Email Draft & Require Approval

For Medium and High risk deals, create an Outlook email draft (not sent automatically), then route it for mandatory seller approval before any email reaches the customer.

Email Draft Setup:

Action: Outlook → Create Draft
To: Opportunity Owner email (dynamic)
Subject: Follow-Up Required: [Opportunity Name]
Body: Use dynamic content owner name, stage, revenue, days inactive, close date

Approval Step:

Action: Start and Wait for Approval (Approve/Reject First to respond)
Assigned To: Opportunity Owner email (dynamic)
If Approved → Send Email action triggered
If Rejected → Update record status to ‘Pending Manual Review’

Step 6 : Log KPI Entry & Test the Flow

After all email and escalation logic, add a Dataverse Add Row action to log every AI intervention to FollowUpAILog. This creates a permanent audit trail for KPI reporting.

Fields to map:

Log Name: AI Review [Opportunity Name]
Opportunity: GUID from the loop
Risk Level: RiskLevel variable
Days Inactive: Output from Days Inactive Compose step
Email Generated: Yes (in Medium/High branches)
Escalated: Yes if High Risk, otherwise No
AI Review Date: utcNow()

Testing:

Go to Power Automate → select the flow → click Test → Manually → Run Flow
Monitor the run history to confirm all steps show green checkmarks
Verify a new row appears in the FollowUpAILog table in Dataverse
Confirm approval notification was received and email draft was created in Outlook

Implementation Complete — All steps tested and validated successfully.

[/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container]