cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerApps11
Helper II
Helper II

Advice and help repeating

Hello StalinPonnusamy,

 

I need your help and advice please let me give an example what I am trying to do, I have SharePoint List which holds all checks, Check number, check amount, due date, etc.
sometimes I have a repeating fields for the same person like (2) checks, at moment I have to submit and reload the form do again for the same person,
Is there a way I can select the person name and enter one time the 2 checks or more and submit, a way I can make it repeating while using the form as I have to attach files and submit once please  


 

Thank you 
@StalinPonnusamy  please help 

1 ACCEPTED SOLUTION

Accepted Solutions
StalinPonnusamy
Community Champion
Community Champion

Hi @PowerApps11

 

User/person will be Combobox and users are stored in another SP list. Overall UI will le looks like this

StalinPonnusamy_1-1632712075107.png

 

Set the Items property of combo box to

'SPList Name'

Select the combo box and set the field property to 

StalinPonnusamy_0-1632711965653.png

Set OnChange property of Combo box to (UserPayee - Lookup)

ClearCollect(ColUserPayment,Filter('User Payment', UserPayee.Value=UserComboBox1.Selected.EmployeeName))

 

Insert a Gallery and set the Items property to 

ColUserPayment

Gallery should have

Check number - Text Input

Check Amount - Text Input

Due Date - Date Picker

ID - Label (For Reference)

 

Set Default property to each field respectively

Check Number

ThisItem.'Check Number'

Check Amount

ThisItem.'Check Amount'

Due date - DefaultDate

ThisItem.'Due Date'

ID - Label - Text property

ThisItem.ID

Insert Icon (+) and set OnSelect property to

Collect(ColUserPayment,{})

 

OnSelect of Save button will be

ForAll(
    Filter(
        GalleryPayment.AllItems,
        IsBlank(IDLabel.Text)
    ),
    Patch(
        'User Payment',
        Defaults('User Payment'),
        {
            'Check Number': CheckNumber.Text,
            'Check Amount': Value(CheckAmount.Text),
            'Due Date': DueDate.SelectedDate,
            UserPayee: {
                '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                Id: UserComboBox1.Selected.ID,
                Value: UserComboBox1.Selected.EmployeeName
            }
        }
    )
)

 

My SharePoint Setup For Reference ( Field name may vary)

StalinPonnusamy_2-1632712376875.png

StalinPonnusamy_3-1632712463178.png

 

 

View solution in original post

4 REPLIES 4
StalinPonnusamy
Community Champion
Community Champion

Hi @PowerApps11 

 

Yes, we can use Gallery and use Patch to submit one or more. I will send the answer in few hours.

Hi @StalinPonnusamy 

 

Thank you I will wait

StalinPonnusamy
Community Champion
Community Champion

Hi @PowerApps11

 

User/person will be Combobox and users are stored in another SP list. Overall UI will le looks like this

StalinPonnusamy_1-1632712075107.png

 

Set the Items property of combo box to

'SPList Name'

Select the combo box and set the field property to 

StalinPonnusamy_0-1632711965653.png

Set OnChange property of Combo box to (UserPayee - Lookup)

ClearCollect(ColUserPayment,Filter('User Payment', UserPayee.Value=UserComboBox1.Selected.EmployeeName))

 

Insert a Gallery and set the Items property to 

ColUserPayment

Gallery should have

Check number - Text Input

Check Amount - Text Input

Due Date - Date Picker

ID - Label (For Reference)

 

Set Default property to each field respectively

Check Number

ThisItem.'Check Number'

Check Amount

ThisItem.'Check Amount'

Due date - DefaultDate

ThisItem.'Due Date'

ID - Label - Text property

ThisItem.ID

Insert Icon (+) and set OnSelect property to

Collect(ColUserPayment,{})

 

OnSelect of Save button will be

ForAll(
    Filter(
        GalleryPayment.AllItems,
        IsBlank(IDLabel.Text)
    ),
    Patch(
        'User Payment',
        Defaults('User Payment'),
        {
            'Check Number': CheckNumber.Text,
            'Check Amount': Value(CheckAmount.Text),
            'Due Date': DueDate.SelectedDate,
            UserPayee: {
                '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                Id: UserComboBox1.Selected.ID,
                Value: UserComboBox1.Selected.EmployeeName
            }
        }
    )
)

 

My SharePoint Setup For Reference ( Field name may vary)

StalinPonnusamy_2-1632712376875.png

StalinPonnusamy_3-1632712463178.png

 

 

View solution in original post

Hi @StalinPonnusamy 

How can i modify you formula please I need to add a balance field so that i have a record how much total last check and how is paid bassically 

Check number - Text Input

Check Amount - Text Input (This records the first time only the total check amount)
Balance Amount - Text Input ( so that this field to modify till paid full then mark 0)

Due Date - Date Picker

ID - Label (For Reference)

Thanks 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,353)