web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Tranlate SQL sentence ...

Power Apps

Answered

Tranlate SQL sentence into Powerapps

(0) Share

Report

Report

Posted on by APD13

35

Hi!

I need to translate a SQL sentence into a powerapp dropdown/combo box and I don't see how.

I need to have a dropdown or combo box that shows only the people without nicknames. This would be the SQL Querry:

Select Table2.Name from Table2 INNER JOIN Table1 On Table2.PK_Table2 = Table1.FK_Table2 Where Table1.Nickname IS NULL.

Thanks in advance!

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

rbrooks66 143 on at

Like
a
(1)

Report
Copy link

Link copied!

I used a View to fill a drop down. The view excludes any Category that is not Active. I'm not sure if that helps you with what you're trying to accomplish. I've used Power Automate to call a Stored Procedure to Insert a record into a SQL DB, but I haven't seen anyway to directly insert SQL statements into the form.
v-yujincui-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @APD13 ,

Maybe you could try the following formula:

Filter(Table2,PK_Table2 in Filter(Table1,FK_Table2 in Table2.PK_Table2,IsBlank(Nickname)).FK_Table2 ).Name

Best Regards,
Charlie Choi

Join the conversation