
i am creating a SharePoint list that has many fields including "Year" and "Month". This list will be used in PowerApps. My requirement:
When someone submit a record. PowerApps(OR Power Automate) should extract Month and Year from "Created" field and save it in appropriate filed in the list.
I want to filter record based on those field. So i will take 2 dropdowns that have hard coded months and years.
Rather than extract the month and year from Power Apps or Automate, is this something that you could achieve by defining calculated columns in SharePoint? Or do you want to actually want to extract the month/year into user defined columns because you want to make them updatable by the user?