web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Need to select approve...

Power Apps

Answered

Need to select approvers depending on the information in gallery

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Please, help me. I have a gallery . There are two fields in this gallery- recommended discount and requested discount, and if the second one exceeds the first one, the third field "Approval" is filled with text "Approval is required". Depending on this information i need to select an approver. If field is blank- no approver needed, if "Approval required"- need to take approver from SP list. Please, advise, how to fix this task.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to fill in the third field based on the first two fields, and if the third field display "Approval is required", you need to choose Approval for this item?

I've made a similar test for your reference:

1)insert a gallery, display two fields: recommended discount and requested discount

2)insert a label inside the gallery, set the label's Text:

If(ThisItem.'recommended discount '<ThisItem.'requested discount',"Approval required","")

3)insert a combo box inside the gallery to choose approver (approver is a person field in my list)

Set the combo box's Visible:

If(Label1.Text="Approval required",true,false)

Set the combo box's Items:

Choices(test1031.approver)

//test1031 is my list name, you could replace it

4)insert a button inside the gallery to submit the data of Approval and approver field.

Set the button's OnSelect:

Patch(test1031,ThisItem,{Approval:Label1.Text,approver:ComboBox1.Selected}) //if approver is a single person field
Patch(test1031,ThisItem,{Approval:Label1.Text,approver:ComboBox1.SelectedItems}) //if approver is a multiple person field

Best regards,

Was this reply helpful? Yes No

Join the conversation