web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get value of first row...
Power Automate
Unanswered

Get value of first row only from DAX query into Teams message

(0) ShareShare
ReportReport
Posted on by
Hi,
 
I have a flow which queries Power BI dataset, returns a single row (date) and then composes a Teams message with that row data.
However, no matter what I tried, it always adds the query result header and some metadata, which I don't want.
I want it to return only the value itself, without header or title or []. 
For example, if the current message is:
 
I want it to only say "The IO report inputs for 20-DEC-2024" were updated by all divisions".
How can I achieve this?
 
This is the whole workflow:
 
 
This is the query:
 
 
and this is the message composition:
 
Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard