Answered

How to select value from 1000 rows in Azure SQL?

(0) Share

Report

Posted on by kenny_i

1) I have 1000 rows in project table in Azure SQL. It contains project names and status.

2) I would like to create feature in PowerApps where end-user can input project name like "Toyota project" and PowerApps list project name from Azure SQL matching criteria.

3) I would like to then select the project and "Activate" the project, which update SQL table status value.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

2) GalleryProjects.Items = Search([dbo.MyProjects], TextInputProjectSearch.Text, ProjectName)
3) IconActivate.OnSelect = Patch([dbo.MyProjects], {ProjectId: ThisItem.ProjectId}, {ProjectStatus: "Active"})

if the above is not clear, please give me a Skype call on giacomo@baizini.com

Was this reply helpful? Yes No
kenny_i 18 on at

Like
a
(0)

Report
Copy link

Link copied!

What components are needed?
Text input named "TextInputProjectSearch"?
Gallery vertical? It should have item value "Search([PoaFormProjectAccess], TextInputProjectSearch.Text, ProjectId)"?

Where to insert IconActivate.OnSelect = Patch([dbo.MyProjects], {ProjectId: ThisItem.ProjectId}, {ProjectStatus: "Active"}) ?

Was this reply helpful? Yes No
Verified answer

Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!
@kenny_i wrote:
What components are needed?

Text input named "TextInputProjectSearch"?
YES, anywhere in the screen

Gallery vertical?
YES, blank vertical gallery

It should have item value "Search([PoaFormProjectAccess], TextInputProjectSearch.Text, ProjectId)"?
NO, it should have Items (with an s) property with value something like:
Search(Azure table name, TextInputProjectSearch.Text, ProjectId)
If ProjectId is a text field that contains the project name

Where to insert IconActivate.OnSelect = Patch([dbo.MyProjects], {ProjectId: ThisItem.ProjectId}, {ProjectStatus: "Active"}) ?
In the template of the gallery

Again, just call as it may be quicker/easier

Was this reply helpful? Yes No
kenny_i 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks! it works

Was this reply helpful? Yes No