Answered

Fetch latest record added in Excel and send it to teams channel

(0) Share

Report

Posted on by maniyarsohel

I want fetch the latest record added in the Excel and that particular record should sent to teams channel is it possible.Please help me.

All responses (3)

Answers (1)

Verified answer

v-peijunz-msft Microsoft Employee on at

Like (0)

Report
Re: Fetch latest record added in Excel and send it to teams channel

Hi @maniyarsohel,

There is no direct trigger to automatically send a message to Teams when a new record is created in Excel file.
However, a workaround could be achieved through using two flows.
1. The first flow is extracting records from the Excel file to a SharePoint list.
I have a SharePoint list called "App test" with all the records listed here:
My excel file has a new record:
The first flow is shown here:

length(outputs('Get_items')?['body/value'])

Then using a Condition action to filter new records added in the Excel file.
After running the first flow, the new record is also added in the SharePoint list:
2. Once the new record is uploaded in the SharePoint list, using "When an item is created" trigger to automatically trigger the flow.
Here is the second flow:
It is more recommended that to use the SharePoint list as the data source, then you could use "When an item is created" trigger to automatically trigger the process: send a message to Teams when a new record is created.

Best regards,
Sylvia
maniyarsohel 7 on at

Like (0)

Report

Re: Fetch latest record added in Excel and send it to teams channel

hey @v-peijunz-msft thanks for the solution but for this I need to run the flow manually but I want it to be an automatic process eg: whenever a new row is added into the table that record should sent to teams.
Each time whenever the new row is added the new record should sent to teams channel. Is it possible?
v-peijunz-msft Microsoft Employee on at

Like (0)

Report
Re: Fetch latest record added in Excel and send it to teams channel

Hi @maniyarsohel,

Based on your description, I have made a simple test for your reference.
1. I have a excel file named App test which is stored in the SharePoint library.
The excel file contains a table (called Table1) that stores all the data records.
The latest record in Table1 is shown here:
2. Here is my flow:
last(body('List_rows_present_in_a_table')?['value'])
outputs('Compose')?['YourColumnName']
3. Result Screenshots:

Best regards,
Sylvia