Unanswered

How to choose someone at random from a list?

(1) Share

Report

Posted on by ET16

I'm trying to build an automate feature where an email comes into a shared inbox, and then what happens is the system takes the email from that shared inbox and essentially forwards it to a random person from a list of a group chat in teams. I get to creating an array and that makes sense, and then I build a compose function to get it to choose someone at random, but the issue is, it never gets past the array function where it chooses someone at random and i've been stuck here for hours.

This is basically how the Array should look in my view: email comes to shared inbox > get list of team members > create array and a compose function to get someone at random > forward that email to their inbox. But again, i can not get past the array function to pick someone at random and then move forward. Any help would be appreciated.

Categories:

Using connectors

I have the same question (0)

All responses (9)

Answers (0)

HarlyTran 12 on at

Like (0)

Report
Copy link

Link copied!

Hello @ET16 ,
Try my solution
Input for compose:
- rand(0,length(outputs('List_members')?['body/value'])) --> This will be return a random number
Input for compose 1:
- outputs('List_members')?['body/value'][int(outputs('Compose'))] --> This will be return a json includes member name
Then input and schema for Parse JSON action:
- Input: outputs("compose_1")
- Schema:
{
"type": "object",
"properties": {
"@@odata.type": {
"type": "string"
},
"id": {
"type": "string"
},
"roles": {
"type": "array",
"items": {
"type": "string"
}
},
"displayName": {
"type": "string"
},
"visibleHistoryStartDateTime": {
"type": "string"
},
"userId": {
"type": "string"
},
"email": {
"type": "string"
},
"tenantId": {
"type": "string"
}
}
}

Then custom your adaptive card and send it in team chat

Was this reply helpful? Yes No
ET16 6 on at

Like (0)

Report
Copy link

Link copied!

i'm I'm fairly sure i'm skipping a step here or messing itup, but this is what I get. I think you are wanting me to generate a schema but i don't know where to do that

Was this reply helpful? Yes No
HarlyTran 12 on at

Like (0)

Report
Copy link

Link copied!

Hello @ET16, you just only paste this in scheme section:
{
  "type": "object",
  "properties": {
  "@@odata.type": {
  "type": "string"
},
  "id": {
  "type": "string"
},
  "roles": {
  "type": "array",
  "items": {
  "type": "string"
}
},
  "displayName": {
  "type": "string"
},
  "visibleHistoryStartDateTime": {
  "type": "string"
},
  "userId": {
  "type": "string"
},
  "email": {
  "type": "string"
},
  "tenantId": {
  "type": "string"
}
}
}

don't need for the:
- Input: outputs("compose_1")
- Schema:

if you want to generate your own scheme, i show u later

Was this reply helpful? Yes No
HarlyTran 12 on at

Like (0)

Report
Copy link

Link copied!

Hello @ET16 , just paste this in the scheme section:
{
  "type": "object",
  "properties": {
  "@@odata.type": {
  "type": "string"
},
  "id": {
  "type": "string"
},
  "roles": {
  "type": "array",
  "items": {
  "type": "string"
}
},
  "displayName": {
  "type": "string"
},
  "visibleHistoryStartDateTime": {
  "type": "string"
},
  "userId": {
  "type": "string"
},
  "email": {
  "type": "string"
},
  "tenantId": {
  "type": "string"
}
}
}

Was this reply helpful? Yes No
HarlyTran 12 on at

Like (0)

Report
Copy link

Link copied!

Hello, you just need to paste this in schema section:
{
  "type": "object",
  "properties": {
  "@@odata.type": {
  "type": "string"
},
  "id": {
  "type": "string"
},
  "roles": {
  "type": "array",
  "items": {
  "type": "string"
}
},
  "displayName": {
  "type": "string"
},
  "visibleHistoryStartDateTime": {
  "type": "string"
},
  "userId": {
  "type": "string"
},
  "email": {
  "type": "string"
},
  "tenantId": {
  "type": "string"
}
}
}

Was this reply helpful? Yes No
HarlyTran 12 on at

Like (0)

Report
Copy link

Link copied!

Hello, you just need to paste this in schema section:
{
  "type": "object",
  "properties": {
  "@@odata.type": {
  "type": "string"
},
  "id": {
  "type": "string"
},
  "roles": {
  "type": "array",
  "items": {
  "type": "string"
}
},
  "displayName": {
  "type": "string"
},
  "visibleHistoryStartDateTime": {
  "type": "string"
},
  "userId": {
  "type": "string"
},
  "email": {
  "type": "string"
},
  "tenantId": {
  "type": "string"
}
}
}

Was this reply helpful? Yes No
ET16 6 on at

Like (0)

Report
Copy link

Link copied!

First, thank you so much for helping, it looks like I got the JSON to work ,but here for the card. I don't know what i need to put "post in" here. Do I put the whole team chat? or do I have to pick an output from a previous action? I tried to run it by picking a specific team and also a specific output, and it gives me an error both times

Was this reply helpful? Yes No
HarlyTran 12 on at

Like (0)

Report
Copy link

Link copied!

You can create a Adaptive card, you can check the follow instruction in this link
And the name of random member you can see in the picture below and insert to everywhere you want in json of adaptive card:

And with "Post in" you can choose "Channel" or "Group chat", just make sure that is created first in team:
I just created a "CREATE TEAM CHAT" after using a flow

Was this reply helpful? Yes No
ET16 6 on at

Like (0)

Report
Copy link

Link copied!

I think what this is doing is essentially choosing a random person from in a team chat, but then sending the message in that team chat. I want it to send a direct message, or even an email.

Was this reply helpful? Yes No