Hi,
I'm building a flow that appends or replaces information between 2 sharepoint lists.
Sharepoint list 1 = LegacyVM
Sharepoint list 2 = VRMaintenance
Sharepoint list 2 is connected to a PowerApps form that captures updates that need to be made to sharepoint list 1.
There are 4 different options (A,B,C and D) of updates to be made.
For this example Option A is to Add/Expand Coverage Area. I'm needing to take the county that was submitted via the powerapps form (captured in list 2) and update list 1 item by adding new county using flow without losing the counties already listed.
Expression in County field = concat(body('Select'),', ',triggerOutputs()?['body/County'])
It ran successfully and updated the field adding Collin county to the end (Travis, Wade, Caldwell are the counties that already existed) but is showing like this:
This is the only way I've gotten this to update the field correctly but I would like for the [" "] to be removed. Is there a different or easier way to achieve this?
@Pstork1 I've seen your responses on posts be extremely helpful and accepted as solutions. I'm wondering if you could assist?
Thank you in advance!