Answered

Append to String Question

(0) Share

Report

Posted on by zw2348

Hello,

I have a flow that's working, but I want to clean up the result. I'm using PVA and PA to look up a name from a SharePoint list and return department/phone number(s).

Question A, is it possible in the Append to String if there is no result, remove the result?

Question B, the result always has the returned phone numbers at the top. How do I remove this?

Categories:

Building flows

desired result.JPG

picture 1.JPG

flow.JPG

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (0)

Report

Hi @zw2348 ,

I made a sample for you.

I created several alt number variables to simulate your sharepoint column values.

@and(not(equals(item(), '')),not(equals(item(), null)))

Phone Number : @{variables('Phone Number')} <br>

range(1,length(body('Filter_array')))

Alt Number@{item()} : @{body('Filter_array')?[add(item(),-1)]} <br>

Best Regards,

Wearsky

Was this reply helpful? Yes No
zw2348 91 on at

Like (0)

Report

@v-xiaochen-msft Thank you for this, I'm having issues expanding this. When there are multiple returns for example searching for Rob, the flow defaults to the first value found. I need help returning all values found. I've been researching but I'm not having much luck.

Was this reply helpful? Yes No