Inserting a list from Excel in Choice Options of Adaptive Card in Teams

[vradley]

Hi, 

I have an Excel Spreadsheet where there is a table. In sheet 1, the Table has many columns. I am interested in inserting all rows of one column as options in a choice of an Adaptive Card. 

I am using "List Rows in a Table" so that the flow knows has the data of what I need to insert in the adaptive card. I would need help inserting the Dynamic content (i.e. all cells in the column called Project Name of the Table in Sheet 1 of my spreadsheet) into the JSON of the adaptive card so that the user can choose, from a drop down, the project they are dealing with. 

Thanks. 

[Yutao · Accepted solution]

Hello @vradley ,

You may need to do a bit string manipulation before composing the Adaptive Card message payload.

Here is my test flow that simulates a similar scenario:

Basically I needed to compose and concatenate each cell data into the right format then insert into the Adaptive Card Message body.

I also needed to remove the trialing comma from the concatenated string to make it a proper JSON blob (the expression I used in the Adaptive Card Message):

substring(variables('choices'),0,sub(length(variables('choices')),1))

Hope this helps!

Yutao

[Rushi_Chandak]

I Have Done the Same, Just Done For The Outlook Adaptive Card. 

But In the result i get Nothing

Anyone Please Suggest How to work on it..