I used the filter query to get items from SharePoint List and then add rows into Excel table. I then email Excel table using just a static email. But I don't want to send email if the filter query does not return any records. I tried adding a condition in several different places, and when I do it sends the same email multiple times. E.g. if there are 3 records that are inputted into table from condition, it will send the same email 3 times. There has got to be a way to do this without sending multiple emails?
Accepted Solutions
hi @theBrianL you can do this
Use length to get the number of values that you have and then you can compare: If the values are more than 0 it means you have data, if not you no have data
Quieres contenido en español? Síguenos en hi @theBrianL you can do this
Use length to get the number of values that you have and then you can compare: If the values are more than 0 it means you have data, if not you no have data
Helpful resources
Join us for Microsoft Power Platform Conference
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
A new place to submit your Ideas for Power Automate
Announcing a new way to share your feedback with the Power Automate Team.
2022 Release Wave 2 Plan
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
Register for a Free Workshop
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Microsoft 365 EduCon
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.
