How to add Saved Value to file name

Help StudioX
,
1

I saved the date as a Saved Value and want to add it to my file name. How would I write the in the Expression Editor?

2

The date saved is not today. It is a date other than today.

3

@jessica.matthess - if you are trying to do this in StudioX …there is a easy to do it…

Could you please share the screenshot of the filename step ?

4

image

5

Ignore that I spelled “summary” wrong

6

@jessica.matthess - If you are planning to add today’s date to the file…then you can follow the below process…

image
image1148×821 61.3 KB

image
image705×373 13.3 KB

7

The date I am adding is not today’s date. The date is from a pivot table that I saved as a Saved Value.

8

image

9

@jessica.matthess - okay…in that case, you are already doing it right…what is the error you are getting??? Please print the pivot date in the write Line before save as activity , just to make sure you are getting the right value…

image

10

Here is the error I am getting.
image

11

@jessica.matthess - thats why I suggested to print the pivot date in the write line activity first .

If your date as / symbol which is not allowed in the file name or path.

image

12

I guess I don’t understand what you mean by “in the write line activity.” please explain.

13

would this expression work?
image

14

@jessica.matthess - Since it is saved as excel value…you have to use .tostring before the replace

image
image695×179 4.3 KB

is it possible to share the xaml file ? so that I can take a look and fix it for you.

15

Added ToString before Replace. Error message says End of Expression expected. I do have double quotes at the end.
image

16

image

17

:point_up_2:

18

I was able to figure it out. I needed to remove the “.xlsx”. I just needed the Summary Report and saved value. Thank you!

19

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