Follow Up Date Error w/ Blank Date Field

(0) Share

Report

Posted on by DarenD

133

Team,

I have a SharePoint library where one of the fields is a Date field and I'm trying to do the following:

1. Get All Items in specfic view

2. Determine if "SRTS Follow Up Date" is Blank or Not

3. IF NOT BLANK then Determine if "SRTS Follow Up Date" is 1 day ahead of today's date // IF BLANK do nothing

4. IF 1 day ahead of today's date send e-mail // IF NOT do nothing (I have a test e-mail in the FLOW to tell me so I can do troubleshooting, but generally the NO would be blank)

Code Snippet for Blank Field Determination: @empty(triggerBody()?['SRTS_x0020_Follow_x0020_Up_x0020_Date'])

Code Snippet for Notice Determination: @equals(formatDateTime(item()?['SRTS_x0020_Follow_x0020_Up_x0020_Date'], 'MM/dd/yyyy'), formatDateTime(addDays(utcNow(), 1), 'MM/dd/yyyy'))

Here's all the supporting data and any help would be most appreciated:

Data:

FLOW:

Errors:

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

v-yamao-msft on at

Like (0)

Report
Hi @DarenD,

Thanks for sharing the details information.

From your description, it seems that you want to check if the column “SRTS Follow Up Date” is empty or not. If it is not empty, then check if it is 1 day ahead of Today’s date.

Besides, the error message means that function formatDateTime expect a string value for its first parameter, but there is no value can be formatted.

Please just move the second Condition DeterminNoticeToday under If no branch.

Or in the first Condition DeterminBlankDates, use the following code, then just add the second condition under If yes branch.

@not(empty(triggerBody()?['SRTS_x0020_Follow_x0020_Up_x0020_Date']))

Please try again with it on your side.

Best regards,

Mabel

Was this reply helpful? Yes No
DarenD 133 on at

Like (0)

Report

Mabel,
I did as suggested for both solutions and while both actually got the FLOW to run no e-mails where sent. So I then simply did the IF BLANK statement and moved the notice to the NO branch and removed the IF date is tomorrow condition just to see if it was working. So it was and of the 2000k + rows I only recieved about 250 blank date notices...and then no more notices. It did't even get close to the records that had dates filled in. Is there a limit on how many rows a FLOW can go through?

Thanks
D

Was this reply helpful? Yes No
v-yamao-msft on at

Like (1)

Report

Hi @DarenD,

To change default limit of SharePoint action Get items, please try to enable Pagination under Settings.

Please check the following blog for a reference:

https://sharepointlibrarian.com/2017/11/11/how-to-change-microsoft-flows-default-limit-of-100-items-for-get-items-and-get-rows-actions/

Best regards,

Mabel

Was this reply helpful? Yes No
DarenD 133 on at

Like (0)

Report

Mable,
So that was super useful in helping with part of the issue. Thank you!!

However, the overall issue still remains. I made the changes and it times out after 6-8 min. It appears to be trying to process through all 2300+ items, but I've set the getItems view to a specific view that only has about 250 items in it. I would have thought that the FLOW should only be processing through those 250 and not all items in the library?
Here's the screenshots:

View with number of items:

FLOW Code:FLOW Error Message:

Was this reply helpful? Yes No
GabrielStJohn on at

Like (0)

Report

Hello, @DarenD!

Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @v-yamao-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

Was this reply helpful? Yes No
DarenD 133 on at

Like (0)

Report

Yes I did but it hasn't solved the problem. I've posted what's happening and am hopeful that Mabel can help.

Was this reply helpful? Yes No
DarenD 133 on at

Like (0)

Report

Mabel, quick update, I created a test list with a date and the code worked just fine. But when I did the same to the actual library where the FLOW is supposed to run it doesn't and I'm starting to wonder if it's amount of items in the library (2500+ and growing), but I did set a specific view that it's supposed to pull from with only about 250 items, but it seems to be going through them all.

Was this reply helpful? Yes No
Verified answer

DarenD 133 on at

Like (0)

Report

I got it working! I used the getItems filter capability to finally get it working.

Was this reply helpful? Yes No