
Hi
I have an SP list that contains details of bookings made via a Power App created in house. I would like to use Power Automate to query the SP list and email any users that have a desk booking tomorrow a reminder email
If I click on 'Automate', then 'Set a reminder' and 'Check Out From' (that is the name of the field in list that contains date desk booked for), it does it for me which is great......
However, it currently emails me ALL desks that are booked for tomorrow. I would like to be able to add to the filter to only email me MY desks booked. Here is the flow created for me:
The formula in the concat is:
I would like to add to the Filter Query or concat to say something like and ReservedFor eq DisplayName (from the Get My Profile earlier) - ReservedFor is the column name in the List which contains who the desk is booked for
Hi @JBMac
I did a recent video on Get Items filter query. There is a new experience available in preview which can help to formulate the OData queries.
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Thanks,
Reza Dorrani, MVP
YouTube
Twitter