Answered

Dynamic BOM automation in Power Automate

(1) Share

Report

Posted on by KA-26011606-0

I 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]

But It does not work out.

Is tehre anyone wdid soemthing like that ?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

CU11021143-0 59 on at

Like (1)

Report
Copy link

Link copied!
Name projects as RXBO – YYYYMMDD – 000 with the counter resetting daily.
Flow outline (simple & reliable):

Compose (DateStamp): formatDateTime(utcNow(),'yyyyMMdd')

Get items (Project)
Filter Query: startswith(Title,'RXBO – @{outputs('DateStamp')}') Order by: Title desc & Top Count: 1

Next counter:
If no items → 1; else extract last 3 digits from the latest Title and +1.
Pad to 3 digits: padLeft(string(variables('NextCounter')),3,'0')

Final Title: concat('RXBO – ', outputs('DateStamp'), ' – ', outputs('NextCounterPadded'))

Create item with Title = Final Title.

Note -

OData goes directly in Filter Query (don’t wrap the function in quotes).

To avoid duplicates, set Trigger Concurrency = 1 (or use a small “Counters” list with ETag/Do until).

If you need local date, convert time before formatting.

Was this reply helpful? Yes No
Verified answer

Valantis 5,742 on at

Like (1)

Report
Copy link

Link copied!

Hi @KA-26011606-0,

1. CHECK YOUR COLUMN INTERNAL NAME FIRST
Go to the Project list > List Settings > click your project name column > check the URL for Field=
Use exactly what you see there, either ID_x0020_Initiative_x0020_AA or Title. Copy paste it, don't retype.

2. ODATA FILTER (this is what broke it)
Your filter: concat(startsWith('RXBO – ', variables('DateJour')))
Two problems: concat() doesn't work in an OData filter field, and the arguments are reversed.

Replace it with this directly in the Get items Filter Query field:
startswith(YOUR_COLUMN_NAME,'RXBO – [varDateDay from dynamic content]')
No concat, no wrapping, just type it and insert varDateDay inline from the dynamic content picker.

3. COUNTER
Set varDayCounter to:
length(body('Get_items')?['value'])

4. ZERO-PADDING
Set varTextCounter to:
formatNumber(int(add(variables('varDayCounter'), 1)), '000')
Gives you 001, 002, 003 etc.

5. FINAL TITLE
concat('RXBO – ', variables('varDateDay'), ' – ', variables('varTextCounter'))

make sure the separator is the same character everywhere, filter, variable, and title. En-dash (–) and hyphen (-) look the same but aren't. Copy paste from one place.

No AI or AI Builder in this flow so zero Copilot Credits consumed.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

Was this reply helpful? Yes No
KA-26011606-0 8 on at

Like (1)

Report
Copy link

Link copied!

@Valantis @CU11021143-0 Thank you so much guys

Was this reply helpful? Yes No