Thanks for sharing your issue. Just to help narrow it down — can you confirm:
Have you also added the "Transit No." field to the SourceTableView or made it available in the Query/Page Web Service?
"Transit No."
Are you accessing the OData URL from Excel with proper credentials and tenant context?
What's the exact error message you're seeing in Excel?
This info will help troubleshoot the issue more accurately.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Rishabh Kanaskar 4,275
Sumit Singh 2,677
Nimsara Jayathilaka. 2,526