
I'm creating a power automate workflow that will automatically get the lists of people that has a vacation leaves in a week. This dates will be coming from a sharepoint calendar and it will send that list to me via email. I was able to get an output, but only for those people who only have single day or time off. If a person has 2 or more dates it will not be included in the list of output.
You have any idea to solve this issue?
See screenshot of the workflow.
Hi @dr3n09
If the filter is not pulling back the data, then the data doesn't match the criteria. So look at the data stored in your list and look at your filter (open a RUN and see what was sent to SharePoint) and then visually compare.
Should be able to find it.
But as to can we fully help no. We cannot see the raw data (the list) and cannot see the schema or details on how it was made, how dates are stored etc etc etc etc,
More is more here.
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey