web

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

News and Announcements icon

Power Platform CommunityForums Power Apps If Statement to pick i...

Power Apps

Answered

If Statement to pick items from Sharepoint, otherwise use the Default Office365

(0) Share

Report

Report

Posted on by Rick_black

186

I am building an application that one can be able to update their details. I have a display screen and an edit screen. The display screen has most items showing data from AD. These items include country, manager, Department etc. However, AD is not usually updated as first and so I would love to do an if Statement that if for the view Screen. For example if the department item is updated, it should show from SharePoint, otherwise, it should show from AD.
The country AD code is

Office365Users.MyProfile().Department

The Country SharePoint code is

varRecord.department

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Rick_black

Set your formula to:

Coalesce(varRecord.department, Office365Users.MyProfile().Department)

That is what the Coalesce function is all about...the first value that is not blank.

I hope this is helpful for you.

Join the conversation