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 |
Hello,
This should be no problem for PowerApps. Are you looking for tips to make the app run smoothly?
@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.
@
@AnonymousI would be glad to help you out. A year ago, I was where you are now.
User | Count |
---|---|
236 | |
113 | |
94 | |
59 | |
31 |
User | Count |
---|---|
286 | |
132 | |
104 | |
63 | |
57 |