cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Share-and-Flow
Frequent Visitor

PowerApps customize a SharePoint list form status empty on load. Read Status field on Sharepoint form load, if empty reload the forrm

I'm using @powerapps PowerApps to customize a SharePoint list. It's a form with multiple status (Choice field)

For each status there is a button in the Form.

Example, Status = Review ; Display  'Approve' button

 

But for some users the Button does not appear, because Status field is empty.

 

Could you please suggesst a way to make sure that the status is read on Visible and if not refresh the page so that Status and button is dispayed.

 

Thank you

3 REPLIES 3
v-jefferni
Community Support
Community Support

Hi @Share-and-Flow ,

 

Could you please share more details about your scenario? I'm more curious on why "for some users the Button does not appear, because Status field is empty." Have you append formulas OnVisible of the screen? If there is data in the status column, it should auto display in the Dropdown by the default setting. If you have done any modifications about the Dropdown/Combo box/Button, you need to share the details (formulas being used) so that we are able to understand deeper on your scenario.

 

Best regards,

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

Share-and-Flow
Frequent Visitor

Hi

 

Thanks for your reply.

 

Status is a simple dropdown Choice column, no custom modifications.

OnVisible of EditScreen , I have variable varKzStatus to read current status. 

 

Set(varKzStatus,SharePointIntegration.Selected.'Kaizen Status'.Value);
 
//** added this to see if it helps , but it didnt **//
If(IsBlank(varKzStatus),Refresh(SharePointIntegration.Selected)); 
Set(varKzStatus,SharePointIntegration.Selected.'Kaizen Status'.Value); 
 
//** For some Status values, certain fields are Editable **//
If(varKzStatus = "Review" || varKzStatus = "Benefit Review" || varKzStatus = "Complete" || varKzStatus = "Withdrawn" || varKzStatus = "Rejected" || varKzStatus = "Benefits Rejected" || varKzStatus = "No Action",
    Set(varEditableStatus,"false"),  
    Set(varEditableStatus,"true")
);
 

According to varKzStatus value , appropriate button is displayed on the form.

Eg. varKzStatus =Review ; Dispaly Approve Reject Button

 

But right now, when some users open the form, they cannot see the appropriate button because Status value is not loaded on Form Load.

If they Click Edit All button on top then the form reloads and Staus and buttons are visible.

But this is not the expected behaviour, Status should get displayed without having to press Edit All.

 

Thank you

Pranjali

Hi @Share-and-Flow ,

 

Adding a Label on that screen and set Text property to SharePointIntegration.Selected.'Kaizen Status'.Value, you will be able to easily check and see if the value has been passed to the App correctly. Furthermore, make sure all above formulas you have put to OnStart of the App Control than OnVisible of Screen.

 

Best regards,

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,397)