Timeline for SharePoint Automation - Send an email when a record meets criteria
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 26 at 21:51 | comment | added | Michael | Confirmed that the system name is reflected in the variable. Still not working. For the -60 part; that goes in the varDateTorday variable? | |
| Sep 22 at 21:53 | comment | added | user79408 | You will need to ensure that you are using the system name of the 'CES Intermediate Phase 1' column, not the display name. You might have to go to List Settings, click on the column and look at the address bar. The very end will be like: Field=FieldName or possibly Field=Field_x0020_Name. Once you have that, you could use addDays(Field_x0020_Name,-60) in your filter query | |
| Sep 20 at 17:40 | comment | added | Michael | Thank you for this! I've got a good start here. I'm having trouble with getting the "Get items' step to return anything. I have the SIte Address and List Name pointing to the correct location, but I'm not sure that the 'Filter Query' input is correct. Here's what I have CES Intermediate Phase 1 eq 'varDateToday' (The varDateToday is the dynamic content as you have shown in your example with the purple box. The other thing is that this needs to fire 60 days before the expiration date entered in the cell. Is there a way to adjust the "Initialize variable" step to make that happen? Thanks! | |
| Sep 19 at 23:22 | history | answered | user79408 | CC BY-SA 4.0 |