Unanswered

Power app using Sharepoint choice column set a default value

(0) Share

Report

Posted on by CU02080621-5

Hi All,

I have a power app that is used to fill in a sharepoint list and columns, there is a column called User_Status which is a choice column and has 3 values in it.

During the input of the values using the power app, I want the Power App to default to one of the value's namely "In Progress" but I'm unable to do this, I'm using this value which should work according to a tutorial but it just gives me errors.

Can Anyone help?

If(Parent.Mode = FormMode.New,{Value: "In progress"}, ThisItem.Priority

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
Copy link

Link copied!
hi @Lumina
Your formula seems almost correct, but it needs slight adjustments. The DefaultSelectedItems property expects a table, so you should wrap the value in a table using curly braces {}

If( Parent.Mode = FormMode.New, [{Value: "In Progress"}], ThisItem.User_Status )

Was this reply helpful? Yes No
CU02080621-5 on at

Like (0)

Report
Copy link

Link copied!

It's still giving me errors on the '(' and ',' like always
I goddamn hate power apps, always giving me the vague errors....
It says there are not the right amount of arguments, 1 received, 2 or more expected?

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Steps to Implement:
Select the Dropdown or ComboBox inside the Data Card for the User_Status field.
Go to the Properties pane on the right.
Set the DefaultSelectedItems property to the formula above.
replace , with ; by your language preference

Was this reply helpful? Yes No
CU02080621-5 on at

Like (0)

Report
Copy link

Link copied!

Where should I change this? My ListDelimiter is already at ;

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
Copy link

Link copied!

can you share the screenshot where you are using this code and what error you are getting

Was this reply helpful? Yes No
CU02080621-5 on at

Like (0)

Report
Copy link

Link copied!

Sorry incomplete, it's set to the Main Datacard of User_Status

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
Copy link

Link copied!
If( Parent.Mode = FormMode.New; [{Value: "In Progress"}]; ThisItem.User_Status )

Was this reply helpful? Yes No