You’re offline. This is a read only version of the page.
13
Hi all,
I want to create a flow that sends out a daily email listing all the items on a Sharepoint list where a column has been changed to a specific value, instead of an instant email at column change.
I have set up the flow to run daily, and on the "Get Items" I have set a filter to get items changed/created in the last 24 hours. My idea is to loop through the returned items, get the ones only where the column "Priority" has changed to "High" and build an HTML table to send via email.
I keep getting an error "sinceInput not specified clientRequestId:" at "Get changes for an item or file" and I don't understand why...
Any help would be highly appreciated.
Thanks
Alex
It looks like the token is not being passed from the error. Double check what is in the input. Since takes a
Here's a useful article: How to 'Get changes...based on date and[community]time in Power Automate (tomriha.com)
Have you reviewed the input to ensure the token is correctly passed, and have you considered the suggestions in the article on "How to 'Get changes...' based on date and time in Power Automate" for resolving the issue?
It looks like the token is not being passed from the error. Double check what is in the input. Since takes a date as well. Try putting in utcNow() adjusted for your time zone and formatted as required. This also works for me:
This gets changes from 1 day ago in my time zone, UTC-7.
Share
Report
All responses (
Answers (
formatDateTime(addDays(addHours(utcNow(),-7),-1),'yyyy-MM-ddTHH:mm:ssZ')
Here's a useful article: How to 'Get changes...' based on date and time in Power Automate (tomriha.com)
What do you mean by not meaningful data in the Since field? The version number to get changes since in that case is the first version, which is why the number 1 is in the field. Feel free to test it out with your own flow.
Thanks for your help, however reading more carefully it does look "since" could be either a Version (like you're suggesting) or a "Trigger Window start Token".
This token express the time of the last flow check, which is what I am after because my intention is to send out an email on what has changed since the last flow ran.
If I use the version, I may send out the same email multiple time because I don't have a way to control if the update has been sent out or not already.
This error indicates that there is a problem with the input in Since. It looks like you tried to pass the version from the trigger. The version in the trigger is a string, but Since requires an integer, so the input was malformed. If you put the current version in Since, even as an integer, it shouldn't return any changes because there are no changes between the current version and the current version. Change the version to an integer then subtract at least one to get any changes. If the version is 1, all of the data is new.
The Since field requires an integer for the version number. It works as designed. There is no more meaningful data. I could put in a variable as I did above, but I was just demonstrating that the trigger is irrelevant.
You are correct but that do you much good without meaningful data in the Since field. If you can make it work in a meaningful way, I will stand corrected.
I learned something in researching your issue. My understanding is that the Get Changes action will not work unless it is used in conjunction with a When an item or file is modified action.
My understanding is that the Get Changes action will not work unless it is used in conjunction with a When an item or file is modified action. See this post.
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
