Hi @vsolanon ,
Could you please share a bit more about your scenario?
Do you want to change the "Trip Status" in your List 1 based on the "Trip Status" of all destinations with same identifier in your List 2 has been changed?
Could you please share a bit more about the "Trip Status" column? Is it a Choice type column?
Based on the needs that you mentioned, I think there are two ways to achieve your needs -- Using PowerApps app or Power Automate flow.
1. If you want to achieve your needs in PowerApps canvas app
After you changed the "Trip Status" value for a specific destination in your List 2, you need to execute the following formula:
I assume that you use EditForm to edit the "Trip Status" value for a specific destination in your List 2, please set the OnSuccess property of the Edit form (EditForm1) to following:
If(
IsBLank(LookUp('Destinations List', 'Trip Status'.Value <> "Completed" && Identifier = EditForm1.LastSubmit.Identifier)),
Patch(
'TripsList',
LookUp('TripsList', Identifier = EditForm1.LastSubmit.Identifier),
{
'Trip Status': {
Value: "Completed"
}
}
)
);
Back()
Note: I assume that the EditForm1 connects to your "Destinations" list
2. If you want to use Power Automate flow to achieve your needs (I think it would be easier than above solution😞
Within the "Filter array" action, type the following expression:
@and(equals(item()?['Identifier'], triggerBody()?['Identifier']),not(equals(item()?['TripStatus']?['Value'], 'Completed')))
Within the Condition action, Left input field set to following expression:
length(body('Filter_array'))
Within the "Filter array 2" action, type the following expression:
@equals(item()?['Identifier'], triggerBody()?['Identifier'])
Within the "Update item" action, Id field set to following:
item()?['ID']
Title field set to following:
item()?['Title']
Please take a try with above solution, then check if the issue is solved.
Best regards,
