Hello~
This is my first post and I'm new to the Power Platform community. I need some assistance with the most efficient way and most appropriate application to calculate an "expected due date" SharePoint list column.
Here is the business scenario:
- User enters preliminary data in Power Apps. For this problem, User selects Document Type (from a drop-down list of 16 total). Each document type have variable SLA business days (5, 10, and 20) associated with them by when the request must be completed (example: DocumentType1, SLA=5 Business Days; DocumentType2, SLA=10 Business Days; DocumentType3, SLA=20 Business Days)
- Data is saved to a SharePoint list when user submits form.
- Key fields in SharePoint List for this problem include: Request Date, Document Type, SLA, Standard SLA Date
- For each SharePoint List entry, I need to calculate the Standard SLA Date in Business Days, based on the selected Document Type, date of request, and associated SLA for that document type.
I have 2 questions related to this problem:
- Where is the best place to deliver this solution? In the Power App, as a Calculated Date Column in the SharePoint list, as an independent Workflow, or some other method?
- How do I achieve this calculation?
I've experimented some with the following, using =IF(Weekday) formula, but not sure if I'm on the right track or if there is a cleaner, easier way. I'm struggling with out to test the Document SLA in this formula.
=IF(Weekday([Request Date],>1,[Request Date]+7, IF(Weekday([Request Date])>6,[Request Date]+9, [Request Date]+8))
| Request Date | Weekday | Days to Add (for documents with 5 business day SLA) | SLA Due Day |
| Sunday | 1 | +8 | Monday |
| Monday | 2 | +7 | Monday |
| Tuesday | 3 | +7 | Tuesday |
| Wednesday | 4 | +7 | Wednesday |
| Thursday | 5 | +7 | Thursday |
| Friday | 6 | +7 | Friday |
| Saturday | 7 | +9 | Monday |
I appreciate any insight the community can offer on this problem!
