Power Platform Community Forum Thread Details

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:

concat(concat('CheckOutFrom',' ge ', '''',outputs('Today_+_x_days')),'''',' and ', concat('CheckOutFrom',' lt ','''', outputs('x_Days_+_1'),''''))

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

Categories:

General topics