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
secondImage

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.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (37,833)