I am loading some data from an Excel file and update a table in Dataverse. I use the "Dataflow" feature of (Model-driven) Power Apps to do this.
In the source data, a column indicates if an item is no longer used, and I would like to have that reflected in the integration - such that these items are deactivated and do not appear in the "Active <item>" built-in view.
How do I do that? I cannot see that I am able to map a source column to e.g. the "Status" (statecode) target column in Dataverse
No, Dataflows generally do not allow you to directly map source data to the Dataverse system columns statecode (Status) and statuscode (Status Reason).
This is a common limitation when importing data into Dataverse using Dataflows.
Workaround : Import a Custom "IsActive" Flag and Use Power Automate
This keeps the Dataflow simple and lets Power Automate handle activation/deactivation.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
83
Share
Report
All responses (
Answers (
