Unanswered

Could not find a property named 'cr47d_teamname'

(0) Share

Report

Posted on by v-shimud

Hi,

Receiving below exception while trying to load data from excel in powerapps UI into one of the entity. Entity contains only one column TeamName. However when i try to publish data by downloding excel through powerapps plugin it is succeeding. Not sure if i am doing something wrong. Please advise.

Load to Common Data Service failed. Details: ID: https://org91c75df7.crm.dynamics.com/api/data/v8.2/cr47d_teamnames?$select=cr47d_teamname,cr47d_teamnameid&$filter=cr47d_teamname eq 'Book' or cr47d_teamname eq 'Category%20team' or cr47d_teamname eq 'Physical%20Goods' or cr47d_teamname eq 'Store%20Team' or cr47d_teamname eq 'Xbox%20Subscriptions': {"error":{"code":"0x0","message":"Could not find a property named 'cr47d_teamname' on type 'Microsoft.Dynamics.CRM.cr47d_teamname'.","innererror":{"message":"Could not find a property named 'cr47d_teamname' on type 'Microsoft.Dynamics.CRM.cr47d_teamname'.","type":"Microsoft.OData.ODataException","stacktrace":" at Microsoft.OData.UriParser.SelectPathSegmentTokenBinder.ConvertNonTypeTokenToSegment(PathSegmentToken tokenIn, IEdmModel model, IEdmStructuredType edmType, ODataUriResolver resolver)\r\n at Microsoft.OData.UriParser.SelectPropertyVisitor.ProcessTokenAsPath(NonSystemToken tokenIn)\r\n at Microsoft.OData.UriParser.SelectPropertyVisitor.Visit(NonSystemToken tokenIn)\r\n at Microsoft.OData.UriParser.SelectBinder.Bind(SelectToken tokenIn)\r\n at Microsoft.OData.UriParser.SelectExpandBinder.Bind(ExpandToken tokenIn)\r\n at Microsoft.OData.UriParser.SelectExpandSemanticBinder.Bind(ODataPathInfo odataPathInfo, ExpandToken expandToken, SelectToken selectToken, ODataUriParserConfiguration configuration)\r\n at Microsoft.OData.UriParser.ODataQueryOptionParser.ParseSelectAndExpandImplementation(String select, String expand, ODataUriParserConfiguration configuration, ODataPathInfo odataPathInfo)\r\n at Microsoft.OData.UriParser.ODataQueryOptionParser.ParseSelectAndExpand()\r\n at Microsoft.Crm.Extensibility.OData.CrmODataServiceDataProvider.ThrowIfExpandWithRefForNonLookupNavProp(ODataQueryOptions queryOptions, String edmEntityName)\r\n at Microsoft.Crm.Extensibility.OData.CrmODataServiceDataProvider.RetrieveEdmEntityCollection(CrmODataExecutionContext context, String entityCollectionName, String castedEntityName, ODataQueryOptions queryOptions)\r\n at Microsoft.Crm.Extensibility.OData.EntityController.<>c__DisplayClass35_0.<GetEntitySetInternal>b__1()\r\n at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties)\r\n at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action)\r\n at Microsoft.Crm.Extensibility.OData.EntityController.GetEntitySetInternal(String entitySetName, String castedEntityName, CrmODataExecutionContext context, CrmEdmEntityObjectCollection crmEdmEntityObjectCollection, ODataQueryOptions queryOptions)\r\n at Microsoft.Crm.Extensibility.OData.EntityController.GetEntitySetImplementation(String entitySetName)\r\n at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func, IEnumerable`1 additionalCustomProperties)\r\n at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func)\r\n at lambda_method(Closure , Object , Object[] )\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()"}}}. (Job ID: 2fc82d0a-a62b-413d-b4aa-392f823f047c)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

v-xida-msft on at

Like (0)

Report

HI @v-shimud ,

Do you want to import data from your Excel table into a CDS Entity?

Do you perform the Fields Mapping operation when you import data from your Excel table into a CDS Entity?

I have made a test on my side, and don't have the issue that you mentioned. Please consider take a try to import data into your CDS Entity using "Open in Excel" functionality in your CDS Entity.

Please check the following article or blog for more details:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-excel-addin

https://powerapps.microsoft.com/en-us/blog/cds-for-apps-excel-importexport/

In addition, the user @KeithWhatling has shared another alternative solution, please check the response within the following thread:

https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/PowerApps-Cannot-Import-Data-into-CDS-Entities/td-p/171063

Best regards,

Was this reply helpful? Yes No
v-shimud on at

Like (0)

Report

Hi Kris,

Open in Excel worked fine but issue occurs when i load data from excel which is in my onedrive location using get data option in the UI. I would want to load data automatically when there is an update.

Thanks,
Shiva M

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report

Hi @v-shimud ,

Do you want to use Power Query option to achieve your needs within your PowerApps?

Further, do you want to import your data into the CDS Entity automatically when there is an update in your Excel table?

It is a known limit that it would retrieve data from your OneDrive (or OneDrive for Business) rather than your local Excel table data when you use the "Power Query" -> "Excel" option to import data into your CDS Entity in your PowerApps.

If you want to import your data into the CDS Entity automatically when there is an update in your Excel table, I afraid that there is no way to achieve your needs in PowerApps currently.

In addition, you could also consider take a try to create a Data Integration Project within your PowerApps, then check if the issue is solved.

More details about creating a Data Integration Project within PowerApps, please check the following article:

https://docs.microsoft.com/en-us/power-platform/admin/data-integrator

Best regards,

Was this reply helpful? Yes No
v-shimud on at

Like (0)

Report

Hi Kris,

I tried using data integration app but still receiving same error while loading data from excel. Not sure if i am doing something wrong here as instructions are pretty straightforward.

Load to Common Data Service failed. Details: ID: https://org91c75df7.crm.dynamics.com/api/data/v8.2/cr47d_teamnames?$select=cr47d_teamname,cr47d_teamnameid&$filter=cr47d_teamname eq 'Book' or cr47d_teamname eq 'Category%20team' or cr47d_teamname eq 'Physical%20Goods' or cr47d_teamname eq 'Store%20Team' or cr47d_teamname eq 'Xbox%20Subscriptions': {"error":{"code":"0x0","message":"Could not find a property named 'cr47d_teamname' on type 'Microsoft.Dynamics.CRM.cr47d_teamname'.","innererror":{"message":"Could not find a property named 'cr47d_teamname' on type 'Microsoft.Dynamics.CRM.cr47d_teamname'.","type":"Microsoft.OData.ODataException","stacktrace":" at Microsoft.OData.UriParser.SelectPathSegmentTokenBinder.ConvertNonTypeTokenToSegment(PathSegmentToken tokenIn, IEdmModel model, IEdmStructuredType edmType, ODataUriResolver resolver)\r\n at Microsoft.OData.UriParser.SelectPropertyVisitor.ProcessTokenAsPath(NonSystemToken tokenIn)\r\n at Microsoft.OData.UriParser.SelectPropertyVisitor.Visit(NonSystemToken tokenIn)\r\n at Microsoft.OData.UriParser.SelectBinder.Bind(SelectToken tokenIn)\r\n at Microsoft.OData.UriParser.SelectExpandBinder.Bind(ExpandToken tokenIn)\r\n at Microsoft.OData.UriParser.SelectExpandSemanticBinder.Bind(ODataPathInfo odataPathInfo, ExpandToken expandToken, SelectToken selectToken, ODataUriParserConfiguration configuration)\r\n at Microsoft.OData.UriParser.ODataQueryOptionParser.ParseSelectAndExpandImplementation(String select, String expand, ODataUriParserConfiguration configuration, ODataPathInfo odataPathInfo)\r\n at Microsoft.OData.UriParser.ODataQueryOptionParser.ParseSelectAndExpand()\r\n at Microsoft.Crm.Extensibility.OData.CrmODataServiceDataProvider.ThrowIfExpandWithRefForNonLookupNavProp(ODataQueryOptions queryOptions, String edmEntityName)\r\n at Microsoft.Crm.Extensibility.OData.CrmODataServiceDataProvider.RetrieveEdmEntityCollection(CrmODataExecutionContext context, String entityCollectionName, String castedEntityName, ODataQueryOptions queryOptions)\r\n at Microsoft.Crm.Extensibility.OData.EntityController.<>c__DisplayClass35_0.<GetEntitySetInternal>b__1()\r\n at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties)\r\n at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action)\r\n at Microsoft.Crm.Extensibility.OData.EntityController.GetEntitySetInternal(String entitySetName, String castedEntityName, CrmODataExecutionContext context, CrmEdmEntityObjectCollection crmEdmEntityObjectCollection, ODataQueryOptions queryOptions)\r\n at Microsoft.Crm.Extensibility.OData.EntityController.GetEntitySetImplementation(String entitySetName)\r\n at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func, IEnumerable`1 additionalCustomProperties)\r\n at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func)\r\n at lambda_method(Closure , Object , Object[] )\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()"}}}. (Job ID: 35fd4aff-772a-476c-a51e-2baa807c3346)

Regards,
Shiva M

Was this reply helpful? Yes No