Forum Widgets
Latest Discussions
value changes sheet
Hi everyone, I'm not very expert in office script, I wrote this code but I would like the script to start when a value changes in another sheet. for now I can only activate it via button. Thank you function main(workbook: ExcelScript.Workbook) { // Refresh all data connections workbook.refreshAllDataConnections(); // Row height workbook.getWorksheet("Matrice").getRange("A4").getFormat().setRowHeight(200 * 3 / 4); workbook.getWorksheet("Matrice"). getRange("F5:F1000").getEntireColumn().getFormat().setHorizontalAlignment(ExcelScript.HorizontalAlignment.left); }
Getting Response Body
Hi, I am trying to use the contents of a http response body in my conversation flow. In the data connection element of the health bot, the response variable is named as 'res'. The process is like the data connection element connects to a logic app where user's credentials are verified and then a welcome message with user's name is displayed ("welcome {Firstname}"). I can see the message in logic apps's response body but how do i access this in my bot?
Saving a Variable and displaying it
This should be an easy answer but I can't find any documentation on it. I want to be able to prompt the user and receive an answer. I then want to prompt the user again for another answer and use the variable from the first prompt in my Display Text. Example: My first prompt has "What is your name". I then save that to a variable named varName. I then go to the second Prompt and I want it to say "Hi, Brian, how are you today?". I want to take the varName and put it in the Display Text. How can that be accomplished. I am fairly new to Healthbot/Chatbot so any help is appreciated.Moving a bot from Draft to Production
I would like to know how you handle moving a Healthbot from Draft to Production. I don't know if there is a migration solution within Healthbot. As an example, I have a Healthbot in Production but I want to make some changes to it but I don't want those changes to go into Production until I am ready. The way I believe it works today, is that as soon as I save the Healthbot changes, those changes are in Production. My thought is that I have to create a clone of my production bot and then make changes to the clone. When I am ready for Production, I just change the "Scenario ID"s between the Production one and the clone one. The Clone will now have my production "Scenario ID". I think this will work but just checking with the community if there is a better way.
Health bot Media Qurestion
Hello! I have two questions when using the health bot. 1. I try to use the “getUserMedia” method to access the user’s camera inside the health bot as an action, but that called up an error as “navigator is not defined”. Is this because the Azure Health Bot couldn’t access the getUserMedia API? If that’s the reason, are there any other methods I can use to achieve this requirement? Is there any previous chatbot that has successfully accessed the users’ camera and audio? The core code I try to use in Action: // require to access a video and audio input device from user let constrains = { video:true, audio: true }; let promise = navigator.mediaDevices.getUserMedia(constraints); promise.then(function(mediaStream){ // get video element and play the video var video = document.querySelector("video"); video.srcObject = mediaStream; video.onloadedmetadata = function(e){ video.play(); }; }); // if the require is failed promise.catch(function(err){ console.log(err) }); 2.I try to show back the video that the user uploaded to the bot as an attachment but failed. I try to use a Hero card, but I don't really understand how it works for the card action "playVideo". Can I show the video inside a Hero card or others? What should be the value?LUIS Integration in Health Bot
Hi As provided by microsoft document to integrate LUIS in azure health Bot.(https://docs.microsoft.com/en-us/learn/modules/health-bot-language-understanding/6-integrate-luis-into-the-azure-health-bot) They have only provided a provision to test in web chat. But how to integrate the luis model created in our custom scenario. please provide Insert LU functionality in detail to integrate LUIS into scenario. Even LU functionality is added to scenario and interrupting is allowed in configuration, its not recognising the intent and breaking the flow. Instead it is working according to flow designed in scenario.Unable to handoff user to live agent from Microsoft Health Bot Service to Microsoft Teams
Unable to handoff user to live agent from Microsoft Health Bot Service to Microsoft Teams Hi, I had configured the health for Microsoft Teams bot according to this linkshttps://docs.microsoft.com/en-us/healthbot/handoff,https://docs.microsoft.com/en-us/healthbot/handoff-teams and i am unable to log in as an agent on Microsoft Teams. and I am gettingHandoff scenario error - Check Microsoft Teams handoff configuration or parameters passed to the agent login scenariowhen I login through my team's app. please check the attachment Any response from your side with be appreciated.
