web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Create SharePoint list...
Power Automate
Answered

Create SharePoint list item using Min and Max value from different list

(0) ShareShare
ReportReport
Posted on by 7

Hi Guy,

I am using SharePoint online for one of our project and I would like to Automate the process of creating new list item using Min and Max value from another list. Example I have one list named Teams with columns -

1) Title

2) Min Players (Number)

3) Max Players (Number)

 

and other with with Team Members with columns -

1) Title

2) Details (String)

3) Created Date (Date & Time)

 

So if I updated or added new item in Teams like below

1) Team 01

2) 1

3) 5

 

Then it should automate and create the new list items in Team Members like -

1) Team Member 01

2) ""

3) Current Date Time

 

1) Team Member 02

2) ""

3) Current Date Time

 

1) Team Member 03

2) ""

3) Current Date Time

 

1) Team Member 04

2) ""

3) Current Date Time

 

1) Team Member 05

2) ""

3) Current Date Time

 

So it will create the list items based on Max number.

 

How should I do that? I worked with SPD 2010 workflows but this is new to me so your help is appreciated.

 

Regards,

Abhijeet

Categories:
I have the same question (0)
  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @abhikhopade :

    Please try this flow:

    v-bofeng-msft_0-1606980264123.png

     

    Reference Expression

    1\ int(triggerOutputs()?['body/MinPlayers'])

    2\ formatNumber(variables('Min'),'00')

    3\ utcNow()

    The Result:

    v-bofeng-msft_1-1606980264125.png

     

    v-bofeng-msft_2-1606980264126.png

     

    Best Regards,

    Bof

  • abhikhopade Profile Picture
    7 on at

    Hey Bof,

    It works like a charm 👍

    Thanks a lot for the solution.

     

    Regards,

    Abhijeet

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 711

#2
Vish WR Profile Picture

Vish WR 691

#3
Haque Profile Picture

Haque 525

Last 30 days Overall leaderboard