Hi @Anonymous
Pls refer the sample flow:
1. Since we don't have any automated trigger for excel so we will use schedule flow to read records from excel send the records to teams channel. You may change the configuration as per your need:
2. Next, add "List rows in a table" action to fetch the records from the excel sheet. We will add filter query to fetch only those approval status is set to "Post". Here I am opening an excel sheet saved on my one drive:
3. Now, add "Filter array" action to get the records which are required to be posted for today. Pls ignore this action if you don't need this:
here, you need to write expression for both left & side operand in the condition. Expressions are written in the expression window as highlighted in the above screenshot.
Expression used for left side operand:
formatDateTime(item()?['Date'],'yyyy-MM-dd')
Expression for right side operand:
formatDateTime(utcNow(),'yyyy-MM-dd')
4. We will not create a html table using "Create HTML table" action:
Expression used for 'Date' header value:
formatDateTime(item()?['Date'],'MM/dd/yyyy')
Expression used for 'Post Type' header value:
item()?['Post Type']
Expression used for 'Post Location' header value:
item()?['Post Location']
Expression used for 'Ambassador Name' header value:
item()?['Ambassador Name']
Expression used for 'Idea Description' header value:
item()?['Idea Description']
5. Finally, post the message in the teams channel using "Post message in a chat or channel" action:
I have also added the .zip package of the flow so that you can import in your environment and make changes as required.
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks
