Share
ReportI created a Power Automate flow for users who complete a Microsoft Forms questionnaire called “THE INITIATIVE SUGGESTION BOX.” The responses collected from the form create a Microsoft Teams record in a list called “Project.” I want the names of the projects created to follow a specific naming convention: ‘RXBO – YYYYMMDD – 000’. The three zeros should serve as a counter to number the projects created on the same day from 12:00 AM to 11:59 PM. I wloud like to create a Dynamic BOM automation in Power Automate
here is teh architcture of my solutiuon
[Initialize varDateDay] formatDateTime(utcNow(),'yyyyMMdd')
↓
[Compose ODataFilter] concat(startsWith('RXBO - ', variables('DateJour')))
↓ (OData → startswith(ID_x0020_Initiative_x0020_AA,‘RXBO - 20240507’))
[Get items (Project)]
↓
[Set varDayCounter]
↓
[Set varTextCounter]
↓
[Create project with concatenated title]
↓
[Compose ODataFilter] concat(startsWith('RXBO - ', variables('DateJour')))
↓ (OData → startswith(ID_x0020_Initiative_x0020_AA,‘RXBO - 20240507’))
[Get items (Project)]
↓
[Set varDayCounter]
↓
[Set varTextCounter]
↓
[Create project with concatenated title]
But It does not work out.
Is tehre anyone wdid soemthing like that ?
Categories:
I have the same question (0)
All responses (
Answers (
293
