Activity
Mon
Wed
Fri
Sun
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
What is this?
Less
More

Memberships

Learn Power Apps

Public • 1.1k • Free

19 contributions to Learn Power Apps
Send message to Teams Chat
I am trying to send a chat message to a Teams Chat from Power Apps. The goal is to when somebody submits a form, it notifies a group of people via Teams Chat that a new form has been submitted. I've found some stuff online, but I keep running into errors. Has anybody done anything like this?
1
6
New comment Mar 8
1 like • Mar 5
@Andrew Davis This works for me. 1) Insert two dropdown's (I'm assuming these are named DropDown1 and Dropdown2) 2) In Dropdown1, enter MicrosoftTeams.GetAllTeams().value In the properties, change the Value to "displayName" 3) In Dropdown2, enter MicrosoftTeams.GetChannelsForGroup(Dropdown1.Selected.id).value 4) In the properties of both, change the Value to "displayName" to show the user friendly name for the Team/Channel 5) On your submit form button add this code , MicrosoftTeams.PostMessageToChannelV3( Dropdown1.Selected.id, // returns the ID number of the Team. You could alway manually enter the ID enclosed in "" as mention below. Dropdown1_1.Selected.id, // returns the ID number for the channel { content: "This is the body of the message", contentType: "html"// type 'text' or 'html' here }, {subject: "Message Submitted From PowerApps Form"} ); Once submitted, this will post a message to the selected Team / Channel. Replace "This is the body of the message" with whatever message you want to display in the message body and "Message Submitted From PowerApps Form" with the Subject you want to use. Obviously this is dependant on selecting the correct Team and Channel from drop downs. If you don't want this to be available to the users to change, you could set these and then hide them so the user only references them. Alternatively, add the drop downs to a developer screen, and use a text label to pull the id using Dropdown1.Selected.id or Dropdown2.Selected.id to retrieve the id of the Team / Channel. You could then replace Dropdown1.Selected.id and Dropdown2.Selected.id with the label text (ensuring it is enclosed in ""). Both scenarios work for me.
0 likes • Mar 6
@Andrew Davis I have a solution that seems to work and posts a message to one of my chats. I've uploaded a PDF which shows these steps but with matching screenshots. 1) Add a dropdown (assumed to be "DropDown1") 2) Update the Items function with MicrosoftTeams.GetChats("all","all").value 3) In the Drop down properties, change the "Value" to be "createdDateTime". I use this as it is the best way to identify the chat as you can find the Date/Time that the chat was created within Teams (the first message Date/Time).These dates will be in your drop down. Alternatively, use "lastUpdatedDateTime" to find your chat in the drop down. I found this worked initially but subsequent messages that update the chat did not get reflected in my drop down, with the Date/Time remaining as it was in the drop down when I first used the drop down I therefore decided to use the createdDateTime as my drop down value 4) I then created a Flow within Power Apps by choosing Power Automate from the left menu and selecting "Add Flow" 5) Click on PowerApps(V2) and add two Parameters (or Inputs) depending on if you are using the New or Classic version of Power Automate. Power Apps tend to send you in using the classic, but this may change in future releases. I’ll therefore continue to show the classic screens. If you open the flow directly in Power Automate, it will use the New layout. I’ve called my inouts “ChatID” and “Message”. I will use the “ChatID” in Power Apps to pull in the ID from DropDown1 in step 1. The message will also be retrieved from within Power Apps, either hard coded or from a control in your app. 6) Add another step/action and search for “post message in a chat or channel” 7) There will initially be two sections to complete, Post As, Post in. 8) In the Post as, select “Flow bot”. In the Post in select “Group Chat”. You will then be given addition sections 9) In Group chat select “Enter Custom Value” and then add “ChatID” (the first input created in Step 4) from the Dynamic Content.
Signature Capture
Are there any guides or helps to show how to capture signatures within power apps?
1
2
New comment Mar 5
0 likes • Mar 5
@Steve Garbett Check out these resources This is the MS Documentation in it https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/controls/control-pen-input but, check out Matthew Devaney's guide https://www.matthewdevaney.com/capture-a-signature-with-power-apps-pen-input-and-save-to-sharepoint/ and also Shane Young's YouTube video on the subject https://www.youtube.com/watch?v=RFZfvTuDmP0 Both are really useful.
Please help me give a warm welcome to Tolu Victor!
Please help me give a warm welcome for @Tolu Victor joining the community! I spotted his video content on YouTube and was quite impressed! Welcome!! 😎🎉
18
38
New comment Mar 6
3 likes • Feb 28
@Tolu Victor welcome. I’ve just subscribed to your YouTube channel. Looking forward to checking out your video’s.
Char Function / Basic Encryption
I have a label named "lblOutput". It displays the first character of the txtInput1. If this is "A", i need to find the decimal value of "A" in ASCII. e.g if my label text was Char(65), it would return "A". I'm therefore looking for a way to look for the value 65 if my label output is A, 66 if the output is B etc. The reason is i want to adapt the the solution @Kurt Larson provided in PPC for Jan 27th 2024 to sequence a text input, find the decimal number of each letter, add 4 to that number and then output the revision e.g if text input was "ABCD", the ASCII decimal for the the string would be 65666768. I want to change this to 69707172 so that the output would then be EFGH. I could then reverse the process and convert EFGH back into ABCD. The purpose is a very basic encryption of the letters so they can be stored in the Sharepoint source table without being an obvious password. I've added 5 to the decimal value to make my explanation simple but i could add more or even deduct values in my final solution. Is this possible?
2
15
New comment Feb 27
0 likes • Feb 26
@Kurt Larson great video. I’ll need to watch it a couple of times and work it through to get my head round it. I think it’s the With function that has me confused so will also need research it. I had started using Sequence on the password to encrypt. Never thought of storing the decryption key in the encryption also. I was going to store it in another column in my user table, but after it had been encrypted using the ASCII collection to return the ascii character. My solution probably won’t be as pretty as yours but you’ve got to start somewhere 😅 Will keep an eye out for the login part and With videos.
1 like • Feb 27
@Kurt Larson Ok, I'll have a look as soon as I get chance. Yes, I'm familiar with UpdateContext(). So With() is just a temporary local variable that is only available whilst the current code is being processed?
PPC #2004-02-17 entitled "Imposter Syndrome" 🙃🙂
Thanks Kurt and Darren for your reassuring insight provided under this topic. I especially found value in the piece towards the end, where Kurt says: "So if you guys have some IT people saying that this (i.e. Power Apps) is a toy language, you know... but actually, if your program reads a record, writes a record and processes that record in a timely fashion, then you did your job. And those people that are trying to work with us, they're trying to do the same thing, but they gotta work at it a lot harder. In fact, I would I would suggest that we're going 80% faster than most programmers are. We're re running probably 80% faster than your traditional programming language that has to be compiled, where you gotta deal with front end software, you gotta deal with servers and you gotta deal with all the middleware in between. You gotta deal with GitHub and all these things. There's just so much firmware and stuff that you gotta worry about, whereas with Power Apps it's doing it all at once." I personally don't come from a formally trained, traditional software background so I didn't actually realize that the real power in the Power Platform is the speed with which developers can design and compile a solution. And it it works, and people are using it, then it's just as good (or as effective) as what developers are coding from scratch with C++ or whatever. I still hold those types of developers in high esteem though, but I feel less inadequate now. So helpful guys - thanks. P.S. I also enjoyed the introduction to Power BI you posted on your YouTube channel recently. Was encouraging to see it's not just me who's barely touched this tool until now. 😅
4
4
New comment Feb 24
2 likes • Feb 24
@Wendy Meyer well said. I totally agree. It’s given me the opportunity to develop my own solutions rather than making do with an out of the box or bespoke solution that could cost a lot of money.
1-10 of 19
Nick McDermott
3
26points to level up
@nick-mcdermott-8562
I’m an Accountant by trade but have also worked in IT all my career. Historically used MS Access but have now discovered Power Apps.

Active 3d ago
Joined Jul 7, 2023
ISFJ
Teesside, United Kingdom
powered by