Create a Microsoft PowerPoint template

<a class="link" href="../../../product/it-business-management/reference/r_ITBusinessManagement.html" title="Align work with business goals to deliver products and services in a way that supports your strategic priorities. ServiceNow Strategic Portfolio Management (SPM), formerly IT Business Management, enables you to use digital transformation to drive more customer value faster. Plan, deliver, and track value across different methodologies.">Strategic Portfolio Management > Export to PowerPoint for Strategic Portfolio Management >

Configure the Export to PowerPoint add-in in your Microsoft PowerPoint to interact with your instance and fetch the data required to generate and download your status reports. Create your own custom template with the required data to generate a report, based on the reporting needs of your organization.

Let us connect your instance to the Microsoft PowerPoint using the add-in login and create a template Portfolio Planning to generate a report for epic details. Role required: sn_ppt_export.ppt_user

Open your Microsoft PowerPoint application and select the ServiceNow add-in icon ( ) on the Home tab. A side panel appears with a login option to access your ServiceNow instance. Select Log in . Enter your ServiceNow instance credentials and select Log in . A prompt with your instance details is displayed. Check your instance details and select Allow . The landing page of the add-in appears on the side panel.

Select Personal portfolio report from the Type list. Select the data type you want to populate. Text – to fetch details from the portfolio details. Example: Portfolio name, owner name, and so on. Table – to fetch the details from the related tables mapped to the parent table. Repeater – token to repeat defined slide formatting for the subsequent slides. Line and Bar chart – fetch the map details configured in the Scripted elements. Note: While creating one template, you can use the required data types to fetch the values.

To create a template, use one of the following data types to fetch the values from your instance. Note: While creating a template, you can: Change the font size and color for the token values to reflect the same in your status report. Move around the token to place them in a required format. Add your custom or organization logos on the slides. Resize the chart tokens as per the requirement.

Table 1. Options to create a template Option Description Steps for procedure Text entries from the Data list To fetch details from a text field: Select Text from the data type. Filter the Column list to locate Name and select it. A token value representing the portfolio name is generated in the subsequent empty text box. Select the Copy text button to copy the token. Paste the token on the slide. On a new Microsoft PowerPoint slide, insert a table with three columns and two rows to generate the epics details such as numbers, status, and due date.

Table entries mapped using related tables from the Data list To populate Epics details such as numbers, status, and due date: From the add-in landing page, select Table from the Data list. Use the Back ( ) button to go back to the add-in landing page.

Select Epic from the Related table list. From the Related table (optional) list, select a related table to the Epic. Select the number of rows that you want to populate and By default, five rows are selected. You can select a minimum of one row and a maximum of 10 rows.

Use the filter icon to see any existing filter or to define a condition to populate the data. Here, we’re picking Epics which are in either Ready or Work in progress state with a deadline on April 30.

Select Next . Select Number from the Column list. Copy the token value and paste it in the table. Similarly, copy and paste the token values of State and Assigned to fields from the Column list. Create a slide in Microsoft PowerPoint . To populate additional details for each of the selected records using Repeater from the Data list From the add-in landing page, select Table from the Data list. Use the Back ( ) button to go back to the add-in landing page.

Select Repeater from the Data list. Select Epic from the Related table list. Add required filter using the filter option and select Next . Select the required fields to copy and paste the token on the slide. Copy and paste the repeater token to the slide Note: You must create only one slide format and use the repeater token to reflect the details of all five epics. Repeater token doesn’t generate any values in the report.

Create a slide in Microsoft PowerPoint . Graph entries mapped using scripted elements from the Data list To populate a line or bar chart: From the add-in landing page, select Line Chart or Bar Chart from the Data list. From the Select a chart (defined using scripted elements) list, select a chart you want to populate for your report and select Next . Select the Copy to clipboard button to copy the chart token. Paste the token on a slide.

Save the Microsoft PowerPoint file in .pptx format with a file size not exceeding 15 MB. Note: The Export to PowerPoint for Strategic Portfolio Management application comes with default templates which you can use to generate reports and consider as a reference to create templates.

Parent Topic: Using Export to PowerPoint