web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : GyEZWhw5aO91jXON9Ald2J
Power Platform Community / Forums / Power Apps - Building Power Apps / gateway CRM on-Premise
Power Apps - Building Power Apps
Answered

gateway CRM on-Premise

Like (0) ShareShare
ReportReport
Posted on 17 Jun 2019 15:06:52 by Akbulut 4

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.

I have the same question (0)
  • SurfinPuff Profile Picture
    SurfinPuff 4 on 16 Mar 2023 at 08:34:37
    Re: gateway CRM on-Premise

    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.

  • cermanhall Profile Picture
    cermanhall 2 on 25 Oct 2022 at 21:07:10
    Re: gateway CRM on-Premise

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

  • Verified answer
    v-yutliu-msft Profile Picture
    v-yutliu-msft on 18 Jun 2019 at 07:32:00
    Re: gateway CRM on-Premise

    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

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 917 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 387 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 334 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans