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

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Send to CSV from Sharepoint list by latest date

(0) ShareShare
ReportReport
Posted on by

Hi Everyone,

 

I am fairly new to using Microsoft flow and I have been working on a sharepoint list that gets updated when someone fills out a Microsoft form. What I am trying to do now is send only the newest data to a csv every week without having the whole list added over again.

 

I have a recurrence set up to start my flow every 7 days then I am using Get items (sharepoint) to get info from my sharepoint List. Where I am getting stuck is I am using column SubmittedDate from my sharepoint list which uses the date from the timestamp of the Form when it's submitted. The format in sharepoint is MM-dd-yyyy.

I can't figure out what equation to use for my condition to tell it to check to make sure that the utcNow date -(7 days) is greater than or equal to the SubmittedDate from sharepoint, especially when utcnow format is yyyy-MM-dd? 

 

Once I get that I can tell it to create the csv file with the columns from my sharepoint list. Any help would be greatly appreciated.

 

Joel

I have the same question (0)
  • v-bacao-msft Profile Picture
    on at
    Re: Send to CSV from Sharepoint list by latest date

    Hi @Joel9799,

     

    You could format the Date and get the corresponding data.

    Set conditions in Filter Query to filter the eligible items.

    Then configure Create CSV table action, it is recommended to configure custom columns, and then send as the body of the mail.

    Expression:

    addDays(utcNow(),-7,'yyyy-MM-dd')

    Image reference:

    Capture2.PNGCapture3.PNG

    Please take a try.

     

    Best Regards,

    Barry

  • WDRC Profile Picture
    247 on at
    Re: Send to CSV from Sharepoint list by latest date

    @v-bacao-msft

     

    I am wanting to do something similar, I have a SPL that I want to retrive the last seven days of data from that may have changed.  The current flow is below:

     

    craig list.png

     

     

    The filter column is Contact Made plus the expression above.  When I run the flow it fails on the get items with the filter.  The body messages reads as follows:

    {

    "status": 400,
    "message": "The expression \"Contact Made 2018-12-26\" is not valid.\r\nclientRequestId: c71e983b-60e1-477c-b2c2-76115a26d033\r\nserviceRequestId: 9de9b19e-100c-7000-69a8-0a54a9dcb595"
    }
    It apears to be recognising the fact that we need to go back seven days as it looking back to the 2018-12-26 but I have set a test date of 2018-12-28 which it should see and then go ahead and create an HTML table of that record 
     
    Do I need to be adding more expressions to gather the data from the 2018-12-26 through to 2019-01-02.  
     
    Hope you can assit.
     
    Regards,
     
    Andrew

     

    I have a 

    craig list.png

     

     

     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 691 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 431 Moderator

#3
developerAJ Profile Picture

developerAJ 266

Last 30 days Overall leaderboard