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.
