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 Apps / Monthly Patch to Share...
Power Apps
Answered

Monthly Patch to Sharepoint List without Flow

(0) ShareShare
ReportReport
Posted on by 95

Hi All,

Attached is a simple table showing count and amount. I would like to patch them to a sharepoint list called 'Monthly Report' on a monthly basis without relying on Flow. My idea is illustrated with a pseudocode something like this:

If(Today's date => 30 and Tomorrow's date <= 31, Patch(Monthly Report, ....))

Would it be possible to achieve this? However, I'm stuck with the syntax and logical reasoning. 

Alois_0-1605085033369.png

Regards,
Alois

 

Categories:
  • Verified answer
    CU-18081211-6 Profile Picture
    9,272 Moderator on at

    Hi @Alois 

    I don't think that the formula should be an issue, I strugle to understand how do you want to trigger the patch() function.  You think to patch () info into monthly report when the app is starting based on that condition ?

    Or do you have something else in mind like a button ?

     

    To see if today() is the last day of the month, you can use this condition inside the if statement:

           Today() = DateAdd( DateAdd( Date(Year(Today()), Month(Today()), 1), 1, Months), -1, Days)

     

    Hope it helps !

  • Alois Profile Picture
    95 on at

    Thanks! I was struggling with the formula to check if today is the last day of the month. I intend to trigger the patch function when the app starts hence I'll insert the code in OnStart section.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 232 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 202 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 122

Last 30 days Overall leaderboard