cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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
Highlighted
Anonymous
Not applicable

Re: show data from multiple tables help

Hello,

 

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

Highlighted
Frequent Visitor

Re: show data from multiple tables help

@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.

 

Highlighted
Frequent Visitor

Re: show data from multiple tables help

@

Highlighted
Anonymous
Not applicable

Re: show data from multiple tables help

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Come join us today! Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (3,420)