Hello! How are you doing? I'm trying to build a Power Automate flow without any good results. I need to send an email if a calculated column in Sharepoint is 15 (this column reflects the days to an event). My idea is to use a programmed flow that everyday analice the column. I think that my problem is when I compare the column with 15.
Thank you in advance.
Solved! Go to Solution.
Make sure the calculated column is in the right format. Also double check what format you set the column to be. The default is single line of text. The convert and cast the value to the right type. I used this formula and it worked for me.
int(items('apply_to_each')?['columnname'])
Make sure the calculated column is in the right format. Also double check what format you set the column to be. The default is single line of text. The convert and cast the value to the right type. I used this formula and it worked for me.
int(items('apply_to_each')?['columnname'])
Thank you very much for the help. The flow works perfectly 🙂
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
203 | |
106 | |
56 | |
51 | |
41 |
User | Count |
---|---|
273 | |
156 | |
85 | |
81 | |
56 |