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!
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.