Using User() as a default value in a form

(0) Share

Report

Posted on by Daniël

147

I know there are threads on this issue, but it doesn't seem to work for me, so my issue is as follows:

When I make an edit form, I want the user to be selected by default in one of the drop-down menus. I expect entering User() in the the Default-property of either the Datacard or the DataCardValue, but neither helps. This seems to have worked for others however.

I also tried some of the more elaborate codes, but yet no result. I don't get an error either, there is just nothing showing up. I know I can retrieve the information, as I am using information from it on fields such as labels.

Does anyone know what's going on here?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

alaabitar 1,503 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello @Daniël

In that case as a workaroung you can do in the defaultselecteditems property of your dropdown something like

LookUp(Choices([@YOUR_SHAREPOINT_LIST_NAME].NAME_OF_YOUR_COLUMN),User().Email = Email)

This should do the trick.

Was this reply helpful? Yes No
Daniël 147 on at

Like (0)

Report
Copy link

Link copied!

Hi Alaa, thank you for your reply. However, it doesn't seem to change anything:
No error, just an empty field. Do you have any idea why that would be?

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (0)

Report
Copy link

Link copied!

What are the items of the dropdown?
If the item you're trying to specify as the default doesn't appear in the dropdown's items, it will be blank.
Make sure that the items for the gallery are both of the person type, and also that the user in question would be in these.

Was this reply helpful? Yes No