Adding information from Sharepoint list to textbox

[Anonymous]

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.

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

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). 

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.

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

[BCLS776]

First, here's the data in behind my app. I used a collection, but this works the same as a Sharepoint list in this case:

As you can see, my sessions are not set up as columns. Instead, they are set up as individual records. Power Apps is good at dynamically choosing records, but it is not good at dynamically choosing columns. So, data structure is  important to making a good app.

Just for fun, I put in more data in three new columns. This is a wasteful way to handle the data because every record in these three columns is a copy of all the others:

However, I can access the text in these columns using notations such as Gallery.Selected.'M1 Titel'

This also leads to messy If() and Switch() statements that are attempting to decide which column to pull the value from:

Switch(Gallery.Selected.Session,
   1, Gallery.Selected.'HT Titel',
   2, Gallery.Selected.'M1 Titel',
   3, Gallery.Selected.'M2 Titel'
)

While this doesn't look awful, it is high-maintenance code: every time a column gets added or a new kind of message is required, this code must be edited.

The way to avoid that is to put your standard messages into their own table, with enough info so we can use LookUp() to find the one you need in the app.

What do you think so far?

[Anonymous]

Oh boy, so my sharepoint list already has over 1.000 entries so I dont think I can start from scratch especially as I would have to connect everything new in the app. Also I wouldn't even know how to setup the Powerapp with a record system as you explained.

One thing that is almost certain is is that there are no new columns that have to be entered only a new date with a record and the message would always be the same that would be sent via Mail.

Now I have to look into "Switch" as I never even heard about that until now and I dont understand the logic behind your example. It might be because its almost 10pm or I just lack a looooot of experience.

I dont even know how to implement that code you wrote.

I thought maybe using the sharepoint list ID instead of your Session but that gives nothing back so I am probably in a completely different area of brainfart.

Last attempt is to show you my mad paint skills. How my list is setup which as I understand now was terrible.

As I understand is that I would have to put in all the other column information in one individual record.

So I am pretty much about to give up.

[BCLS776]

If you will only ever have those three columns:

• HT Titel
• M1 Titel
• M2 Titel

then stick with those. I have bumped into lots of new users who get caught in the trap of adding column after column until their app stops working properly. I'm hoping you don't fall into that trap.

A good sleep will help, and you'll learn more as you build more apps.

Bye for now,

Bryan

[Anonymous]

So I have been trying to find an If or Switch solution but could not make it work. It always only shows one of the three topics and always just the first that is mentioned in the code or all three.

So I guess I give up, thank you anyway for your patience and ideas.

My solution now is to add a dropdown so the user can select the topic and its copied in to the Textfield for the Mail. Not as I hoped but I think it is as close as possible to my knowledge.