Choices column - show in gallery's item

(0) Share

Report

Posted on by Aurelie

Hello everybody,

In my app, I have a Form with a combobox (SelectMultiple is true) in it.

When I submit this Form (with several users) it created several records (2 here) in the corresponding table.

What I would like is to create 1 user per row. Example: row1 - user1. row2 - user2.

The objective is to show them in separate items in a gallery. (first item 'Person' = user1 ...)

Is it possible to do that?

Thank you in advance

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Aurelie Could you paste the code you have for adding this records in the chat.
Aurelie 86 on at

Like
a
(0)

Report
Copy link

Link copied!
@CNT sure, here is my Patch function

ForAll( DataCardValue11.SelectedItems, Patch( 'TableName', Defaults(TableName), { Name: Cycle_Name.Text, 'Start Date': Cycle_StartDate.SelectedDate, 'End Date': Cycle_EndDate.SelectedDate, 'Review Status': Cycle_Status.Selected, RviewerUserIDTest_Choices: DataCardValue11.SelectedItems.Value } ) );
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Aurelie Replace this line of the code

RviewerUserIDTest_Choices: DataCardValue11.SelectedItems.Value

to,

RviewerUserIDTest_Choices: ThisRecord.Value

Replace Value with the actual column name.

Please remember to give a 👍 and accept my solution as it will help others in the future.
Aurelie 86 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CNT, I've tried your proposal, but I get an error

This is like he don't know this field
This is what I get when I Highlight this field,

This is another field

And this is the field with the previous value

It really blocks me.
Do you, or anyone else, have a clue?
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Aurelie What do you have in the Items property of the Combobox? What type is it?
Aurelie 86 on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT , Here is what I have
'RviewerUserIDTest_Choices' is the column name from my datasource
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Aurelie The RviewerUserIDTest_Choices Column in the Database is of type Table. Because you want to store just one value of type Choices, this has to be changed.

Please remember to give a 👍 and accept my solution as it will help others in the future.
Aurelie 86 on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT It seams so easy now 😅
Thanks a lot