Hello Y'all, ive got an Interesting Task, that I need to solve. Basically I need to get the data from my SharePoint List ( Data that is in the Columns) and use that Data to write an Email at the end of the day.
1) I need to Filter the Products that I have in Sharepoint using a choice column ( now I need to have that same possibility in PowerApps. PS: the filtered products should show up and be filtered using Combo Box, so if I choose 2 Filters and have lets say 10 Products in 1 Filter and 23 Products in the 2 Filter, that it adds them all together or shows singular if only 1 Filter is applied.)
2) After ive filtered out the Products and the names of the Companies that are included with those Products, I have to now in a way Concat the names of the filtered Product Companies to an Email Page and then send them an email ( there are couple ideas that I might want to add to the message but right now just a simple email will do). So basically to sum it up, I need to filter the Products in my SP list, get the mailadresses of those filtered Product companies and send them all an Email.
Later I might need to also document the sent emails but that's a Task for the Future
IF someone could help me with completing that task, I would appreciate it very much.
