web

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

News and Announcements icon

Power Platform CommunityForums Power Apps If dropdown list = use...

Power Apps

Unanswered

If dropdown list = user location then select it

(0) Share

Report

Report

Posted on by StuDev

17

Hi,

I'm sure this is going to be rather easy but I am new to these apps.

I have a simple form that contains a lists of sites, the sites are populated from a sharepoint list.

I have a line of code that gets the current logged on users Location from active directory.

Office365Users.MyProfileV2({'$select':""}).officeLocation

I would like to check is the users office location matches 1 of the sites in the dropdown list and if it does, select it when the form loads.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @StuDev ,

I assume the combo box's items property is :

'SiteList'

you could set the combo box's DefaultSelectedItems property to:

LookUp('SiteList',LocationColumn=Office365Users.MyProfileV2({'$select':""}).officeLocation)

I think this link will help you a lot:

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/controls/control-combo-box

Best Regards,

Bof

Was this reply helpful? Yes No
StuDev 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you mate.

The site combo box is named badly (I used a form)

I was'nt sure what to call: LocationColumn.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StuDev ,

Could you please show me the combo box's items property.

Best Regards,

Bof

Was this reply helpful? Yes No
StuDev 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
StuDev 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, is this the screen shot you mean? Apologies - I am new to powerapps

Was this reply helpful? Yes No

Join the conversation