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!
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.