I am on a sharepoint modern
Communication site I have a document library here
If I click on documents
I can see an excel file called projects already there.
I will open that excel file
You can see some project entries already here
First thing I need to do is
I will select the whole area and convert it to table
So from the insert tab if I click on table
It will give me option to create a table. I will use my header
My table has headers and I will click ok
Table is ready
Next thing I have to do is
I have to go to insert tab again and click on office add-in
I need to find power automate add-in
And click the search button so
you can see microsoft flow for excel preview
I can add that
To my excel file. I'll just click on the continue here
Now you can see the flow icon is available to use
And it's ready
So I will click on the flow icon which will open
The flow tab on the right hand side. I will click on new
And create from template.
I will select the first template for a selected row
complete a custom action
So I will select that template
and if I scroll down
click on continue
It automatically populated the location the library the file id
If I click on the folder icon
You can select a file instead if you don't like the id
from the table
By default table one which we have converted.
The next step I need to add is
post
A message to team. So post a message version 3 preview or microsoft team.
I will click there
I will select a team where I want to post this message. I will select project board
And the channel, which channel I want to post this message to general channel. I will select
You can see I have a project
or team and general channel
Now in the message body, I will put project summary
And then I will
Put project name
And I will select the project name
So the first column project name column and then
I will select project hour and
then again, I will select from the column project owner
And then the last one I will select is status
Again, this is from the excel column status. I will choose
The status there now, I will rename the flow
Post project summary
i'll click save
Now this flow is ready
Now I will select first project column and click on run flow and now I click on continue
And then run flow
This will post the project summary of the first project into microsoft team
Now when I navigate back to teams,
I can see one project summary is posted there
Now you can do this for multiple rows as well. So if I
Just delete this row for now and go back to excel
And I select both the rows
project name and then
Click on the run
workflow
And click run again
Now the workflow is completed
I will navigate back to the teams.
You can see the two rows from
excel are added to the team's channel
consider subscribing
If you are new to the channel
Give me thumbs up
if you found this video useful.
If you have any question queries related to this video
or anything related to office 365
Put in the comment section below.
I will be happy to answer.
Thank you very much