Hey Community,
i have a very strange problem which i am stuck with. Hope you can help me.
I have a Custom Table where i added a Relation to the System Currrency Table because i need the transactioncurrencyid code.
When i try to import the solution to our Pro Environment i get an import error that there is a problem with that Currency colum.
I then tried to delete the Currency Column on my Testenvironment but the Delete Column Option is disabled, same when i try to delete the Relationship, also disabled. I also tchecked if there are any dependences, which are not. Also tried to delete the column and the Relation in the classic view, but neither worked. Pls find attached several Screenes.
Import Errormessage
Solution "HR Requests Powerapp" failed to import: The FetchXml (<fetch version="1.0" mapping="logical"><entity name="cr36b_hrrequestworkertimes"><attribute name="cr36b_hrrequestworkertimesid" /><attribute name="cr36b_id" /><attribute name="createdon" /><order attribute="cr36b_id" descending="false" /><filter type="and"><condition attribute="statecode" operator="eq" value="0" /></filter><attribute name="cr36b_requestid" /><attribute name="cr36b_requestdate" /><attribute name="cr36b_requesttype" /><attribute name="cr36b_workername" /><attribute name="cr36b_workeremail" /><attribute name="cr36b_supervisorname" /><attribute name="cr36b_supervisoremail" /><attribute name="cr36b_requeststatus" /><attribute name="cr36b_department" /><attribute name="cr36b_estimatedamountofovertimehours" /><attribute name="cr36b_compensationtype" /><attribute name="cr36b_disbursementtype" /><attribute name="cr36b_comments" /><attribute name="cr36b_legalentity" /><attribute name="cr36b_startdate" /><attribute name="cr36b_enddate" /><attribute name="cr36b_totaltimeperrequest" /><attribute name="transactioncurrencyid" /><attribute name="cr36b_costs" /><attribute name="cr36b_location" /><attribute name="cr36b_organizer" /><attribute name="cr36b_reason" /><attribute name="cr36b_title" /></entity></fetch>) is invalid. Failure ('cr36b_HRRequestWorkerTimes' entity doesn't contain attribute with Name = 'transactioncurrencyid' and NameMapping = 'Logical'. MetadataCacheDetails: ProviderType=Dynamic, StandardCache=False, IsLoadedInStagedContext = True, Timestamp=8690611, MinActiveRowVersion=8690611, MetadataInstanceId=30650135, LastUpdated=2021-05-21 05:02:37.587) occurred while calculating dependencies for SavedQuery (Id=19cecf40-93d6-4ecb-bf0a-de3990c10291).
Any ideas how i can get rid of that currency column or how i can import the solution?
Thx in adv.
Solved! Go to Solution.
We found a solution.
The Problem looks like that the modern view is causing problems importing the solution.
The solution was to switch to the classic view on the pro environment and import the solution without problems 🙂
From your first screen you are trying to delete the out of the box field transactioncurrencyid, and this field is added by default to any Dataverse custom entity, so are u sure this is the field you have created?
Hey, thank you for your answer.
i am kinda sure that i created a Lookup Column named Currency to the Currency Table or maybe i created a Relationship from my table to the currency table (its been quite some time :). The Type of the Column is Custom and not standard. I have created a few other tables in the same solution and there are no Currency fields added automatically.
Yes that will be the first time i try to import the solution to the new enviornment. I tried to use a managed solution, since it should be deployed to a productive environment.
We found a solution.
The Problem looks like that the modern view is causing problems importing the solution.
The solution was to switch to the classic view on the pro environment and import the solution without problems 🙂
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
17 | |
10 | |
6 | |
4 | |
4 |
User | Count |
---|---|
29 | |
17 | |
13 | |
9 | |
8 |