Hi, I have a simple app showing open activities from Dynamics 365 CE to the users, using CDS.
They can read and edit the activities and add comments including attachments to it.
With completing the activity, I have some doubts on how to do that.
Don't think I can just use the PATCH function to change the statuscode and statecode of the activity, is it?
Kind regards, Maurits
Could you please share a bit more about your scenario?
Do you integrate your Dynamics 365 entity into your CDS?
Further, do you want to change the statecode column value of the activity within your app?
If you want to change the statecode column value of the activity within your app, I think the Patch function could achieve your needs in PowerApps.
When you generate an app from your Dynamics 365 Activities entity, the statuscode column would be displayed as Status Reason, the statecode column would be displayed as Active Status:
I have made a test on my side, and I agree with your thought almost. When I use Patch function to update the statuscode column value and statecode column value of an activity, the error message shows up as below:
The "Update" method does not support entities of type 'activitypointer'.
I afraid that there is no way to update the statuscode column value and statecode column value of an activity using Patch function in PowerApps currently.
If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:
Hi @v-xida-msft, many thanks for your research.
I expected the status cannot be changed using PATCH or UPDATE, as within Dynamics you can also not just change the status field.
Have to find a proper workaround for this, maybe using a workflow within Dynamics or an API call or so.
Did you ever find a workaround for this? If you did, would you kindly share your know-how?
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
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!