web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Auto Increment balance...

Power Apps

Answered

Auto Increment balance leave each month with 2.5 ( float ) on sharepoint list for powerapp application

(0) Share

Report

Report

Posted on by NassimSahara

25

Dears,

Can you please help in formulating the powerautomate for auto increment each month a leave balance column for all users with 2.5

the list will be linked to powerapp,

i tried initialize value then increment value but dont get it right.

thank you

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @NassimSahara

Formula's Used

coalesce(items('apply_to_each')?['LeaveBalance'],0)
add(variables('Current Leave Balance'),variables('LeaveToIncrement'))

SP List

Was this reply helpful? Yes No
NassimSahara 25 on at

Like (0)

Report

Thank yu @StalinPonnusamy but it is not incrementing, it is just giving 2.5 as balance

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @NassimSahara

I tested again and it's incrementing. Can you please make sure the formula should be

coalesce(items('apply_to_each')?['LeaveBalance'],0)

add(variables('Current Leave Balance'),variables('LeaveToIncrement'))

Sample Attached.

Please share the screenshot and formula that you implemented.

AutoIncrementFlow...

Was this reply helpful? Yes No
NassimSahara 25 on at

Like (0)

Report

Thank you very much @StalinPonnusamy working as a charme

Was this reply helpful? Yes No
deyashii 2 on at

Like (0)

Report
hi!

i did everything and mine is still not incrementing as well. here is the screenshot of my flow:

Using this code as well:
coalesce(items('apply_to_each')?['LeaveBalance'],0)
add(variables('Current Leave Balance'),variables('LeaveToIncrement'))

Was this reply helpful? Yes No

Join the conversation