cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Kingpin
Kudo Kingpin

CDM Query

Is there any way to create a query from CDM Entities (Tables)?

4 REPLIES 4
Highlighted
Community Champion
Community Champion

Re: CDM Query

Hi

 

When I first learn myself MySQL & SQL, I use to see the word "Query". 

Is that something like Select....from....?

If yes, then in PowerApps, you can always use:

- Filter and Search (for Table)

- LookUp (for single value)

based on condition as set in:

- If, =, in, exactin, <, >, etc.

 

Hope this helps.

hpkeong
Highlighted
Kudo Kingpin
Kudo Kingpin

Re: CDM Query

CDM is said to be the furure of Database, and it should give the possibility to ceeate queries within CDM portal, an answer to Excel reporting for instance. a query should be made in seconds, similar to any other database.

Highlighted
Community Support
Community Support

Re: CDM Query

Hi Yahya,

 

Thanks for the idea.

Please consider submit this in the PowerApps Idea forum.

PowerApps by default can't modify the data source(See here), so at least I would agree to have the query available from the data source side, and make PowerApps be able to connect with the Query.

You may also take a look at the following idea:

PowerApps must also see SQL Azure Queries, not only Tables

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Kudo Kingpin
Kudo Kingpin

Re: CDM Query

Thanks. Actually the Idea you are referring to is posted by me. I am glad that it has been noticed by other users.

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,100)