Hello, I have a canvas form for an SPO list. in the list I have "Accepted DateTime", a date/time field (not required).
Is it possible to add a button to the form so that when I want to populate "Accepted DateTime", it automatically fills the fields with the current date and time? (the reason, I want to save users (a little) time from having to select the date, and hours and min manually if possible)
The field should be blank until populated, then that value saved (unless overwritten).
Any thoughts?
(I am not very powerapps skilled)
Thank you in advance
@RandyHayes i have taken up so much of your time -- i really appreciate your help
So you are recommending changing this property to "new"? When i do that however, it seems to treat this form as a "new" entry vs editting an existing one (which is what i need). This field is only available when editting an entry.
Here's the item property -- I believe i got this from microsoft guide to adding edit form/screen
You are certainly not taking up time, it's important that you get what you need.
What I am stating is that the form has to be in a valid mode with a valid record.
If your form is in New mode (which it would be since you are doing SharePoint integration if the user clicks new - i.e. the OnNew action of the SharePointIntegration object) then that is fine.
If your form is in Edit mode (which it would be from the OnEdit action of the SharePointIntegration object), then the Item property needs to be a valid record.
So, either way is fine, you just HAVE to have a valid record for the form (again, New will provide its own record, and Edit will come from the Item property).
The question is...do you have an actual record in the form when you are in the design mode?
The scenario you are mentioning for what you are seeing is suggesting to me that it is not.
You can verify by placing your cursor at the end of your formula in the Item property of the form and seeing if the Formula Editor shows you a record.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
191 | |
95 | |
65 | |
63 | |
58 |
User | Count |
---|---|
243 | |
164 | |
91 | |
79 | |
78 |