We are looking to create a Recurring Billing and Contracts Management Flow to manage our Service Contracts.
Can we utilize Power Automate and Sharepoint Lists for this business requirements.
Our idea is to create 2 Sharepoint Lists with the following fields
1. Service Contracts List
a. Service Name (single text)
b. Vendor Name (single text)
c. Repeat Frequency (number)
d. Repeat Every (Choice)
i. Week(s)
ii. Month(s)
e. Bill Date (Date)
f. Due Date (number)
g. Due Type (Choice)
i. Of the following month
ii. Day(s) after the bill date
iii. Day(s) after the end of the bill month
iv. Of the current month
h. End Date (Date, Optional)
i. Amount
2. Bills List (Items are created using flow, based on Schedule)
a. Service Name (single text)
b. Bill Unique ID (single text)
c. Bill Date
d. Vendor Name
e. Amount
Description:
Repeat Frequency
When and how often the bill will be created in the Bills SP List
Bill Date
The date when the bills will begin. today's date, or in the future only.
Due Date
The date that the Bill is due to be paid.
For example, if I want the Bill to be created and due on the same date, I enter 0 in “Due Date” and select the “Day(s) after the bill date” choice in the Due Type.
End Date (Optional)
The last date that a Bill is created for each Service Entry (subscription or contract).
Bill Unique ID
A unique to allow flow to check if a bill was already created when using Schedule as a trigger
