I am trying to build a scheduled flow that will email me the items that were created and added to my Sharepoint List the day before and since I have limited experience with this I am trying to utilize CoPilot to help me with this. The formula that it provides me with is:
Created ge datetime'${formatDateTime(addDays(utcNow(), -1), 'yyyy-MM-ddT00:00:00Z')}' and Created lt datetime'${formatDateTime(utcNow(), 'yyyy-MM-ddT00:00:00Z')}'
the issue is that an error is returned stating that this is not a value formula to be used and I believe it has to do with the "Created ge" portion but when i ask CoPilot to address this and use a different expression it doesnt return any options.
any help with this is greatly appreciated.
I also have certain criteria that i would like to limit it to, maybe 5 of the 20 columns that is gathering data but this is the main hurdle that I need to overcome at the moment.
Thank you,
Ren
51
Share
Report
All responses (
Answers (
