Unanswered

Append to Text Input in Multi Line Text Field on Item Detail Screen

(0) Share

Report

Posted on by Community Power Pla...

Hello PA gurus, I am working on an event app that allow will allow users to RSVP to a selected event. I would like each RSVP to be saved to the Attendees column on my SP list and also be displayed in the Attendees field on my detail screen form. The form currently uses the logged in users name to RSVP to the event. The screen will also provide the ability for the user to change their RSVP, so their name would have to be removed from the Attendees field on the detail screen as well as on the SP list. I'm not quite sure both of these requirements can be achieved by how I currently have the app built. Any help is always appreciated.

Categories:

Building Power Apps

eventfull_RSVP.JPG

I have the same question (0)

All responses (10)

Answers (0)

cds 1,001 on at

Like (0)

Report

To add names in your patch:
{Attendees: Attendees & "
"& User().DisplayName&";"}

To remove, try using substitute:

Substitute(Attendees, Concatenate(User().DisplayName, "; "), "")

Was this reply helpful? Yes No
TiagoFreire 313 on at

Like (0)

Report

If you have a single line in SP but has multiple values in a single cell in a column, you can also Split(colName, ",") to get a single-column table with all values of the RSVP names. This table can be saved in a Collection, which you add and remove names to.
You can then save the updated data using Concat(collection, column, separator) to make a single text value out of the collection with the RSVP names.

Was this reply helpful? Yes No
cds 1,001 on at

Like (0)

Report

remember single line columns can only hold 255 char vs 64k multiline 👍

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I haven't been able to test adding and displaying multiple RSVPs yet, but I did try the remove RSVP using the substitute formula and I cannot get it to the name from the attendees column or in Power Apps.

Power Apps absolutely does not like my column name Attendees. It likes these two formulas but it does not achieve what I want.

Substitute(DataCardValue5.Text, Concatenate(Office365Users.MyProfile().DisplayName, ";"),"")
Substitute(DataCardValue5.Text, Concatenate(User().FullName, ";"),"")

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Sorry, clicked the wrong button. My issue is not resolved.

I wanted to reply to say that I have a multi-line SP column named Attendees.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@TiagoFreire
Can you please post more detail about your suggestion?

Was this reply helpful? Yes No
cds 1,001 on at

Like (0)

Report

Patch(Datasource, ID=Thisitem.id, {Attendees: Attendees & User().DisplayName & ";
"})

Was this reply helpful? Yes No
TiagoFreire 313 on at

Like (0)

Report

When you select a row, you can pick the Atendees value and put it in a separate Collection:

OnSelect:
ClearCollect(atendeesCol, Split(ThisItem.Atendees, ",");

You can have e.g. and atendeesGallery where you will display the contents of atendeesCol, and can add and remove values to atendeesCol.

After you are done changing atendeesCol, you can

Set(updatedAtendeesVar, Concat(atendeesCol,Value,",");

And then patch updatedAtendeesVar back to the original collection item'a Atendeed value.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@TiagoFreire,

Thanks so much for your reply. Okay, so I have created a collection called AttendeesList and a gallery to display the collection of attendees as they are added to it. I've added a button, so that the attendee can be removed from the collection. I have even been able to patch the attendee to my SP list multi-line column called Attendees. What I need now however is when the button is clicked to remove the attendee from the list, it also removes it from the SP list column, if that's possible.

Was this reply helpful? Yes No
TiagoFreire 313 on at

Like (0)

Report

Patch() the new atendee to AtendeesList;
In AtendeesGallery's remove button: RemoveIf(AtendeesList, Value = ThisItem.Value);

Then have a save button that:
Set(AtendeesListVar, Concat(AtendeesList,Value,",") );
And patches AtendeesListVar to the Atendees column in the selected SharePoint row.

So you just worry about adding and removing to AtendeesList, and Patch the SP gallery at the end.
If you don't want an additional "Save" button, you can just append those 2 actions to the end of the "Add" and "Remove" buttons you already have.

Was this reply helpful? Yes No