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_number | order-status_id | order_status | order description | shipping address | quantity |
| 256801 | 1 | ordered | | | |
| 256802 | 1 | ordered | | | |
| 256803 | 2 | shipped | | | |
| 256804 | 3 | received | | | |
| 256805 | 3 | received | | | |
Order history table
| order_number | order-status_id | order_status | status_updateddate | updated by | comments |
| 256801 | 1 | ordered | 6/1/2019 | | |
| 256802 | 1 | ordered | 6/2/2019 | | |
| 256803 | 2 | ordered | 6/2/2019 | | |
| 256803 | 2 | shipped | 6/3/2019 | | |
| 256804 | 1 | ordered | 6/4/2019 | | |
| 256804 | 2 | shipped | 6/6/2019 | | |
| 256804 | 3 | received | 6/10/2019 | | |
| 256805 | 1 | ordered | 6/5/2019 | | |
| 256805 | 2 | shipped | 6/7/2019 | | |
| 256805 | 3 | received | 6/11/2019 | | |
status table
| status_id | status |
| 1 | ordered |
| 2 | shipped |
| 3 | received |
| 4 | Assigned |
| 5 | Returned |
