Unanswered

Atbot - providing multiple choices based on a sharepoint filter

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I am working on a chat bot that will pull granular address information based on whether they reply North, South, East, or west on the question around region.

I then have a sharepoint list which has items and a column called Region which has these values in. What I want to do is then provide a choice back to the user, where if they choose the region the different addresses are displayed as a choice.

Example:

If they reply North

Then it should look at the list and pull back the Address field which will have the North set as the region i.e.

Address 1

Address 2

Address 3

But it only pulls back Address 1 as a choice.

Can anyone help ?

region choice.JPG

Categories:

Building flows

I have the same question (0)

All responses (24)

Answers (1)

abm abm 32,858 Most Valuable Professional on at

Like (0)

Report

Re: Atbot - providing multiple choices based on a sharepoint filter

Hi @Anonymous ,

What's your field type for address field in SharePoint list?

Thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Atbot - providing multiple choices based on a sharepoint filter

Hey,

Region and address are "Single line of text" types.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Atbot - providing multiple choices based on a sharepoint filter

Hi,

I am getting somewhere with this:

But that is still not the result I want, I want a distinct selection of the items in the North region

Was this reply helpful? Yes No
abm abm 32,858 Most Valuable Professional on at

Like (0)

Report

Re: Atbot - providing multiple choices based on a sharepoint filter

Hi @Anonymous

After the Get Items push the results into an array. Before you push the details check the value exists then do not append the array.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Atbot - providing multiple choices based on a sharepoint filter

Still a bit stuck with this:

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Atbot - providing multiple choices based on a sharepoint filter

Hi,

Ok, so I am getting closer.

I now just want to split each address into a choice button.

The flow looks like this now and the result in teams chat is below

Was this reply helpful? Yes No
abm abm 32,858 Most Valuable Professional on at

Like (0)

Report

Re: Atbot - providing multiple choices based on a sharepoint filter

Hi @Anonymous ,

We are nearly there 🙂

Declare a variable called NewLine as string type. Under the value press the Enter Key

Loop your array results and use the flow expression 'concat' with your array elements and NewLine. Store the results in another new string variable called 'useroptions'.

Finally get the ouput of useroptions mapped to Choice Values.

Let me know how it goes.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Atbot - providing multiple choices based on a sharepoint filter

we are so close I can taste it !

Unfortunately, I never got any response out of the "How about one of these" choice section in teams.

Also the list that I get back has to be a distinct list of addresses

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Atbot - providing multiple choices based on a sharepoint filter

The concat says:

concat(variables('Address_Choice'),variables('NewLine'))

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Atbot - providing multiple choices based on a sharepoint filter

Got it working with some further assistance 🙂

What I am trying to do now, is only get distinct values

Was this reply helpful? Yes No