setting a default in a powerapp form for a sharepoint list choice field

Like (0) Share

Report

Posted on 6 Mar 2020 13:48:05 by dmclaughlin

347

I'm trying to set a default for a field in a power app form. Below is the syntax I'm trying. Does anyone else have the right syntax? The field in sharepoint is a choice field with options choose one, yes, no

default2.JPG

All responses (14)

Answers (4)

mdevaney 29,987 Super User 2025 Season 1 on 06 Mar 2020 at 15:34:59

Like (0)

Report

Re: setting a default in a powerapp form for a sharepoint list choice field

@dmclaughlin

I'm not sure why this would be appearing. The code ["Choose one"] is a Table...
dmclaughlin 347 on 06 Mar 2020 at 14:57:10

Like (0)

Report

Re: setting a default in a powerapp form for a sharepoint list choice field

Its not liking the ["Choose one"]
mdevaney 29,987 Super User 2025 Season 1 on 06 Mar 2020 at 14:55:26

Like (0)

Report

Re: setting a default in a powerapp form for a sharepoint list choice field

@dmclaughlin

Which part of the code is underlined in red in the formula bar above?
dmclaughlin 347 on 06 Mar 2020 at 14:53:21

Like (0)

Report

Re: setting a default in a powerapp form for a sharepoint list choice field

Actually it gets error 'invalid argument type , expecting table value.

new2.JPG
mdevaney 29,987 Super User 2025 Season 1 on 06 Mar 2020 at 14:46:47

Like (0)

Report

Re: setting a default in a powerapp form for a sharepoint list choice field

@dmclaughlin

No problem at all. That's what the forums are here for!

If you could accept my post as the solution I would be grateful. Please mark the one that gave the answer 🙂

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
dmclaughlin 347 on 06 Mar 2020 at 14:35:40

Like (0)

Report

Re: setting a default in a powerapp form for a sharepoint list choice field

You have been a life saver
Verified answer

mdevaney 29,987 Super User 2025 Season 1 on 06 Mar 2020 at 14:31:25

Like (0)

Report
Re: setting a default in a powerapp form for a sharepoint list choice field

@dmclaughlin

I gave you some revised instructions earlier in the thread. Here they are again 🙂

Clear the Default property of any code and leave it blank

Then put this code in the DefaultSelectedItems property of the ComboBox

If(IsBlank(DataCardValue68.Selected.Value), ["Choose one"], Parent.Default)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Verified answer

dmclaughlin 347 on 06 Mar 2020 at 14:29:34

Like (0)

Report

Re: setting a default in a powerapp form for a sharepoint list choice field

Not sure what you need to see.. this is a snipit of the datacard and the property default and the formula.

newatt.JPG
mdevaney 29,987 Super User 2025 Season 1 on 06 Mar 2020 at 14:26:52

Like (0)

Report

Re: setting a default in a powerapp form for a sharepoint list choice field

@dmclaughlin

Your screenshot looks the same as before. See my instructions here: https://powerusers.microsoft.com/t5/Building-Power-Apps/setting-a-default-in-a-powerapp-form-for-a-sharepoint-list/m-p/490915/highlight/true#M148483

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
dmclaughlin 347 on 06 Mar 2020 at 14:25:32

Like (0)

Report

Re: setting a default in a powerapp form for a sharepoint list choice field

So that last one didn't work... I attached the property and my formula.. anything look wrong to you?

property.JPG