Unanswered

Search and retrieve the data

(0) Share

Report

Posted on by WiAmb Microsoft Employee

Hello,

I used Mobile App connect data SQL Server. I have 2 forms one that inter the customers information, the 2nd I want customer search for his\her Auto ID and find the information that already inter in 1st forms. So any help what can I do to retrieve the data ? and where to do in SQL Server or PowerApps ?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @WiAmb

This can be done on PowerApps forms itself using some logical expression. Can you share more details about the schema and the scenario you are trying to build here? This way we can help you build the expression that you need.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
WiAmb Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank You @yashag2255 for your response.

I want to do a shipment application , where the employee enters the shipment information then gets Track ID back and gives it to the customer (I have finished implementing this part) the second part is where the customer can search their shipment by entering the track ID to retrieve the information of the shipment that was already entered by employee; I am facing an issue in implementing this

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WiAmb ,

Do you want to filter items based on entering track ID?

Could you describe more clearly what problem do you have when filtering data?

Could you tell me data type of the track ID field?

Do you use textinput to enter track ID?

I assume that it is number field and you use textinput to search.

If so, please try to set gallery's Items:

Filter(table, Value(textinput.Text) in track ID)

Best regards,

Was this reply helpful? Yes No
WiAmb Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @v-yutliu-msft
Do you want to filter items based on entering track ID? No, not filtering items. Retrieve information from database.
Could you describe more clearly what problem do you have when filtering data? the second part or form is where the customer can search their shipment by entering the track ID to retrieve the information of the shipment that was already entered by employee; I am facing an issue in implementing this that I don't know where to do in SQL Server or in PowerApps and what to do?

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @WiAmb

The retrieval can be done directly in the powerapps. For this, you need to connect the SQL table as a valid datasource and then you can use Filter() query to get the required records.

Expression that can be used:

If TrackId is string:
Filter(TableName, TrackID = TextInput1.Text)

If TrackId is integer:
Filter(TableName, TrackID = Value(TextInput1.Text))

Here, the TrackID is the column name in the SQL Table and TextInput1 is the name of control to get the userinput for tracking id.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No