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.
The table structures are like below....and are in sql server .
I created 3 tables,
1- orders info
|order_number||order-status_id||order_status||order description||shipping address||quantity|
Order history table
@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.