Hi, i have a powerapp form link to my sharepoint site. The powerapp form has multiple screens.
When the form is opened from SharePoint, a want the correct screen to load based on the status of the sharepoint record.
My SharePoint OnView and OnEdit has the below expression, where varStatus is the status of the record, 'SMR Register' is the SharePoint list.
Refresh('SMR Register');
Set(
varStatus,
SharePointIntegration.Selected.Status
);
Switch(
varStatus,
"Pending Review",
Set(
varStatusValue,
2
);
Navigate(Screen_Review),
"Pending Authorisation",
Set(
varStatusValue,
3
);
Navigate(Screen_Approval),
"Pending Implementation",
Set(
varStatusValue,
4
);
Navigate(Screen_Implement),
"Pending Verification",
Set(
varStatusValue,
5
);
Navigate(Screen_Verify),
"Pending CloseOut",
Set(
varStatusValue,
6
);
Navigate(Screen_CloseOut),
"Closed",
Set(
varStatusValue,
7
);
Navigate(Screen_Request)
);
What i am seeing is that my switch function is working correctly. When i first open my SharePoint form, varStatus isn't set. I have to open the form twice for varStatus to be set correctly. Any ideas?
