Answered

Can I have multiple PowerApp Forms driving a single SharePoint list? If not, can I use a hide/unhide tab structure?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi there,

I have 3 functional areas, IT, HR and Finance, all feeding information into the same SharePoint list. We have some standard fields that relate to all areas but we have some questions which are fed into the same fields but the actual questions are different. This means we need a different PowerApp form for each functional area.

Can I create multiple PowerApps from the same SharePoint list (seems like you can't)? If not, would it be best to use a single SharePoint list with tabs? If I can use a tab structure can I send out different URLs for the PowerApp that set certain tabs to be visible/hidden so only that 1 functional area tab is visible at any one time?

Thank you for your help

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous
Can you please give an example of a question that is different based upon which department the user belongs to? I think I have a good idea about how to accomplish this but I need an example to work with.

My preferred method would be to obtain the user's department using the Office365Users connector and show a different question based on that. We can use an IF statement to change the text of each question conditional on the department.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
denglish 128 on at

Like
a
(0)

Report
Copy link

Link copied!

In order to pass parameters into your PowerApp from the URL, check out this information on Deep Linking.

https://powerapps.microsoft.com/en-us/blog/powerapps-deep-linking/

Alternative to the tabs, you might consider using booleans to determine which DataCards are visible on the form in order to prevent needing multiple edit forms.
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to split your SP List fields into multiple separated Edit forms (each one for one individual functional area)?

Do you want to submit these multiple form data into single one record in your SP List rather than separated rows?

Based on the needs that you mentioned, I think PowerApps could achieve your needs. You could create one Edit form within each individual screen, then connect these three Edit forms to same SP List data source.

After that, within each Edit form, enable related/corresponding fields for corresponding functional area. Add "Next" buttons between these three screens. Within the Last Edit form screen, add a "Submit" button, set the OnSelect property to following:

Patch( 'Your SP List', Defaults('Your SP List'), Form1.Updates, Form2.Updates, Form3.Updates )

Please also check if the following thread would helps in your scenario:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Is-it-possible-to-split-an-edit-form-on-multiple-screens-Excel/m-p/511108

https://powerusers.microsoft.com/t5/Building-Power-Apps/Is-it-possible-to-split-the-Edit-Form-into-multiple-screens/m-p/243130

In addition, if you want to created Tabbed Forms in your canvas app, please check the following video resources:

https://www.youtube.com/watch?v=aA3gqmo1xzw

https://www.youtube.com/watch?v=NdiQ802dG3E

Best regards,
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I really like this idea. Hadn't thought of picking up the user's department from O365. However, my app is a change request tool. Users from any area can raise a request against any functional area so unfortunately it is not a clean 1..1 relationship so whilst very clever, this solution won't work for my app.

Thanks for the pointer though as I could definitely see this being useful for other areas.
v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Have you found a solution for your scenario?

If you have found a solution for your scenario, please consider share it here. So any other users faced same issue could reference to your experience.

In addition, if you have solved your problem, please consider go ahead to click "Accept as Solution" to identify this thread has been solved.

Best regards,