How would you tackle this project

(0) Share

Report

Posted on by astrontelstar

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?

All responses (1)

Answers (0)

v-qiaqi@microsoft.com on at

Like (0)

Report
Re: How would you tackle this project

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:

Select(Parent);Patch(Pet2S,ThisItem,{PayDate:Today()}) // Pet2S is my Dataverse table name

Note that every time you select a Pay button within a record, it will update the appropriate record with a value of the current date.