Power Platform Community Forum Thread Details

Hi,

I am very new to PowerApps and have been struggling with coming up with a solution for this issue.

I am having users submit a request form (Form1); each submission will have a system created ID# and will store all of the requested/entered data to a sharepoint list which includes the submitter's name and automatically logs their direct supervisor/manager's name as the Assigned Reviewer. When requests are submitted, a group of approved request reviewers are notified. The approved reviewers go to a gallery, select the request which opens that request in a new form (Form2).

Within Form2, I have a box that displays the submitter, the submitter's supervisor/manager and a combo box that has a list of approved reviewers that can be selected (single selection only) which would be logged as a "Reassigned Reviewer". I want two things to happen:

1) If the Approved Reviewer selects someone from the Reassigned Reviewer combo box, I want that selected value to automatically be stored to the specific record being viewed at the time the change is made. I created a "Save Record" button with an associated OnSelect function of:

Patch('Sharepoint List',Defaults('Sharepoint List'),{Title:'Submitter'.Text,Reassigned_Reviewer:Value(Reassigned Reviewer Combo Box.Selected.Value)})

When I click the button, the Reassigned Reviewer field flips back to being blank (as defaulted), and the data does not patch to the record in the Sharepoint list.

2) When a person is selected from the Reassigned Reviewer combo box, I want a date to be recorded as another visible field (which is also a date field within my sharepoint list) for Reassigned Date. Within this same thought, if another person was selected as Reassigned Reviewer but was taken off and the field were to be left blank, I would want the Reassign Date to also show as blank.

I have been trying to use Patch and Update functions, and in my preview field for item 1 above, it shows the value I'm trying to patch into the sharepoint list record - it's just not actually patching over. The formula does not show any errors so I am not sure what to do at this point.

Can anyone help me and provide any recommendations?

Thank you,

Aaron

Categories:

Building Power Apps