Column1(unable to delete or change data type.
| Title | Date | Name |
|
Type=Single Line of Text
Enforce unique values=yes
Formatting="Consult-"0000
|
Type=Date and Time | Type=Single Line of Text |
Flow Steps
- Trigger: When an item is created
- Initialize Variable:
- Name:
UniqueID - Type: String
- Name:
- Get Items:
- Order By:
Created desc - Top Count:
1
- Order By:
- Apply to Each (loop):
- Select an output from previous steps:
body/value- Set Variable:
- Name:
UniqueID - Value:
concat('Consult-', padLeft(string(add(int(items('Apply_to_each')?['ID']), 1)), 4, '0'))
- Name:
- Set Variable:
- Select an output from previous steps:
- For Each (loop):
- Select an output from previous steps:
body/value- Update Item:
- Id:
ID (from the trigger) - Title:
UniqueID (from the variable)
- Id:
- Update Item:
- Select an output from previous steps:

Report
All responses (
Answers (