Unanswered

Send to CSV from Sharepoint list by latest date

(0) Share

Report

Posted on by Joel9799

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

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-bacao-msft on at

Like (0)

Report

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:

Please take a try.

Best Regards,

Barry

Was this reply helpful? Yes No
WDRC 247 on at

Like (0)

Report

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:

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

Was this reply helpful? Yes No