cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
faithdwn
Frequent Visitor

Ungroup collection, patch record, check data source for existing record

Hello, 

 

I am having trouble combining these two formulas that work as expected individually. 

Please help. I need to use this on a On Submit button into a SharePoint list. 

  • If(IsEmpty(Filter('Mobile Equipment Training Requests', Trainee Email=DataCardValue24.Text,'Mobile Equipment'=DataCardValue17.Text,Status.Value="Not Started"||Status. Value="In Progress"))
  • Ungroup(For All(Combined,ForAll(Equip, Patch('Mobile Equipment Training Requests', Defaults('Mobile Equipment Training Requests'),{'Certification Required':DataCardValue31.Selected,'Certification Justification':DataCardValue32.Text,'Request Type':DataCardValue30.Selected,'Area Name':DataCardValue26.Selected,'Specific Group Name':DataCardValue29.Text,Other:DataCardValue35.Text,Other1:DataCardValue36.Text,Shift:DataCardValue34.SelectedItems,Status:DataCardValue4.Selected,'Training Location':DataCardValue25.Selected,'Mobile Equipment':Result,'Trainee Full Name':Combined[@full name],'Trainee Email':Combined[@email]}))),"Value");Navigate(ConfirmScreen,ScreenTransition.None);Clear(Combined);Clear(Equip);Clear(TraineeList);ResetForm(RequestForm)
0 REPLIES 0

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,286)