Read Excel row and publish to MS Teams

Like (0) Share

Report

Posted on 20 Feb 2020 09:45:34 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?

All responses (6)

Answers (0)

kanothecat 3 on 22 Dec 2023 at 07:29:21

Like (0)

Report

Re: Read Excel row and publish to MS Teams

@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?
srinivas02 19 on 03 Mar 2020 at 14:58:01

Like (0)

Report

Re: Read Excel row and publish to MS Teams

@RobElliott thanks for the reply, but I want the trigger point also from the team's group.
RobElliott 10,175 Super User 2025 Season 2 on 03 Mar 2020 at 11:59:07

Like (0)

Report

Re: Read Excel row and publish to MS Teams

@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.
srinivas02 19 on 03 Mar 2020 at 11:32:26

Like (0)

Report

Re: Read Excel row and publish to MS Teams

I am looking for help on this flow, please some let me know if this can be done.
srinivas02 19 on 26 Feb 2020 at 12:27:31

Like (0)

Report

Re: Read Excel row and publish to MS Teams

@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?
RobElliott 10,175 Super User 2025 Season 2 on 21 Feb 2020 at 13:37:28

Like (1)

Report

Re: Read Excel row and publish to MS Teams

@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.