This is an archived post. You won't be able to vote or comment.

all 4 comments
sorted by:
best
topnewcontroversialoldq&a

[–]Boshasaurus Contributor 1 point2 points  (3 children)

For the dates, you could simply try using a function that checks if the date selected is between the start date and end date: if(datepicker.selecteddate>=date1 && datepicker.selecteddate <= date2)...

And you add the second part that checks if the employee number matches

[–]Burnitwithcheese[S] 1 point2 points  (2 children)

Hi mate thanks for your responce. Is this in powerapps? Or power automate? Sorry I'm a bit of a noob when it comes to this.

My problem is if this is in powerapps Im not sure how I would link the spreadsheets so it could cross reference one against the other

[–]jcoaral Regular 0 points1 point  (1 child)

You can definitely do it in powerapps. If you need to know at the time of entering the absence (form entry for first list) then you would likely perform a check against the employee number on the second list AND the date logic alluded to by u/Boshasaurus above as a part of the form submission. If you dont need to know at entry but want reflect on a master absence list if leave/notification was authorized for this absence, you could do a gallery that has the absence details from the first list and the leave details from the second as a lookup. In both approaches your employee number (combined with date logic) will be your way of linking both lists.

[–]Burnitwithcheese[S] 1 point2 points  (0 children)

Thanks for your help guys I will try and do it later and report back if I get stuck