You’re offline. This is a read only version of the page.
Announcements
31
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!
The problem is that the Data Select output is an array, not a string. The easiest fix will be to do a Join on the output of the select and a comma. Like this
Share
Report
All responses (
Answers (
join(body('Select'),',')Use that in place of the body('Select') in your Concat. The join will output a comma delimited string that you can concatenate with the new entry.
