Track New OneDrive Files in an Online Excel Spreadsheet (Business)

Like (0) Share

Report

Posted on 21 Oct 2021 13:53:59 by Community Power Pla...

I'm using the flow (link), but for some reason it's not inserting the date on the excel "add_a_row_into_a_table"

And this is online Excel, using the two columns (Name and Date)

I just need the name of the file and the date that it was created

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-LilyW-msft on 28 Oct 2021 at 02:47:28

Like (1)

Report

Re: Track New OneDrive Files in an Online Excel Spreadsheet (Business)

Hi @Anonymous
Please take a try to use base64ToString() function to convert.
Best Regards.

Was this reply helpful? Yes No
Community Power Pla... on 27 Oct 2021 at 19:08:34

Like (0)

Report

Re: Track New OneDrive Files in an Online Excel Spreadsheet (Business)

I did just like yours and now it's working, but the name of the file it's wrong

That is not the name of the file.pdf on onedrive

Was this reply helpful? Yes No
v-LilyW-msft on 27 Oct 2021 at 06:31:53

Like (1)

Report

Re: Track New OneDrive Files in an Online Excel Spreadsheet (Business)

Hi @Anonymous
I test on my side with the Template flow and it can work well.
You can refer to the screenshots below.
This is my test excel with a Table named Table1
When a new file is created in Test10.27 Folder. The file name and created time will be added in the excel.
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on 21 Oct 2021 at 17:41:59

Like (0)

Report

Re: Track New OneDrive Files in an Online Excel Spreadsheet (Business)

I set the excel as a table, now I'm having a different error:

"The established workflow action input is not valid."
the input data when I click on download link is

Was this reply helpful? Yes No