a table with dynamic column names to output in a virtual agent chatbot as response to query

(0) Share

Report

Posted on by kennethpeng

Hi , Could please your help? I have a case which needed to output a table with dynamic columns' name/title as response to query in virtual agent chatbot, could you guide how to do?

The dynamic column/field name means: a table using 3 month name as the columns' name/title, say, if current month is May, then 'Apr, May, Jun' will be the 3 column's title/names; if current month is Jun, then the 3 columns name/title hope to change to 'May, Jun, Jul', again in Jul, change the 3 columns name/title as 'Jun, July, Aug' .

the data source for the virtual agent chatbot could be a excel file or a sharepoint lists. hope Power Automate to pick up the date source and able to display the table as repones in above dynamic manner. eager to have your response and welcome to email me with Kenneth.peng@sherwin.com.