Content placeholder in add to text slide PowerPoint activity

Help Activities
,
1

I am unsure what the content placeholder in the add text to slide activity is, and when I click the + button I do not get any options:

image
image1199×937 109 KB

2

I hope it’s inside powerpoint scope
@E.T.S

3

Yep:

image
image1247×1373 45 KB

4

Is the placeholder created in powerpoint is saved
Ideally it will list out
And also check whether the slide 6 has placeholder
@E.T.S

5

I am not sure what a placeholder is - this is what slide 6 looks like:

image
image1735×1047 17.1 KB

1 Like
6

Check this video for more insights

@E.T.S

7

Thanks for the video I understand what placeholders are now!

I have identified which placeholder I need to specify (Group 127 in the picture)

image
image2075×680 14.6 KB

Which I have specified in the activity:

image
image812×449 14.3 KB

But am getting this error:
image

Would this issue be tied to the fact that I get no options when I click the + button in content placeholder?:

image
image1199×937 109 KB

8

Hi @E.T.S ,

Have you used the File Path hardcoded or is it a variable that you are using as the file path ?
If its a variable you might not be able to get the list generated like below.

Could you Try hardcoding the Powerpoint file path and check :

image
image824×571 44.7 KB

1 Like
9

The options have come up! Are only text boxes place holders as the ‘Findings’ box is not present in the options - is there a work around for this?

After hard coding and selecting the options - can I change the hard code back to the variables?

10

@E.T.S ,
Yes. After a one time configuration, you could change it back to the variables. However, It should also work if you provide the Content placeholder values directly without needing to use hardcoded path.

What is the Findings Box? Is it not inside a Text Box ?

1 Like
12

I have changed the ‘Findings’ box to a text box

I am trying to insert into the text box a data row variable:

image
image808×440 11.4 KB

Which is giving me this:

image
image1788×360 4.82 KB

Is there a way of getting the actual value of the data row into the text box rather than the words data row

13

@E.T.S ,

Could you check with the below Expression :

String.Join(",",drCorrespondingRow.ItemArray.Cast(Of String))

However, If you wish to add the Whole Datatable, then when further exploring the package, we have the below activity as well :
image

1 Like
14

That works! However the text is not in quite the right format

Is there a way of editing the code given so that the data remains in a column format i.e. like a table rather than a block of text

15

@E.T.S ,

Let us know if you could perform/show us the Data Representation manually to us, so that we can adjust the code or suggest an alternate accordingly.

16

Ah I realised it wasn’t the code suggested that made the data as a block of text

I have a read range activity then this code:
dt = dtCorrespondingTab.AsEnumerable.Where(function(x) Regex.Replace(x(0).ToString,“(\r?\n)“,”“).ToLower.Contains(Regex.Replace(strKeyArea,”(\r?\n)”,“”).ToLower)).FirstOrDefault

The outcome of this is a block of text i.e. it is not a table

I believe it is this code that needs editing in order to preserve the data in a table format

17

@E.T.S ,

I believe the outcome of the Code provided is a DataRow or Nothing.

As mentioned earlier, do provide us with the representation that is needed in the PPT file.

In regards to the Expression to be corrected, as it provides a DataRow, meaning a Single row, Do you want that Single row to converted to a Datatable ? If so, we could do the below in the Add Table to Slide activity Table to Add Porperty :

{drCorrespondingRow}.CopyToDatatable
1 Like
19

Thank you that works!

20

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.