You’re offline. This is a read only version of the page.
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.
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:
Share
Report
7
All responses (
Answers (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
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?
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
