Announcements
I am an Access user. Access can connect a form to multiple tables without using code. Power Apps cannot. Do I need to a Power FX script to do so? If so, can someone direct me to the code link for this? GitHub?
Thanks.
Hello, @Tal22, I am not sure if I understand your question. Are you using Model-Driven Apps or Canvas? Dataverse Forms can be linked to multiple tables by using the SubGrids components but you have to created relationships between those different tables.
If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.
I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.
Visit my Blog: www.powerplatformplace.com
Hi Ahmad, I built two dataverse tables, one using a lookup column. I then tried to use a Power App form to access both tables, but apparently I need to write coded in the fx script screen. Power Apps is not a no code platform as it requires Power Fx. What I really would like to do is integrate an Access database, which does not require coding, into a Sharepoint environment. Is this possible? Or do I need to learn Power Fx to move forward? If so, where can I find the scripts to past into the fx menu to connect a form to multiple dataverse tables?
@Tal22, if you will build a Model-Driven apps, you don't need to learn Power Fx, but if you are going to build Canvas apps, then learning Power Fx is needed.
Thanks. That clears things up a bit, but do Model driven apps have sophisticated and customizable form controls like Access does?
@Tal22, Depend on your use cases. In general MDA are very powerful and easy to configure.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 103
WarrenBelz 82 Most Valuable Professional
wolenberg_ 67 Super User 2026 Season 1
