web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Help with correct coding

Power Apps

Answered

Help with correct coding

(0) Share

Report

Report

Posted on by EmmaWatt

96

Hi Experts,

I hope that someone is able to assist a novice, I have a date picker for to and from dates that the uses a list to exclude public holidays in the UK, which works, now we have a member of staff based in Ireland so I have made a new list and added the Irish public holidays but cant work out how to express it in the field that calculated the number of days that have been selected for this 1 user, the code is here and highlighted is what I am trying to do for said Irish user to use the Irish list:-

Many thanks for any help given, Emma

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

VasileR 298 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @EmmaWatt,

You can add a simple If.
Replace
Not(Value in 'Bank Holidays'.BankHoliday)

With
If(user.email = xxx@xxx.com, Not(Value in 'ROI Bank Holidays'.BankHoliday), Not(Value in 'Bank Holidays'.BankHoliday) )

Was this reply helpful? Yes No
EmmaWatt 96 on at

Like
a
(0)

Report
Copy link

Link copied!

Wonderful thank you had to tweak it to If(UserEmail = "XXX@xxx.com", and works perfectly.

Was this reply helpful? Yes No

Join the conversation