Answered

PowerApp - Patch Urgent Help, pls!!

(1) Share

Report

Posted on by JValencia50

Hi Everyone,

I am seeking urgent help on a formula for power app. I am attempting to have all fields patch to my SharePoint data list (working but not fully) I am stuck on my combo box field. I select three names on the combo box and they get separated but the same name populates. how can i fix this? Here is the format I've used and an example below;

ForAll(

ClientNameComboBoxGS.SelectedItems,

Patch(

'Group Sign In Sheet',

Defaults('Group Sign In Sheet'),

{

'Client Name': ClientNameComboBoxGS.Selected.ClientName,

Group: GroupNameText.Text,

FacilitatorName: FacOneText.Text,

Location: LocationText.Text,

Date: DatePicker1_1.SelectedDate,

Start_Time: StartDropdown_1.Selected.Value,

End_Time: EndDropdown_1.Selected.Value,

TotalTime: TotalTimeLabel_1.Text,

Facilitator_Date: DatePicker1_1.SelectedDate

}

)

The name is the issue because this what I selected in the combo box and what saved to SharePoint

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

narayan225 2,547 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@JValencia50

So you want to create a new record for each selected items in a combo box? Or do you want to create one record?

Cheers!
JValencia50 28 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Narayan, Thanks for the response. I want to create a new record for each selected items in the combo box.

Thank you
Verified answer

narayan225 2,547 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@JValencia50

In that case, in your formula, use ThisRecord function instead.

ForAll( ClientNameComboBoxGS.SelectedItems, Patch( 'Group Sign In Sheet', Defaults('Group Sign In Sheet'), { 'Client Name': ThisRecord.ClientName, Group: GroupNameText.Text, FacilitatorName: FacOneText.Text, Location: LocationText.Text, Date: DatePicker1_1.SelectedDate, Start_Time: StartDropdown_1.Selected.Value, End_Time: EndDropdown_1.Selected.Value, TotalTime: TotalTimeLabel_1.Text, Facilitator_Date: DatePicker1_1.SelectedDate } ) )
I have replaced ClientNameComboBoxGS.Selected.ClientName to ThisRecord.ClientName as this will provide dynamic value when you run the ForAll loop.

Cheers!