Answered

gateway CRM on-Premise

(0) Share

Report

Posted on by Akbulut

Hi,

I created custom entity in CRM on-Premise.I want to create an App using this table.I set gateway and can take CRM SQL data.When I take custom entity data, I take an error like this "PowerApps could not create application for the selected table. Select a table with at least one type of text column in powerapps".

Is there any idea about this problem?

Thanks a lot.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Akbulut1 ,
Do you want to connect with CRM on-Premise?
I'm afraid there is no PowerApps connector for D365 on Premise currently.
There is a SQL Server connector, and this connector can connect to on premises SQL databases. This includes the D365 on premise SQL database.
Please make sure that your table has primary key. If not, it can not display in PowerApps successfully.
Here's a doc about it for your reference:
https://www.cmarix.com/how-to-connect-crm-2016-on-premise-version-with-powerapps/

Best regards,
Community Support Team _ Phoebe Liu

Was this reply helpful? Yes No
cermanhall 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Nice concept! If you must detail CRM used for drupal development services.

Was this reply helpful? Yes No
SurfinPuff 4 on at

Like
a
(0)

Report
Copy link

Link copied!

It seems that you are encountering an error when trying to create an app using a custom entity that you created in CRM On-Premise. The error message you received suggests that there might be an issue with the type of column that you are selecting for the table in PowerApps. It's possible that you need to ensure that there is at least one column in your custom entity that is of the "text" type in order to create an app successfully.
One solution could be to check the column types in your custom entity and ensure that at least one of them is of the "text" type. You could also try selecting a different table with a text column to see if the issue persists. If the problem keeps happening, you might want to ask for help from the PowerApps community or support team.

Was this reply helpful? Yes No