Unanswered

Create a recurrence Work flow by filtering excel based on month

Like (0) Share

Report

Posted on 3 Sep 2021 07:15:20 by Gowtham_1

I have an Excel Sheet in my SharePoint Document Library which will be updated on daily basis with reference to DD/MM/YYYY. i need this excel has to be sent as an attachment through email on daily basis . What i need here is to create a recurrence work flow in which the data to be filtered based on current month and that data has to be sent as an attachment through email. for example assume the excel sheet contains data from 01/06/2021 to 31/08/2021. if the current month is August, then only august month data should be filtered and sent as an attachment through email on daily basis. Could any one please on this

I have the same question (0)

All responses (3)

Answers (0)

Mitanshu 1,635 Moderator on 03 Sep 2021 at 20:48:30

Like (0)

Report

Re: Create a recurrence Work flow by filtering excel based on month

The syntax for Filter Query will require your column name not the column number (L)

For start Date of Month, you can use as below:
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Gowtham_1 25 on 03 Sep 2021 at 14:43:40

Like (0)

Report

Re: Create a recurrence Work flow by filtering excel based on month

Hi if you don't mind could you please help me with screen shots. The date is in L column of Excel

Was this reply helpful? Yes No
Mitanshu 1,635 Moderator on 03 Sep 2021 at 11:00:25

Like (0)

Report
Re: Create a recurrence Work flow by filtering excel based on month

When you use List Rows in a Table action in your Flow, you can use Filter Query to get start of month and end of month

STARTDATE = startOfMonth(utcNow())

You can get last day of month, as below:
1 - Add 1 month to utcNow()
2 - Get startOfMonth of new date
3 - Subtract 1 day from startOfMonth of new date

You can combine step 1-3 for LAST_DAY_OF_MONTH using:
subtractFromTime(startOfMonth(addToTime(utcNow(),1,'month')),1,'minute')

Finally, Filter Query as below:

YOURCOLUMN ge 'STARTDATE' and YOURCOLUMN le 'ENDDATE'

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No