Formula is replacing the only the first record

[Nayana_MS]

im using this formula in power apps to remove certain column records but its making the first record as blank and its not checking for the other existing records the formula is as below 

Remove(ResourceAllocation_ProjectTables,Gallery1.Selected);

Patch(

    ResourceAllocation_AvailableResources,

    LookUp(ResourceAllocation_AvailableResources,Project1UniqueId=ProjectIdLabel.Text),

    { Project1UniqueId: Blank(),Allocation1:Blank(),'P1 End Date':Blank(),'Project1 Name':Blank(),'Total Engagements this month':Blank(),'P1 Start Date':Blank() ,'Project1 Category':Blank(),'P1 Reporting Manager':Blank(),'Allocation1 Percentage':Blank(),'TL1 MailId':Blank()}

);

Patch(

    ResourceAllocation_AvailableResources,

    LookUp(ResourceAllocation_AvailableResources,Project2UniqueId=ProjectIdLabel.Text),

    { Project2UniqueId: Blank(),Allocation2:Blank(),'P2 End Date':Blank(),'Project2 Name':Blank(),'Total Engagements this month':Blank(),'P2 Start Date':Blank() ,'Project2 Category':Blank(),'P2Reporting Manager':Blank(),'Allocation2 Percentage':Blank(),'TL2 MailId':Blank()}

);

Thank You

[Prabhakar_S]

Hi @Nayana_MS ,

The issue might be related to how the LookUp function is used to find the record to be updated in the "ResourceAllocation_AvailableResources" table. Since LookUp returns only the first record that matches the criteria, it will update only the first matching record. To update all the records that match the criteria, you should use the Filter function instead of LookUp. 

Try using Filter instead of Lookup,

Remove(ResourceAllocation_ProjectTables, Gallery1.Selected);

// Update records in ResourceAllocation_AvailableResources table where Project1UniqueId matches
Patch(
ResourceAllocation_AvailableResources,
Filter(ResourceAllocation_AvailableResources, Project1UniqueId = ProjectIdLabel.Text),
{
Project1UniqueId: Blank(),
Allocation1: Blank(),
'P1 End Date': Blank(),
'Project1 Name': Blank(),
'Total Engagements this month': Blank(),
'P1 Start Date': Blank(),
'Project1 Category': Blank(),
'P1 Reporting Manager': Blank(),
'Allocation1 Percentage': Blank(),
'TL1 MailId': Blank()
}
);

// Update records in ResourceAllocation_AvailableResources table where Project2UniqueId matches
Patch(
ResourceAllocation_AvailableResources,
Filter(ResourceAllocation_AvailableResources, Project2UniqueId = ProjectIdLabel.Text),
{
Project2UniqueId: Blank(),
Allocation2: Blank(),
'P2 End Date': Blank(),
'Project2 Name': Blank(),
'Total Engagements this month': Blank(),
'P2 Start Date': Blank(),
'Project2 Category': Blank(),
'P2Reporting Manager': Blank(),
'Allocation2 Percentage': Blank(),
'TL2 MailId': Blank()
}
);

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

[Nayana_MS]

 @Prabhakar_S  Thanks for the reply but I'm getting error like below

[Prabhakar_S]

To resolve this issue, you can use a combination of Filter and ForAll functions to iterate through the records that match the condition and then update each record individually with the Patch function. 

Give it a try,

Remove(ResourceAllocation_ProjectTables, Gallery1.Selected);

// Update records in ResourceAllocation_AvailableResources table where Project1UniqueId matches
ForAll(
Filter(ResourceAllocation_AvailableResources, Project1UniqueId = ProjectIdLabel.Text),
Patch(
ResourceAllocation_AvailableResources,
LookUp(ResourceAllocation_AvailableResources, Project1UniqueId = ProjectIdLabel.Text), // Look up the record to be updated
{
Project1UniqueId: Blank(),
Allocation1: Blank(),
'P1 End Date': Blank(),
'Project1 Name': Blank(),
'Total Engagements this month': Blank(),
'P1 Start Date': Blank(),
'Project1 Category': Blank(),
'P1 Reporting Manager': Blank(),
'Allocation1 Percentage': Blank(),
'TL1 MailId': Blank()
}
)
);

// Update records in ResourceAllocation_AvailableResources table where Project2UniqueId matches
ForAll(
Filter(ResourceAllocation_AvailableResources, Project2UniqueId = ProjectIdLabel.Text),
Patch(
ResourceAllocation_AvailableResources,
LookUp(ResourceAllocation_AvailableResources, Project2UniqueId = ProjectIdLabel.Text), // Look up the record to be updated
{
Project2UniqueId: Blank(),
Allocation2: Blank(),
'P2 End Date': Blank(),
'Project2 Name': Blank(),
'Total Engagements this month': Blank(),
'P2 Start Date': Blank(),
'Project2 Category': Blank(),
'P2Reporting Manager': Blank(),
'Allocation2 Percentage': Blank(),
'TL2 MailId': Blank()
}
)
);

The ForAll function is used to iterate through the records returned by the Filter function, and the Patch function is called inside the ForAll loop to update each record individually. This approach ensures that all records that match the condition are updated, rather than just the first one.

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

[Nayana_MS]

@Prabhakar_S 

getting error like this now

[Prabhakar_S · Accepted solution]

I have tried using the UpdateIf() Function and it works fine from my end. Also, In this SP List if you want to update the value of the Title Column as Blank() instead give it as "".

Remove(ResourceAllocation_ProjectTables, Gallery1.Selected);

// Update records in ResourceAllocation_AvailableResources table where Project1UniqueId matches
UpdateIf(
ResourceAllocation_AvailableResources, Project1UniqueId = ProjectIdLabel.Text, // Look up the record to be updated
{
Project1UniqueId: Blank() or "", //If this is a Title column in Sharepoint instead of giving Blank() give it as ""
Allocation1: Blank(),
'P1 End Date': Blank(),
'Project1 Name': Blank(),
'Total Engagements this month': Blank(),
'P1 Start Date': Blank(),
'Project1 Category': Blank(),
'P1 Reporting Manager': Blank(),
'Allocation1 Percentage': Blank(),
'TL1 MailId': Blank()
}
);

// Update records in ResourceAllocation_AvailableResources table where Project2UniqueId matches
UpdateIf(
ResourceAllocation_AvailableResources, Project2UniqueId = ProjectIdLabel.Text, // Look up the record to be updated
{
Project2UniqueId: Blank() or "",  //If this is a Title column in Sharepoint instead of giving Blank() give it as ""
Allocation2: Blank(),
'P2 End Date': Blank(),
'Project2 Name': Blank(),
'Total Engagements this month': Blank(),
'P2 Start Date': Blank(),
'Project2 Category': Blank(),
'P2Reporting Manager': Blank(),
'Allocation2 Percentage': Blank(),
'TL2 MailId': Blank()
}
);

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

[Nayana_MS]

@Prabhakar_S Thank you its working

its working for Blank() for me ,I checked with Blank()

[Nayana_MS]

HI  @Prabhakar_S 

Remove(ResourceAllocation_ProjectTables, Gallery1.Selected);

UpdateIf(

ResourceAllocation_AvailableResources, Project1UniqueId = Gallery1.Selected.ProjectUniqueId,

{

Project1UniqueId: " ",

Allocation1: " ",

'P1 End Date': " ",

'Project1 Name':" ",

'Total Engagements this month': " " ,

'P1 Start Date': " " ,

'Project1 Category': " " ,

'P1 Reporting Manager': " ",

'Allocation1 Percentage': " ",

'TL1 MailId': " "

}

);

UpdateIf(

ResourceAllocation_AvailableResources, Project2UniqueId = Gallery1.Selected.ProjectUniqueId,

{

Project2UniqueId: " ",

Allocation2: " ",

'P2 End Date': " ",

'Project2 Name': " ",

'Total Engagements this month': " ",

'P2 Start Date': " ",

'Project2 Category': " ",

'P2Reporting Manager': " ",

'Allocation2 Percentage': " ",

'TL2 MailId': " "

}

);

its works propertly for first update if 2 person is allocated for project1 but when i allocate 1 person to second project its not working 

Thank you