
My client wants me to create an app in power apps where he basically want to show all data related to service orders (service item, comments, standard service codes, etc). I have created a custom connector to fetch the service order page data using business central web services. And also data from linked pages but i am unable to list the service items that are associated with service order. Because i can not find any field that can link these records.
The list of pages that i am exposing as web services are following:
1- Service Order
2- Service Item Card
3- Service Comment Sheet
4- Standard Service Code Card
This is a lot of work; would recommend looking at an ISV solution like Anveo Mobile.
Alternately, why not just use the Mobile Client for BC with a custom role?