You’re offline. This is a read only version of the page.
Announcements
287
I store my company date in the Microsoft Dataverse. The data is mostly orders from clients. I have commissioned sales people.
I would like to pull up a page that shows all of the unpaid commissions (easy in a gallery) and have the ability to simply checkmark all of the items I wanted to pay and then have a pay button that when I hit it, it updates the commission pay date field to the current date for EACH item automatically.
It's easy for me to show the records with a filter query but I don't know how to somehow have power apps loop through the records that are shown and marked to pay and update each appropriate record with a value of the current date.
Anyone?
Hi @astrontelstar，
Could you please tell me that if you want to update the commission pay date field to the current date once you hit the pay button?
Since you know how to show the records with a filter query using a Gallery, I will give you a sample to describe how to update the pay date field to the current date.
1). Add a Gallery and populate it with the data
2). Inset a Pay button
3). Set the OnSelect property of the Pay button as below:
Share
Report
All responses (
Answers (
Select(Parent);Patch(Pet2S,ThisItem,{PayDate:Today()}) // Pet2S is my Dataverse table nameNote that every time you select a Pay button within a record, it will update the appropriate record with a value of the current date.
