Hello.
Help me to build a flow which will send a reminder to Responsible, 3 days before due date.
I've tried this solution, but I have an error
https://powerusers.microsoft.com/t5/Building-Flows/reminder-before-the-due-date/m-p/334664#M36202
My formula is
Solved! Go to Solution.
Try removing the expression and just reference Due Date from Dynamic properties. I don't believe that the expression is necessary if the date column is configured for date only rather than date and time.
Hi!
So it looks like the Sharepoint internal columns do not match with the column display name (Due Date).
Internal column names reported by the error message:
@odata.etag, ItemInternalId, ID, Title, Created, OData__Status, OData__Status#Id, Author, Author#Claims, Modified, Editor, Editor#Claims, Responsible, Responsible#Claims, Priority, Priority#Id, DepartementBudget, DepartementBudget#Id, {Identifier}, {IsFolder}, {Thumbnail}, {Link}, {Name}, {FilenameWithExtension}, {Path}, {FullPath}, {ContentType}, {ContentType}#Id, {HasAttachments}, {VersionNumber}'
Did you reuse standard 'Title' column and renamed it as 'Due Date'? When renaming Sharepoint columns, old name is kept as internal name
Hope this helps
Proud to be a Flownaut!
No, I am using standard SharePoint column 'Due Date'
Do you have a column called due date in your list? The error message suggests that there is no due date column.
Can you post a screen shot of your Flow?
Can you post a screen shot of your columns from list settings?
Yes I have.
Also I have tried to create new column DesiredDate. And there is the same error.
But if I use Created column in my flow it is working.
Try removing the expression and just reference Due Date from Dynamic properties. I don't believe that the expression is necessary if the date column is configured for date only rather than date and time.
Proud to be a Flownaut!
So easy😀
It works, thank you!
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
41 | |
31 | |
29 | |
28 | |
26 |