How to update a share point choice field using specific conditions

(0) Share

Report

Posted on by patty789

250

Hi,

I have a SharePoint list, and i am using a PowerApp using individual controls to write to the list not a form. My question how can i get a choice field to write to SharePoint based on different conditions from the PowerApps? For instance if the Manger is a Divisional President then "Approve"..... One issue that i am having is that when i add a combo box to display the choice filed it does not show up from the column ApprovalStatus on my powerapp i have to bring it down as a form. Not sure why??

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

MarvinBangert 1,924 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @patty789
can you add some screenshots to this post and more information about your formulas like how is your combo box designed, what is within the combo box, etc.?

Thanks in advance

Regards
Marvin

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @patty789 ,

Do you want to use a combo box to display choice filed and set its default selected value based on your manager's position?

Could you tell me how do you get the Manger's position data? do you have a list stored the information of manager's position? or the job Title of manager in office365 profile?

I assume that you mean current user's manager's position in office365 profile.

If so, try this:

1)connect the app with this sharepoint list and Office365 Users

2)insert combo box

set the combo box's Items:

Choices(listname.choicefieldname)

//please replace with your listname and choice fieldname

3)set the combo box's DefaultSelectedItems:

If(Office365Users.ManagerV2(User().Email).jobTitle="Divisional President", Table({Value:Approve}), )

Then if current user's Manger's jobTitle is"Divisional President", the combo box will display "Approve" by default.

If you want to update this choice field by using this combo box, you just need to use formula like this:

Patch(..,....,{choicefieldname:ComboBox1.Selected})

Best regards,

Was this reply helpful? Yes No
patty789 250 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-yutliu-msft the data i am getting it from a sharepoint list. On a column name PositionTitle

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @patty789 ,

Could you show me the structure of the list that includes PositionTitle column and the fields' data type?

I need to know how to filter the Manger's PositionTitle.

Does this field belong to the same list with Approve field?

I assume that

1)you have a list named list1, with columns: people(person type), PositionTitle( text type)

2) have a list named list2, with columns: Approvefield( single choice type)

3)how to set the combo box:

set the combo box's Items:

Choices(listname.choicefieldname)

set the combo box's DefaultSelectedItems:

If( LookUp(list1,User().Email in peoplefield.Email,PositionTitle)="Divisional President", {Value:Approve}, )

//if current user's position tile is Divisional President in list1, then this combo box will display Approve automatically.

If you want to update this choice field by using this combo box, you just need to use formula like this:

Patch(..,....,{choicefieldname:ComboBox1.Selected})

Best regards,

Was this reply helpful? Yes No