Answered

Create folder by sender and date

(0) Share

Report

Posted on by datalearner

Hi Community,

For example, I received an email from abc@powerautomate.com on 6/24/2024, I am finding difficulties in making the following scenario in PA:

PA should verify if I have a folder with the sender name (abc)
PA shoulde verify if I have a folder with the year of the received email (2024)
PA shoulde verify if I have a folder with the month of the received email (6)
Then save the attachement in the month subfolder

For each sender I should have this structure within a main Folder:

Folder by sender name (abc) / Folder by year / Folder by month

If the folder is not found, PA should create it, and run the whole flow for the new coming emails.

Any suggestions? Thank you in advance.
@Expiscornovus @fchopo @StalinPonnusamy allow me adding you to this post for help 👍

All responses (2)

Answers (1)

datalearner 71 on at

Like (0)

Report

Re: Create folder by sender and date

Thank you @Expiscornovus for the reply
I will try it and let you know the result
Verified answer

Expiscornovus 32,102 Most Valuable Professional on at

Like (0)

Report
Re: Create folder by sender and date

Hi @datalearner,

You could use an expression to extract what path you need to check. That expression uses a split and first to retrieve the name from the from field. It also uses formatdatetime and concat functions to retrieve the date related folders from the receivedDateTime field. After that you can check if the folder exists and only create it if needed.

Below is an example

I have used the has failed approach, which it will because it will return a NotFound error when the folder does not exist. However, other errors could also occur. So, it is better to use a condition action and check for the NotFound error instead. This is just a simple example to demonstrate the approach.

1. A Get Folder metadata using path is used.

The expression used to reconstruct the path via a concat function.

NameOfLibrary/@{concat(first(split(triggerOutputs()?['body/from'], '@')), '/', formatdateTime(triggerOutputs()?['body/receivedDateTime'], 'yyyy'), '/', formatdateTime(triggerOutputs()?['body/receivedDateTime'], 'MM'))}

2. A Create new folder action is added

The configure run after setting in this action is configured to only run this action when the previous action has Failed.

Expression used in Folder Path

concat(first(split(triggerOutputs()?['body/from'], '@')), '/', formatdateTime(triggerOutputs()?['body/receivedDateTime'], 'yyyy'), '/', formatdateTime(triggerOutputs()?['body/receivedDateTime'], 'MM'))

Community site session details

Create folder by sender and date

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Create folder by sender and date

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates