Hello all,
Working on a small solution for my team but i've hit a wall with figuring out how to calculate a date, and wondering if somone could help.
Within my PowerApp I have a date picker filed labelled "Date Access Required", the next field is a "Access Length" which is a combo box with the values 1,2,6,8,12 all which represent months. I'm trying to figure how I can create a "Date to remove access" by calculating 'Date access required'+ 'Access Length' selected value from the combo box and give me a formatted date. I've managed to do this using the calculated column in SharePoint but unfortunately when using Power Automate OData can't filter Calculated columns, so I decided to apply this at the app level so it will update SharePoint as a simple string so I can then use the Odata filter.
This is the calculation that SharePoint used
=DATE(YEAR([Date Access Required]),MONTH([Date Access Required])+[Access Length(M)],DAY([Date Access Required]))
Many thanks in advanced!
