Rank: Newbie
Groups: Registered
Joined: 3/25/2024(UTC) Posts: 4  Location: Visby Thanks: 1 times
|
Has anyone managed to integrate chat messages from a Teams meeting/webinar into vmix, like what can be done with Zoom?
I really like the Zoom integration and the use of speech bubbles to bring in interaction from web attendees in hybrid conferences is great, but my organisation is trying to leave Zoom altogether (GDPR/Cloud Act reasons).
I think it might be possible by using the MS app Power Automate and use the "When a new message is added to a chat or channel" trigger and an Excel table/new row action, and then add the excel file to databse source manager in vmix, but I haven't had the time to figure it out yet.
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 2/8/2023(UTC) Posts: 24  Thanks: 7 times
Was thanked: 1 time(s) in 1 post(s)
|
Here is a small problem with Excel.
There is no problem putting Teams notifications into an Excel table using PowerAutomatic.
The problem is that this Excel must be located in OneDrive and there is a big question as to how OneDrive will synchronize this Excel file.
From the PowerAutomatic side, everything is super basic.
I quickly checked:
"When a new chat message is added"
"Get message details"
And yes.. I receive all notifications in a specific chat in the powerautomatic environment. Then putting it into Excel is simple.
In my case, I did not go further, because I have several hundred GB on OneDrive and I suspect that OneDrive will synchronize these gigabytes
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 3/25/2024(UTC) Posts: 4 Location: Visby Thanks: 1 times
|
So, I really forgot about testing this. Had some time now and excel won't work because of sync/update problems when using OneDrive. But I got csv working fine. The best way to do it I guess would be to write to a local file, but then you would have to install a local gateway server, so I used the OneDrive for Business commands in Power Automate.  01.jpg (26kb) downloaded 5 time(s).1. Connect the flow to the corresponding meeting chat using "Teams: When a new message is added to a chat or channel" 02.jpg (24kb) downloaded 5 time(s).2. Add a step to the flow using "Teams: Get message details" and reference your meeting chat 3. Create a csv file i your OneDrive folder (ie "chattest.csv"). Edit the file and add "User,Message" as the only content. 03.jpg (25kb) downloaded 5 time(s).4. Add the "OneDrive for Business: Get file content" to the same step as in 2. and reference the previously created file 04.jpg (23kb) downloaded 5 time(s).5. Add the "OneDrive for Business: Update file" to the same step as in 2. and reference the previously created file. As "File Content", add the following dynamic content (write "/" to insert dynamic content): -"Get file content/File content" - hit enter for new row - "Get message details/FromUser/displayName" or similar (as my PowerAutomate is in Swedish) - add a "," - "Get message details/Body/PlainTextContent" or similar I haven't tried it in a live situation yet, but it works on the bench.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
Important Information:
The vMix Forums uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close
