Answered

Rename a Google E-mail Attachment and Save it to Google Drive

(1) Share

Report

Posted on by 2C4C3C9127

I have a flow that is checking an e-mail and saving the attachment (always a PDF) to Google Drive. I would like to rename that file on the save, but having trouble renaming the file based if another Compose (DocumentType) has a certain Word, etc. This is what I have come up with, but I have something missing because it's not renaming the file but it does add the other Compose and Date/Time Stamp.

Here is the expression:

concat(
if(equals(item()?['{DocumentTypeVar}'], 'Configuration Pages'), 'CONF',
if(equals(item()?['{DocumentTypeVar}'], 'Delivery and Acceptance'), 'DA',
if(equals(item()?['{DocumentTypeVar}'], 'Receivables'), 'REC',
if(equals(item()?['{DocumentTypeVar}'], 'Picking and Packing Lists'), 'PICPAK', replace(item()?['Name'], '.pdf', '')
)
)
)
),
'-',
outputs('SerialNumberVar'),
'-',
formatDateTime(utcNow(), 'MMddyyyy'),
'.pdf'
)

Categories:

Building flows

I have the same question (0)

All responses (15)

Answers (3)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @2C4C3C9127

You meant by the IF conditions are not evaluating at all?

if(equals(item()?['{DocumentTypeVar}'], 'Configuration Pages'), 'CONF',
if(equals(item()?['{DocumentTypeVar}'], 'Delivery and Acceptance'), 'DA',
if(equals(item()?['{DocumentTypeVar}'], 'Receivables'), 'REC',
if(equals(item()?['{DocumentTypeVar}'], 'Picking and Packing Lists'), 'PICPAK', replace(item()?['Name'], '.pdf', '')
)
)
)
)

Only the 'SerialNumberVar' and MMddyyyy is working.

The evaluating texts (eg:'Configuration Pages') under the IF condition is case sensitive so make sure its exactly the same for all the texts.

Thanks

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @2C4C3C9127

Another thing to consider is if its not the exact word then you should use 'contains' instead of 'equal'.

Thanks

Was this reply helpful? Yes No
2C4C3C9127 71 on at

Like (1)

Report

Thanks for the feedback and I think you are correct about changing it from Equal to Contains. Since I do think there are some line breaks that could cause me an issue.

So I changed it from equals to contains and I'm getting this error: InvalidTemplate. Unable to process template language expressions in action 'Create_file' inputs at line '0' and column '0': 'The template language function 'contains' expects its first argument 'collection' to be a dictionary (object), an array or a string. The provided value is of type 'Null'.'.

The value of DocumentTypeVar is:
" Picking\nand Packing Lists"

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @2C4C3C9127

If you want to remove the \n then before comparing the DocumentTypeVar clean up using replace() expression and use the separator as \n. This will give you Picking and Packaging Lists.

Thanks

Was this reply helpful? Yes No
2C4C3C9127 71 on at

Like (1)

Report

I would guess you mean this expression: replace(outputs('DocumentTypeVar'),'\n','')

I have read that something like this would not work?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Yes, Did you tried?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

This blog might be helpful.

How to replace new line ('\n') in a Power Automate expression (tomriha.com)

Was this reply helpful? Yes No
Verified answer

2C4C3C9127 71 on at

Like (0)

Report
Yes, that now works perfectly. I'm still having an issue renaming the attachment from Gmail.

I switched back to:
concat( if(equals(item()?['{DocumentTypeCleanVar}'], 'Configuration Pages'), 'CONF', if(equals(item()?['{DocumentTypeCleanVar}'], 'Delivery and Acceptance'), 'DA', if(equals(item()?['{DocumentTypeCleanVar}'], 'Receivables'), 'REC', if(equals(item()?['{DocumentTypeCleanVar}'], 'Picking and Packing Lists'), 'PICPAK', replace(item()?['Name'], '.pdf', '') ) ) ) ), '-', formatDateTime(utcNow(), 'MMddyyyy'), '.pdf' )

Does it have to the with the replace Name - should it be something different?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @2C4C3C9127

I noticed that you got curly brackets around your properties

item()?['{DocumentTypeCleanVar}

Change to

item()?['DocumentTypeCleanVar']

Do the similar for all other properties.

Was this reply helpful? Yes No
2C4C3C9127 71 on at

Like (1)

Report

Updated and tested, still will not rename the attachment.

Was this reply helpful? Yes No