cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jchauvet
New Member

Most recent file in one drive or email

Im looking for a way to take the most recent  excel file in one drive and convert the worksheet to tables. Im having a hard time finding a way to choose the most recent file as the selections I see want to point to a specific file. 

2 REPLIES 2
v-yamao-msft
Community Support
Community Support

Hi @jchauvet,

 

Do you want to get the most recent file in OneDrive and then convert it to a table?

I have figured out a way to get the most recent file in OneDrive, please check the following flow for a reference.

Add a button trigger.

Add OneDrive connector List files in folder.

Initialize variable, set Name as Max, Type as Array.

Add Apply to each, inside the Apply to each add the action Append to array variable. Set Name as Max, and set Value with the following code:

ticks(items('Apply_to_each')?['LastModified'])

Under the Apply to each, add a Compose action with the following code to get the Max value:

max(variables('Max'))

Add Apply to each 2, select output Value from the action List files in folder.

Within the Apply to each, add a Condition with the following code to get the Max one:

@equals(ticks(items('Apply_to_each_2')?['LastModified']), outputs('Compose'))

Under if yes branch, add a Compose to return the file name.

Screenshot for your reference.

1.PNG

To convert the worksheet to Excel table, we will have to use the Excel Online action Create table. However, dynamic content in File&Table inputs are not supported in Excel Online connector. So I am afraid that we could not achieve creating a table in this scenario.

There is a similar request on supporting dynamic content in File&Table inputs for connector Excel Online, please feel free to vote the idea at here:

https://powerusers.microsoft.com/t5/Flow-Ideas/Dynamic-content-in-File-amp-Table-inputs-Excel-Busine...

 

 

Best regards,

Mabel

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Question... in the next to last step:

 

You write:

Within the Apply to each, add a Condition with the following code to get the Max one:

@equals(ticks(items('Apply_to_each_2')?['LastModified']), outputs('Compose'))

But, when I add a condition, it looks like this:

condition.jpg

How can I add "@equals(ticks(items('Apply_to_each_2')?['LastModified']), outputs('Compose'))" when it is asking for a value that is equal to (or some other condition) to some other value? I don't see a way of simply adding "@equals(ticks(items('Apply_to_each_2')?['LastModified']), outputs('Compose'))"

 

thanks in advance.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,323)