Share
Report
986Hi everyone,
I have designed a flow that sends Teams message to users based on few conditions. I will explain the scenario, I have a list that keeps stores users details and from this I'm focusing on two columns i.e. Self-Assessment (Choice column: Completed and Not-Completed) and Last_Modified (This is a custom column that we have created that keeps track of all changes in the main list: User List and its corresponding child list that are Skills, Certifications, Projects) so if there is any change been made in the User list or any of the corresponding child list then the Last_Modified will be updated (Last_Modified is of type: Date) have configured the expression in Canvas apps.
I have designed a flow that sends Teams message to users based on few conditions. I will explain the scenario, I have a list that keeps stores users details and from this I'm focusing on two columns i.e. Self-Assessment (Choice column: Completed and Not-Completed) and Last_Modified (This is a custom column that we have created that keeps track of all changes in the main list: User List and its corresponding child list that are Skills, Certifications, Projects) so if there is any change been made in the User list or any of the corresponding child list then the Last_Modified will be updated (Last_Modified is of type: Date) have configured the expression in Canvas apps.
So now the requirement was:
For all users where Self-Assessment: Not-Completed send a teams message to those set of users stating 'Please complete your Assessment' and the second case was if user has not updated their profile for more than 90 days then also send a teams message stating 'Your Profile hasn't been updated for more than ____ Days, kindly update your profile ' (for this I am checking the Last_Modified the custom column that I referred earlier, as the default column that SharePoint provides 'Modified' column but this column only will keep for column changes in that list)
Now I just have one issue that I have configured the flow with one of the Admin and while sending Teams message through Flow bot so it sends a small text Send throgh Flow Bot by 'Owner name'
And as its getting through the Owner's account those users all get added in their chat.
I know for a fact that to trigger the flow it requires authentication for which it uses the owners credentials but is there any work around to configure to some other user apart from the Owner.
For Mail I did find out a video from Pragmatic Works : https://www.youtube.com/watch?v=DQl3Dp-UDgo&t=178s
Similarly can we do in case of Teams message as well?
My flow looks like this:
For all users where Self-Assessment: Not-Completed send a teams message to those set of users stating 'Please complete your Assessment' and the second case was if user has not updated their profile for more than 90 days then also send a teams message stating 'Your Profile hasn't been updated for more than ____ Days, kindly update your profile ' (for this I am checking the Last_Modified the custom column that I referred earlier, as the default column that SharePoint provides 'Modified' column but this column only will keep for column changes in that list)
Now I just have one issue that I have configured the flow with one of the Admin and while sending Teams message through Flow bot so it sends a small text Send throgh Flow Bot by 'Owner name'
And as its getting through the Owner's account those users all get added in their chat.
I know for a fact that to trigger the flow it requires authentication for which it uses the owners credentials but is there any work around to configure to some other user apart from the Owner.
For Mail I did find out a video from Pragmatic Works : https://www.youtube.com/watch?v=DQl3Dp-UDgo&t=178s
Similarly can we do in case of Teams message as well?
My flow looks like this:
Categories:
I have the same question (0)
All responses (
Answers (
