Unanswered

Published App is not working as it does in test

(2) Share

Report

Posted on by nogucars

My App has 6 forms that are connected to 6 different sharePoint lists, in the first page I have a register button, which once is selected create a record on each list. when I run in the test mode, it works perfect, all 6 SharePoint lists are updated and respond accordingly, however, after publishing, only 2 lists are updated and the rest are not. How can I fix this?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (1)

Report

Hi @nogucars

Without seeing your app, understanding the flow of the app, how the data is accessed and used, there isn't really anything we can tell you.

I am not even completely sure what is wrong.

DO you get errors or does data just not load?

Have you verified that your users have the proper roles to access the Custom Tables/Lists?

If you run the app under Live Monitor, do you get errors so you can see exactly why those users cannot see the data.

BTW does this happen to you also?

Was this reply helpful? Yes No
MS.Ragavendar 4,977 Super User 2025 Season 2 on at

Like (1)

Report

@nogucars,

Kindly share the formula which you written, with the text solution cannot be derived.

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

Was this reply helpful? Yes No
nogucars 13 on at

Like (0)

Report

Hi @MS.Ragavendar, and @Michael E. Gernaey

What I've end up doing was creating the records on the first list and then getting Power Automate to copy them on the others and it works,. What I was trying to do before was in the same button having this formula ( SubmitForm(Form1);SubmitForm(From2)..... for all the 6 forms I want. It seems to work good for the first 3 forms I start with but it doesn't do for all 6.

Was this reply helpful? Yes No
Verified answer

MS.Ragavendar 4,977 Super User 2025 Season 2 on at

Like (1)

Report
@nogucars,

Use Patch() Instead of submit Form

Set(varRecord1, Patch(List1, Defaults(List1), {...}));
Set(varRecord2, Patch(List2, Defaults(List2), {...}));
Set(varRecord3, Patch(List3, Defaults(List3), {...}));

This give you flexibility which records are patched which doesn't patch, however you have write the logics for each and every control.

Use the OnSuccess Property of Each Form (Recommended)

Chain them properly using the OnSuccess property of each form.

In Form1’s OnSuccess:

SubmitForm(Form2)

In Form2’s OnSuccess:

SubmitForm(Form3)

until Form6, which can then navigate to the next screen or show a confirmation.

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

Was this reply helpful? Yes No