AnswerBun.com

How do you set a Choice field on a PowerApps customized SharePoint list form?

SharePoint Asked by Scott Davis on January 2, 2022

I have a SharePoint list with a choice field. I’m customizing the list form with PowerApps, and I want to have the value of the choice field set via buttons on the form (ie clicking "Submit" will set the choice field to "Submitted", clicking the "Reject" button will set the choice field to "Rejected", etc). I want to use a choice field so that if someone gets to the back-end of the list, they don’t change the field value to something like "Bob" or whatever they accidentally type in to a text field.

When I try to put a formula into the Default on the PowerApps form, it keeps throwing errors:

Formula-If(IsBlank(CurrStatus),ThisItem.Request_Status,CurrStatus)

Issue: Invalid argument type (Text). Expecting a Record value instead

CurrStatus is defined in the OnVisible of my FormScreen1.

What am I doing wrong/missing here?

One Answer

When you set CurrStatus you need to set it as a record type. So, something like this:

UpdateContext({CurrStatus:{Value:"Your Choice Here"})

Alternatively, you could update the above formula like this:

If(IsBlank(CurrStatus),ThisItem.Request_Status,{Value:CurrStatus})

Answered by theChrisKent on January 2, 2022

Add your own answers!

Related Questions

Like the List created and not the list item

2  Asked on January 27, 2021 by antra-sharma

     

SP 2016 – Only TTFB slow

2  Asked on January 16, 2021 by mhouston100

 

Unable to upload to SharePoint Online via VBA

1  Asked on January 11, 2021 by leroy

   

How to Create WF with C#

2  Asked on January 8, 2021 by whatsup

       

Ask a Question

Get help from others!

© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP, SolveDir