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

(0) Share

Report

Posted on by Share-and-Flow

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

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

v-jefferni on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No

Share-and-Flow

32 on at

Like (0)

Report

Copy link

Link copied!

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

Was this reply helpful? Yes No

v-jefferni on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No