Read Excel row and publish to MS Teams

(0) Share

Report

Posted on by srinivas02

Every day we receive an Email containing an Excel file, using Flow I am saving on my one drive for business.

Now I want to create a flow to fetch the row information into MS teams

Array Name	Raw TB	Usable TB	% Allocated	Remaining Alloc
Sample_1	193	210	90%	17
Sample_2	194	210	90%	16
Sample_3	190	210	88%	20

Whenever someone from the MS team looking for the information of Sample_2 it should be displayed.

Array Name	Raw TB	Usable TB	% Allocated	Remaining Alloc
Sample_2	194	210	90%	16

Can someone help me with how to create the flow?

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (0)

RobElliott 10,391 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@srinivas02 the flow below will post the table to a Teams channel and allow the table to be searched:

the result in the Teams channel:

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
srinivas02 19 on at

Like (0)

Report
Copy link

Link copied!

@RobElliott thank you for the solution. Do we get only the designated row?
To be more clear if, I was looking for only the information in sample_1 can we get that alone instead of sample_2,sample_3 data?

Was this reply helpful? Yes No
srinivas02 19 on at

Like (0)

Report
Copy link

Link copied!

I am looking for help on this flow, please some let me know if this can be done.

Was this reply helpful? Yes No
RobElliott 10,391 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@srinivas02 in your trigger just add an input for the data you want from Excel, for example Sample_2 in the Array column. Then in your List rows present in a table add a filter query of Array eq 'Input'. So when you run the flow it will ask you for the Input and will then just add that row to Teams.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
srinivas02 19 on at

Like (0)

Report
Copy link

Link copied!

@RobElliott thanks for the reply, but I want the trigger point also from the team's group.

Was this reply helpful? Yes No
kanothecat 3 on at

Like (0)

Report
Copy link

Link copied!

@RobElliott Power Automate was new to me, but I followed the instructions and was able to make a successful post. Very helpful. Thank you!
I have one question. Is there a way to display numbers in "two-digit" and "right-align" in a table?

Was this reply helpful? Yes No