web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Track New OneDrive Fil...
Power Automate
Answered

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

(0) ShareShare
ReportReport
Posted on by

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"

rvinicius396g_0-1634823997054.png

 

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

rvinicius396g_1-1634824061478.png

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

rvinicius396g_2-1634824165460.png

 

rvinicius396g_3-1634824413223.png

 

 

 

Categories:
I have the same question (0)
  • Community Power Platform Member Profile Picture
    on at

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

    rvinicius396g_0-1634838018895.png

     

     

    "The established workflow action input is not valid."

    the input data when I click on download link is 

    rvinicius396g_1-1634838111191.png

     

  • v-LilyW-msft Profile Picture
    on at

    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

    vLilyWmsft_4-1635315714479.png

    vLilyWmsft_0-1635314700989.png

    When a new file is created in Test10.27 Folder. The file name and created time will be added in the excel.

    vLilyWmsft_5-1635315757545.pngvLilyWmsft_6-1635315897491.png

    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.

  • Community Power Platform Member Profile Picture
    on at

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

    rvinicius396g_0-1635361652239.png

     

    rvinicius396g_1-1635361748522.png

     

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

  • Verified answer
    v-LilyW-msft Profile Picture
    on at

    Hi @Anonymous 

    Please take a try to use base64ToString() function to convert.

    vLilyWmsft_1-1635388997440.png

    Best Regards.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard