Power Platform Community Forum Thread Details

Hopefully I'll answer all your questions

Submit the form from PowerApps (Which it does)

Depending on how you save it, if its a submit form or just a patch there are a couple of ways, both involve saving the items as a variable.

When you do the submit, wrap it in a global variable using the Set function for patching or add another line for submitting a form

Set(gblSavedItem, <patch statement>) 
<Form1>.LastSubmit

Either of these will save the details of the item.

Access that same entry in the MS List

You should now be able to see the calculations by doing

gblSavedItem.<column>
<form>.LastSubmit.<column>

Pull a calculated value from the List form

If you can't see the calculated value item you will need to do the following

Lookup(<List>, ID = gblSavedItem.ID).<column>
Lookup(<List>, ID = <form>.LastSubmit.ID).<column>

Change Screen on PowerApps based on that valueFor this you could do a switch after the submission has been completed.

Switch(gblSavedItem.<column>, "column value 1", Navigate('Screen1'), "column value 2", Navigate('Screen2'))

Switch(<form>.LastSubmit.<column>, "column value 1", Navigate('Screen1'), "column value 2", Navigate('Screen2'))

This should give you most of what you need for a form submission the following should be it in a button

SubmitForm(<form>); 
Lookup(<list>, ID = <form>.LastSubmit.ID).<columnrequired>; 
Switch(<form>.LastSubmit.<columnrequired>, "column value 1", Navigate('Screen1'), "column value 2", Navigate('Screen2'))

-------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.