Answered

How can I convert the output of a "List files in folder" action from an object to an array?

(0) Share

Report

Posted on by DanJECC

Hi. Very new to Power Automate and expressions. I am trying to get a list of files and folders in a target OneDrive folder and filter out the file names to end up with a list of folder names only.

The ultimate goal is to compare those folder names with a string extracted from an email (which I have figured out how to do), and IF there is a match, save the email as a .eml file into the folder whose name matches the word extracted from the email.

I've worked out a series of steps to achieve this goal, but I am currently stuck at filtering the list of files and folders... I need to convert the result to array first apparently, but I do not understand how to do that. I have asked Copilot but none of its solutions work. And everything I find online either doesn't work or isn't suitable for this task. Any help with this would be greatly appreciated!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-yueyun-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi , @DanJECC

According to your description, you want to convert the "List files in folder" action from an object to an array.

This is my output of my "List files in folder" action:

For example , if you want to make all the [Name] in an array , you can just use this expression:
xpath( xml(json(concat('{"root":{"item":',outputs('List_files_in_folder')?['body/value'],'}}'))) , '/root/item/Name/text()')

Then we can get an array of [Name]:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
DanJECC 42 on at

Like (0)

Report
Copy link

Link copied!

Ahh, excellent. Is there a way to simultaneously filter the list of names to only include the folder names? Or does that require an additional step?

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi , @DanJECC

If you want to just extract the folder names like this:

You can try to use this expression:
xpath( xml(json(concat('{"root":{"item":',outputs('List_files_in_folder')?['body/value'],'}}'))) , '/root/item[IsFolder="true"]/Name/text()')

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
DanJECC 42 on at

Like (0)

Report
Copy link

Link copied!

Amazing! That does exactly what I need to do. Next step is to string match that output to see if a specific folder exists, but I think I have what I need for that. Thank you very much for your help.

Was this reply helpful? Yes No