Microsft Power Automate Desktop

(0) Share

Report

Posted on by arcado

320 Moderator

I am dowlanding attachments from outlook with Desktop but I need only to .xlsx files how can I filter that?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

OkanMTL 703 Super User 2024 Season 1 on at

Like (0)

Report

HI,

You can't directly say that you only want .xlsx files when using the activity retrieve emails from outlook within Power Automate Desktop.

What you can do is:
1. Use Retrieve email from outlook activity and save the files (im guessing you already have this part)
2. Use get files in folder activity. HERE, you can filter on .xlsx
3. Save those files somewhere else and clear the first folder.

Good luck.

Was this reply helpful? Yes No
arcado 320 Moderator on at

Like (0)

Report

Hi,
I did what you suggested That is working but I have a following problem. It stores as %movedfiles% and ıt cant get file path for that how can I do that do you have an idea?

Was this reply helpful? Yes No
OkanMTL 703 Super User 2024 Season 1 on at

Like (0)

Report

If moving files work after downloading them as an attachment, and %movedfiles% is an output from that activity, don't do anything.

Your next step should just be get files from folder (where the moved files are) and within this activity, you can filter on .xlsx

Was this reply helpful? Yes No
arcado 320 Moderator on at

Like (0)

Report

actually no, i did your step moved files with extension xlsx name of %movedfiles% . because it is list ı cant get the path. That the issue

Was this reply helpful? Yes No
OkanMTL 703 Super User 2024 Season 1 on at

Like (0)

Report

You can get to the path by looping your list. The value of %movedfiles% are multiple filepaths, you can retrieve the values from a list like that with simple activities. like a for each (filepath) loop.

Was this reply helpful? Yes No