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!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.