Answered

Power FC code to connect Power App form to multiple dataverse tables?

(0) Share

Report

Posted on by Tal22

259

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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

AhmedSalih

6,678 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No

Tal22 259 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
Tal22 259 on at

Like (0)

Report

Thanks. That clears things up a bit, but do Model driven apps have sophisticated and customizable form controls like Access does?

Was this reply helpful? Yes No
Verified answer

AhmedSalih 6,678 Moderator on at

Like (1)

Report

@Tal22, Depend on your use cases. In general MDA are very powerful and easy to configure.

Was this reply helpful? Yes No