Unanswered

How can I split a field in power apps in to multiple rows in a Share point list?

(0) Share

Report

Posted on by G31

I am setting up a power app and want it so multiple request can be submitted on the same app.

I need it so that multiple people can be put in 1 field and an action put in another field. Then when this is submitted it will have each person will have there own row with the action next to it.

For example

Power app submission

Field 1 - Person1, Person2, Person3

Field 2 - Grant access

Desired Sharepoint list

Column 1 Column 2

Person1 Grant access

Person2 Grant access

Person3 Grant access

I am quite new to powerapps and any help would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@G31

How are you submitting information now - are you using a Form or are you building this with your own design of controls?

Was this reply helpful? Yes No
G31 4 on at

Like (0)

Report

@RandyHayes I am using a form

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@G31 (having problems replying to your post...the forum is not accepting the reply button for some reason)

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@G31

So, a Form deals with a single record. So, you would need to augment it to create the additional records.

There will be two steps to this:

1) Have your form submit only 1 person

2) Have the form then create the additional persons in a Patch/Collect statement if the first is successful.

The advantage of the form is that is provides a lot of functionality for submitting. However, you will only get this functionality for 1 record (because the form only deals with one record).

(had to cut the remaining part of this reply to try to submit post - I will provide in another response)

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report
@G31

(continuation of response)

So, you will need to do the following:

1) In your Submit action formula you will need to grab the value in the person input. So the formula would essentially need to be:

UpdateContext({lclPersons: yourPersonTextInputControlName.Text})

2) The Update property of the Field1 datacard needs to be:

First(Split(yourPersonTextInputControlName.Text, ",")).Result

3) In the OnSuccess action of the form, your formula would need to be:

With({_persons: Filter(Split(lclPersons, ","), !IsBlank(Result))}, Collect(yourList, ForAll(LastN(_persons, CountRows(_persons)-1), {Field1: Result, Field2: Self.LastSubmit.Field2 } ) ) ); UpdateContext({lclPersons, Blank()})

This should give you what you have described.

(this is submitting now...weird, it would not like the ordered list above)

Was this reply helpful? Yes No