I'm starting out on PowerApps and I'm having the following problem:
I have a gallery where I need to calculate the date for each item.
For the first item is easy, I just need to inform the date today, but for the other items, I need to calculate the date based on the date of the last selected item by adding the deadline of the current item.
For example, in the image below, the date displayed for the items #1 and #2 are correct. The dates of the items #3 and #4 must be blank and the date of the item #5 must be the date of the item #2 (last item selected) plus 10 days (the deadline is in the "Deadline column").
Additionally, if the calculated date is a Saturday or Sunday, the date of next Monday should be displayed.
Items in this gallery will always be sorted in ascending order by the "Seq." column.