cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

show data from multiple tables help

hi, iam new to powerapps and need  help...

i have a requirement to develop an app with orders info.  My requirement is ..

1--on the first page, i enter (or select from dropdpwn) order number and when submitted,

2--it should take me to other page with all othe 'orders information'  ( this will have latest 'order status', 'updateddate', 'commenst ')  and 'order history' (this will have all historical records including current)

3--On that page, i should be able to edit, or update or enter few fields like 'status', 'comments'.  status field shoud have  dropdown values where i can choose from

4-- once update, it should update 'orders' table and also insert new record in orders hostory table.

5--after that show page with message  'order info updated' or any error and showing updated info page.

 

please advise..

The table structures are like below....and are in sql server .

 

I created 3 tables,

1- orders info

2-orders history

3-status table

 

 

 

orders table

order_numberorder-status_idorder_statusorder descriptionshipping addressquantity
2568011ordered   
2568021ordered   
2568032shipped   
2568043received   
2568053received   

 

Order history table

order_numberorder-status_idorder_statusstatus_updateddateupdated by comments
2568011ordered6/1/2019  
2568021ordered6/2/2019  
2568032ordered6/2/2019  
2568032shipped6/3/2019  
2568041ordered6/4/2019  
2568042shipped6/6/2019  
2568043received6/10/2019  
2568051ordered6/5/2019  
2568052shipped6/7/2019  
2568053received6/11/2019  

 

 

status table

status_idstatus
1ordered
2shipped
3received
4Assigned
5Returned
4 REPLIES 4
Anonymous
Not applicable

Hello,

 

This should be no problem for PowerApps. Are you looking for tips to make the app run smoothly?

Anonymous
Not applicable

@Anonymous iam a beginner..and i need  help on building this app...i looked at the videos and start connecting to tables...and building the default app...but i dont know how to get going from there..to meet  all the requirements above mentioned.

 

Anonymous
Not applicable

@

Anonymous
Not applicable

@AnonymousI would be glad to help you out. A year ago, I was where you are now.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,642)