cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Adding information from Sharepoint list to textbox

Hi,

 

I am trying to create an E-Mail template that gets information from powerapp or Sharepoint list that also changes according to dates.

I am trying to get this information in the powerapp or from the sharepoint list as the powerapp gets this information from the list as well.

Sandkastnrocker_0-1632419186270.png

The information with date and title comes from "Wochenplan" to "E-Mail"

Sandkastnrocker_1-1632419225696.png

and it should be added in either Textinput or Richtext or HTML. It should grab the information and add the date in one area (XXXX) and the titel in the other (XXXXX). 

Sandkastnrocker_2-1632419287629.png

Also it should know if I click the Mail button on either of the three topics which title to grab and which date as it is different each week and for each topic.

Sandkastnrocker_3-1632419583836.png

I dont even know if it is possible to include information like that but I am afraid it seems to be really complicated at least for a beginner like me.

 

If you have any ideas it would be highly appreciated. Thank you

 

1 ACCEPTED SOLUTION

Accepted Solutions
BCLS776
Super User
Super User

I made a demonstration app to show how I would set it up:

Animation.gif

 I suggest putting only:

Select(Parent);
Navigate('E-mail');

In your button to change screens, and then referencing the Selected item from the gallery after that.

 

I don't quite understand your need for 3 mail buttons - are there three different kinds of emails you want to send?

 

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

View solution in original post

13 REPLIES 13
BCLS776
Super User
Super User

To give you an exact answer, we need to know more about the columns in your Sharepoint list and how you would use a date to choose the right record.

 

Chances are, you will use the LookUp() function to find a record in your list that matches the given criteria. Example:

// put this in the Text property of a label and adjust your column/list names to fit

LookUp(mySPList, ID = 1, Title)

// This looks for the first record in mySPList with an ID = 1, and then returns the value in the Title column for that record

// ID = 1 could be replaced by ID = Label1.Text to reference a control instead

If you can tell us more info about your situation, we can help you build a LookUp that suits your case.

 

Hope that helps,

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
Anonymous
Not applicable

Hi,

 

I use a Sharepoint list with a column "Date and Time" with standard formatting.

Sandkastnrocker_0-1632471417418.png

In Powerapps Date/Time is a Textbox which uses: 

ThisItem.Startzeit

 

The Gallery with the date/time has this information in Items:

SortByColumns(
Filter(Ausbildungsplan;Startzeit>=Today()&& Startzeit<=DateAdd(Today();42))
;"Startzeit")

 

I changed the Textbox to "Textinput1" as it loads a lot faster than Richtext and you dont need any fancy writing options. Most of the time you will just send the Mail as it is, preferably already with the Date/Time information so you dont have to type it in yourself.

 

The Mail button has the following information:

Notify("E-Mail wurde verschickt";NotificationType.Success;3000) &
Office365Outlook.SendEmailV2("ausbildung@feuerwehr-langenselbold.de";"Ich möchte ein Ausbildungsthema übernehmen";TextInput1) &
Navigate(Wochenplan)

Sandkastnrocker_1-1632471848868.png

I hope I included all necessary information.

BCLS776
Super User
Super User

OK, it sounds to me like you want to populate the text box with a default message, which can be edited and then used to send as the body of the email message, right?

 

If so, try some code like this in the Default property of the text box:

LookUp(Ausbildungsplan;
    Startzeit <= Now()&& Endzeit >= Now(); // This is the matching condition
    'HT_Titel' // This is the column to find the return value
);;

Let us know how that works for you,

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
Anonymous
Not applicable

Thank you Bryan.

 

So far it works with the current date which is great. Unfortunately that seems to be only the start and my description of what I am trying to do doesnt seem to be good enough so I aplogize and will try once more to try to describe what I am trying to do. So dont worry if it might be too complicated or I am not able to fully describe what I need so you can help out. If it is so, than I will just go with the first idea of mine and let the user fill in the data.

So what am I trying to do:

I have a training schedule for one day each week with three different topics each week. My App always shows the next 42 days so usually 6 weeks and 6 different training plans.

There are some weeks and topics displayed without a trainer. I am trying to give the users the opportunity to click on a Mail symbol for a topic that is missing the trainer and send an E-Mail that they want to be the trainer for that day. So the topic and the date is always different, sometimes there are one, two or three topics without trainer for the same date. 

 

I was trying to find a solution on how the app knows that If you click on topic, for example "Zug-/Objektübung extern" with date "12.10.2021" that it automatically ads this topic name and the date and not any other week or topic. Or you click on the mail symbol in "Modul 1" with the topic name "TH-VU LKW" It should grab that topic name and the date "28.09.2021" and not maybe "12.10.2021"

How do I let the powerapp know that If I click on a mail that it picks the corresponding date and topic?

 

To show what I have. It is a vertical gallery with three topics that is linked with the Sahrepoint list and always displays the next 42day/6weeks in the list "Ausbildungsplan" and copies all the information from there into the fields.

Sandkastnrocker_2-1632497438442.png

My solution so far is that I just added a mail symbol that navigates to a new screen and added the textinput and mail confirmation button but of course that is the same symbol for every topic in a week even though its three different topics.

 

So maybe I was able to clarify a bit better what I am trying to do. It is always really hard for me to describe what I am trying to do especially in a foreign language.

Anonymous
Not applicable

Just to add: I was able to create the textbox exactly how I want it to look like with the information through lookup. That is already a big step.

 

"Ich möchte gerne die Ausbildung für das Thema: " & Char(10) &
LookUp(Ausbildungsplan;Startzeit>=Today()&& Endzeit>=Now();'HT Titel'.Value & Char(10) &
"am " & Char(10) &
Startzeit) & Char(10) &
"übernehmen."

 

Sandkastnrocker_0-1632499165728.png

 

I "just" need a solution that it knows for what date and topic the trainer want to do and not just the next one.

 

My understanding of German is non-existent, so you're way ahead of me 🙂

 

Anyways, it looks like you are using a gallery, so there is more functionality we can use to help you out. A very handy reference is Selected, which refers to the record currently selected in the gallery. For example, GalleryName.Selected.Startzeit will bring up the associated start date for the currently selected record. Your button only needs to have the OnSelect code of Select(Parent) and then your email template fields will have references  ,such as GalleryName.Selected.Startzeit, in them. Try referencing one of your columns using this in the Default property of that email text box to demonstrate this functionality.

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
Anonymous
Not applicable

Uh I am all giddy right now because I feel I am close to the solution. The selected works and gets the dates right so I am very hyped about that.

I have changed the 3 mailbuttons to

 

Gallery3.Selected.'HT Titel'.Value&
Gallery3.Selected.Startzeit&
Navigate('E-Mail')

 

Gallery3.Selected.'M1 Titel'.Value&
Gallery3.Selected.Startzeit&
Navigate('E-Mail')

 

Gallery3.Selected.'M2 Titel'.Value&
Gallery3.Selected.Startzeit&
Navigate('E-Mail')

 

So Powerapps should know that I need both items.

How do I make it so that it knows If I click the button in "Modul 1" that it should display the "Modul 1" and not the others. I think it works with "If" but I am not quite sure yet how it should be like so I dont get errors.

BCLS776
Super User
Super User

I made a demonstration app to show how I would set it up:

Animation.gif

 I suggest putting only:

Select(Parent);
Navigate('E-mail');

In your button to change screens, and then referencing the Selected item from the gallery after that.

 

I don't quite understand your need for 3 mail buttons - are there three different kinds of emails you want to send?

 

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
Anonymous
Not applicable

I only want to send one E-Mail with the same purpose.

I have three topics that get their information from three different columns in Sharepoint so they all have different Names.

Column 1 = HT Titel = your Session 1

Column 2 = M1 Titel = your Sesson 2

Column 3 = M2 Titel = your session 3

 

How does the textbox know you clicked Session 2 and 3 if it only says "Gallery.Selected.Session and not

Gallery.Selected.Session1

Gallery.Selected.Session2

Gallery.Selected.Session3

 

I feel like I am missing the rest of the Default text

 

All three topics are in one Gallery box? . Is it the same in your example? I dont know.

 

Actually I dont know what I am thinking overall. I though when I volunteered to do that it might be quick an easy. I never worked with any kind of programming language and started with that app maybe 2-3 weeks ago from scratch. It is for our volunteer fire department so I am not even paid to bother others. Its all babysteps and I am just so happy that you took your time to help out and go mad trying to understand what I am doing or not doing.

Helpful resources

Announcements

Exclusive LIVE Community Event: Power Apps Copilot Coffee Chat with Copilot Studio Product Team

  It's time for the SECOND Power Apps Copilot Coffee Chat featuring the Copilot Studio product team, which will be held LIVE on April 3, 2024 at 9:30 AM Pacific Daylight Time (PDT).     This is an incredible opportunity to connect with members of the Copilot Studio product team and ask them anything about Copilot Studio. We'll share our special guests with you shortly--but we want to encourage to mark your calendars now because you will not want to miss the conversation.   This live event will give you the unique opportunity to learn more about Copilot Studio plans, where we’ll focus, and get insight into upcoming features. We’re looking forward to hearing from the community, so bring your questions!   TO GET ACCESS TO THIS EXCLUSIVE AMA: Kudo this post to reserve your spot! Reserve your spot now by kudoing this post.  Reservations will be prioritized on when your kudo for the post comes through, so don't wait! Click that "kudo button" today.   Invitations will be sent on April 2nd.Users posting Kudos after April 2nd. at 9AM PDT may not receive an invitation but will be able to view the session online after conclusion of the event. Give your "kudo" today and mark your calendars for April 3rd, 2024 at 9:30 AM PDT and join us for an engaging and informative session!

Tuesday Tip: Unlocking Community Achievements and Earning Badges

TUESDAY TIPS are our way of communicating helpful things we've learned or shared that have helped members of the Community. Whether you're just getting started or you're a seasoned pro, Tuesday Tips will help you know where to go, what to look for, and navigate your way through the ever-growing--and ever-changing--world of the Power Platform Community! We cover basics about the Community, provide a few "insider tips" to make your experience even better, and share best practices gleaned from our most active community members and Super Users.   With so many new Community members joining us each week, we'll also review a few of our "best practices" so you know just "how" the Community works, so make sure to watch the News & Announcements each week for the latest and greatest Tuesday Tips!     THIS WEEK'S TIP: Unlocking Achievements and Earning BadgesAcross the Communities, you'll see badges on users profile that recognize and reward their engagement and contributions. These badges each signify a different achievement--and all of those achievements are available to any Community member! If you're a seasoned pro or just getting started, you too can earn badges for the great work you do. Check out some details on Community badges below--and find out more in the detailed link at the end of the article!       A Diverse Range of Badges to Collect The badges you can earn in the Community cover a wide array of activities, including: Kudos Received: Acknowledges the number of times a user’s post has been appreciated with a “Kudo.”Kudos Given: Highlights the user’s generosity in recognizing others’ contributions.Topics Created: Tracks the number of discussions initiated by a user.Solutions Provided: Celebrates the instances where a user’s response is marked as the correct solution.Reply: Counts the number of times a user has engaged with community discussions.Blog Contributor: Honors those who contribute valuable content and are invited to write for the community blog.       A Community Evolving Together Badges are not only a great way to recognize outstanding contributions of our amazing Community members--they are also a way to continue fostering a collaborative and supportive environment. As you continue to share your knowledge and assist each other these badges serve as a visual representation of your valuable contributions.   Find out more about badges in these Community Support pages in each Community: All About Community Badges - Power Apps CommunityAll About Community Badges - Power Automate CommunityAll About Community Badges - Copilot Studio CommunityAll About Community Badges - Power Pages Community

Tuesday Tips: Powering Up Your Community Profile

TUESDAY TIPS are our way of communicating helpful things we've learned or shared that have helped members of the Community. Whether you're just getting started or you're a seasoned pro, Tuesday Tips will help you know where to go, what to look for, and navigate your way through the ever-growing--and ever-changing--world of the Power Platform Community! We cover basics about the Community, provide a few "insider tips" to make your experience even better, and share best practices gleaned from our most active community members and Super Users.   With so many new Community members joining us each week, we'll also review a few of our "best practices" so you know just "how" the Community works, so make sure to watch the News & Announcements each week for the latest and greatest Tuesday Tips!   This Week's Tip: Power Up Your Profile!  🚀 It's where every Community member gets their start, and it's essential that you keep it updated! Your Community User Profile is how you're able to get messages, post solutions, ask questions--and as you rank up, it's where your badges will appear and how you'll be known when you start blogging in the Community Blog. Your Community User Profile is how the Community knows you--so it's essential that it works the way you need it to! From changing your username to updating contact information, this Knowledge Base Article is your best resource for powering up your profile.     Password Puzzles? No Problem! Find out how to sync your Azure AD password with your community account, ensuring a seamless sign-in. No separate passwords to remember! Job Jumps & Email Swaps Changed jobs? Got a new email? Fear not! You'll find out how to link your shiny new email to your existing community account, keeping your contributions and connections intact. Username Uncertainties Unraveled Picking the perfect username is crucial--and sometimes the original choice you signed up with doesn't fit as well as you may have thought. There's a quick way to request an update here--but remember, your username is your community identity, so choose wisely. "Need Admin Approval" Warning Window? If you see this error message while using the community, don't worry. A simple process will help you get where you need to go. If you still need assistance, find out how to contact your Community Support team. Whatever you're looking for, when it comes to your profile, the Community Account Support Knowledge Base article is your treasure trove of tips as you navigate the nuances of your Community Profile. It’s the ultimate resource for keeping your digital identity in tip-top shape while engaging with the Power Platform Community. So, dive in and power up your profile today!  💪🚀   Community Account Support | Power Apps Community Account Support | Power AutomateCommunity Account Support | Copilot Studio  Community Account Support | Power Pages

Super User of the Month | Chris Piasecki

In our 2nd installment of this new ongoing feature in the Community, we're thrilled to announce that Chris Piasecki is our Super User of the Month for March 2024. If you've been in the Community for a while, we're sure you've seen a comment or marked one of Chris' helpful tips as a solution--he's been a Super User for SEVEN consecutive seasons!       Since authoring his first reply in April 2020 to his most recent achievement organizing the Canadian Power Platform Summit this month, Chris has helped countless Community members with his insights and expertise. In addition to being a Super User, Chris is also a User Group leader, Microsoft MVP, and a featured speaker at the Microsoft Power Platform Conference. His contributions to the new SUIT program, along with his joyous personality and willingness to jump in and help so many members has made Chris a fixture in the Power Platform Community.   When Chris isn't authoring solutions or organizing events, he's actively leading Piasecki Consulting, specializing in solution architecture, integration, DevOps, and more--helping clients discover how to strategize and implement Microsoft's technology platforms. We are grateful for Chris' insightful help in the Community and look forward to even more amazing milestones as he continues to assist so many with his great tips, solutions--always with a smile and a great sense of humor.You can find Chris in the Community and on LinkedIn. Thanks for being such a SUPER user, Chris! 💪🌠

Tuesday Tips: Community Ranks and YOU

TUESDAY TIPS are our way of communicating helpful things we've learned or shared that have helped members of the Community. Whether you're just getting started or you're a seasoned pro, Tuesday Tips will help you know where to go, what to look for, and navigate your way through the ever-growing--and ever-changing--world of the Power Platform Community! We cover basics about the Community, provide a few "insider tips" to make your experience even better, and share best practices gleaned from our most active community members and Super Users.   With so many new Community members joining us each week, we'll also review a few of our "best practices" so you know just "how" the Community works, so make sure to watch the News & Announcements each week for the latest and greatest Tuesday Tips!This Week: Community Ranks--Moving from "Member" to "Community Champion"   Have you ever wondered how your fellow community members ascend the ranks within our community? What sets apart an Advocate from a Helper, or a Solution Sage from a Community Champion? In today’s #TuesdayTip, we’re unveiling the secrets and sharing tips to help YOU elevate your ranking—and why it matters to our vibrant communities. Community ranks serve as a window into a member’s role and activity. They celebrate your accomplishments and reveal whether someone has been actively contributing and assisting others. For instance, a Super User is someone who has been exceptionally helpful and engaged. Some ranks even come with special permissions, especially those related to community management. As you actively participate—whether by creating new topics, providing solutions, or earning kudos—your rank can climb. Each time you achieve a new rank, you’ll receive an email notification. Look out for the icon and rank name displayed next to your username—it’s a badge of honor! Fun fact: Your Community Engagement Team keeps an eye on these ranks, recognizing the most passionate and active community members. So shine brightly with valuable content, and you might just earn well-deserved recognition! Where can you see someone’s rank? When viewing a post, you’ll find a member’s rank to the left of their name.Click on a username to explore their profile, where their rank is prominently displayed. What about the ranks themselves? New members start as New Members, progressing to Regular Visitors, and then Frequent Visitors.Beyond that, we have a categorized system: Kudo Ranks: Earned through kudos (teal icons).Post Ranks: Based on your posts (purple icons).Solution Ranks: Reflecting your solutions (green icons).Combo Ranks: These orange icons combine kudos, solutions, and posts. The top ranks have unique names, making your journey even more exciting! So dive in, collect those kudos, share solutions, and let’s see how high you can rank! 🌟 🚀   Check out the Using the Community boards in each of the communities for more helpful information!  Power Apps, Power Automate, Copilot Studio & Power Pages

Find Out What Makes Super Users So Super

We know many of you visit the Power Platform Communities to ask questions and receive answers. But do you know that many of our best answers and solutions come from Community members who are super active, helping anyone who needs a little help getting unstuck with Business Applications products? We call these dedicated Community members Super Users because they are the real heroes in the Community, willing to jump in whenever they can to help! Maybe you've encountered them yourself and they've solved some of your biggest questions. Have you ever wondered, "Why?"We interviewed several of our Super Users to understand what drives them to help in the Community--and discover the difference it has made in their lives as well! Take a look in our gallery today: What Motivates a Super User? - Power Platform Community (microsoft.com)

Top Solution Authors
Top Kudoed Authors
Users online (6,370)