Answered

Saving and Retrieving Gallery Dropdown

(0) Share

Report

Posted on by PaulSMV

Good morning,

I have what I thought was an easy scenario but I am going round in circles. I am new to Power Apps so apologies if I am missing the obvious.

I have a gallery with a dropdown box, three text entry elements and a text box that calculates a value based on what the user has input in the other fields. I have a button to add additional rows to the gallery as each user may input a different number of rows.

I am able to save the entry to a dataverse table but trying to retrieve the entry so the user can edit it when they log back in is causing me issues.

If the user hasn't saved anything into the table, the dropdown box needs to populate the options. If the user has saved anything to the table, it needs to retrieve that and populate the fields, but the dropdown has to have all of the other options so the user can change it. As I am typing this, I am not sure how I would go about this bit anyway.

Any help would be appreciated. I haven't posted any of the code as I would like to know if I am trying to do something that isn't supported.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @PaulSMV,

Do you want to populate the dropdown with a default value if current user has entry before but keep other options in the dropdown list?

Could you please tell me what you want to populate if there is multi entry of one user, define the retrieved first record?

Anyway, this issue is not that complex, you could set the Dropdown box Items property as below:

Choices(TableName.ColumnName)

set the Dropdown box Default property as below:

LookUp(TableName,'Created By'.'Primary Email'= User().Email).ColumnName

I assume that you use the default 'Created By' column to retrieve the current user's record, and I assume the column you used to populate the dropdown box is a Choice column.

Was this reply helpful? Yes No
PaulSMV 12 on at

Like (0)

Report
Copy link

Link copied!
Hi @v-qiaqi-msft,

Thanks for the help. I have managed to get a bit closer to my goal.

I have a dataverse table which I am loading into a collection.

ClearCollect(colTeachingActivity2, teaching_activity)
I have set the items property of the gallery to this collection. This is because I have a button that adds a row to the gallery

Collect( colTeachingActivity2, { 'activity_type_1 (teaching_activity)': Choices(teaching_activity.activity_type_1), Number_of_Students: 0, Event_Duration: 0, No_of_Events: 0 } )

I have set the dropdown using the method you described. The issue I have is that if the dataverse table is empty, the gallery doesn't display anything to the user. This makes sense but I am not sure how to get around it. I have tried various things on the default value of the gallery itself with no success.

Was this reply helpful? Yes No
PaulSMV 12 on at

Like (0)

Report
Copy link

Link copied!

Ignore the above. The button adds a row to the table so all works as it should.

Was this reply helpful? Yes No