@epicsmokey The reason your Get Items action isn't returning any items is because you are checking to see if the Created column is equal to a specific date. However, the Created column stores a date/time.
Your filter query needs to include a time. I'm using the Classic builder in my screenshots below. You'll have to switch to the Classic Designer to follow along. Click on the three dots in the top right corner of the screen and select Switch to Classic Designer.
Tip: Always rename your actions to keep your flow organized!
Manual Trigger with Date Input
While you build your flow I would recommend using a Manual Trigger with a date input. This way you can try your flow out and select a specific date to mimic for testing.
Once your flow is tested and ready to go you can replace the Base time with the current date and time ( aka utcNow() ).
Create a Dynamic Timestamp
Please note: The Scope action is optional. Not required, but I use them in my flows to keep things organized.
Not sure when you plan to run this flow but it's always best to ensure that the time zone matches which is why I use the Convert time zone action.
For the Base Time field you need to insert the Date input dynamic content (if you are using it). If not, you can insert an expression for the current date/time. The utcNow() function will return the current date and time.
utcNow()
For the source time zone, select (UTC) Coordinated Universal Time. Select the appropriate destination time zone to match your time zone. In the Format String field, select Round-trip.
The next few actions we'll use to compose your dynamic date. This is the date we'll use to check against the created date column in your SP list.
In the first Compose action, insert the number of days to add or remove from today. In your case, enter -3.
Add a Compose action to store today's date. You'll need to insert an expression. Insert the formatDateTime() function.
Place your cursor in between the brackets and insert the dynamic content output from the Convert Time Zone action.
Add a comma and single quotes with the date format. In this case:
Compose Dates 3 Days from Today
The next compose action will store the expression that will create the date that is 3 days from today.
'To do this you need to start with the addDays() function. Make sure you have the Expression tab selected.
There are three parts to this function. You'll be using dynamic content for the first two: original date and days to add/remove.
addDays([orginal date],[days to add/remove],[dateformat])
Switch to the Dynamic content tab. Make sure your cursor is in between the parentheses. Locate the Converted time dynamic content and select it to insert it into the expression.
Add a comma after the dynamic content and insert the outputs from the Compose action. Although you can manually enter the number of days to add/remove here—I've chosen to use a Compose action so I can easily switch the number of days without needing to edit the expression. Do whatever works for you.
Press the down arrow key to go to the end of the expression. Press the left arrow key once. Your cursor should be placed right before the closing bracket.
Add the following after the expression label.
T23:59:00Z
Filter Items
Add a Filter Query. The operator you should be using is le (less than or equals to) or you can use lt (less than)—use whichever operator suits your needs.
Check Item Count
Whenever I use a Filter Query in a Get Items action, I always like to return the count of items returned in a Compose action. This is helpful when building a flow and can also be used to troubleshoot your flow.
Insert a Compose action. Add an Expression. Use the length() function.
Select the Dynamic content tab and insert the value dynamic content from the Get Items action into the length() function.
Run a test.
Add a Condition
I would also recommend adding a Condition to your flow to only perform actions if items have been returned.
Hope this helps!
If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!
|
Share
Report
48
All responses (
Answers (
