Hello Everyone!
I am developing a program in Power Apps that allows users to self-select subscriptions from a ComboBox. My system uses two SharePoint sheets:
The "Benutzerdaten" sheet contains:
- ID (Primary Key)
- Titel (defined by the code Office365Users.MyProfileV2().mailNickname)
- abo_id (foreign key linking the user to a subscription or subscriptions)
The "Abonnementen" sheet contains:
- ID (Primary Key)
- Titel (Title of the subscription)
I have created a chat room in Teams to receive messages(errors). Now I need to configure Power Automate so that it performs the following actions:
- If an email arrives on the Teams chat mail (e.g. 1230c6fd.example.onmicrosoft.com@emea.teams.ms), it should be filtered by title.
- If the email header matches the name of a subscription from the "Abonnementen" sheet, the users subscribed to this subscription (specified in "Benutzerdaten" via abo_id) should receive a notification from the application.
Since this email belongs to a separate chat room in Teams, all emails to this address are displayed in the Teams chat room. Therefore, it is important that message filtering is done by the email header.
Help me to realize this idea
Thanks 😊

