Increment Column (Number)

(0) Share

Report

Posted on by marsdendd

Hi,

I have a 2 SharePoint lists:

1. Pitches

2. Applicants

Users apply to take part in one of the submitted "Pitches" by completing a form. I have created a Number column called ApplicantCount in the Pitches list and would like to increment the ApplicantCount column +1 for every applicant.

The applicants (applications are captured in the Applicants list.

The trigger being OnSelect. The applicant selects the title of the pitch (dropdown) and submits the application.

What I want to achieve is that the ApplicantCount column +1 is incremented with every application.

The Title in both the Ideas and Applicants list are identical.

I assume i need to use either the Update() or Patch() function but am struggling with the syntax.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@marsdendd
You have the right idea about using the PATCH function. I think you will understand the code I have written below. Please put it in the OnSelect property of your Submit button right at the end. If you are wondering what to do with DataCardValue_ID.Text, you should include ID as a card on your form but make it non-visible.

Set(myRecord,LookUp(Pitches,ID=DataCardValue_ID.Text)); Patch( Pitches, myRecord, {ApplicantCount: myRecord.ApplicantCount + 1} );

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey @marsdendd

Can you try to update the expression as:

Patch(
SPListName,
Defaults(SpListName),
{
ApplicantCount : Value(First(Sort(SPListName, "ApplicantCount", "Descending")).ApplicantCount) + 1
}
)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
marsdendd 68 on at

Like (0)

Report
Copy link

Link copied!
Hi @yashag2255 Thanks for your response. I tried your expression but i fell foul of the "Title Field Required" error and the PitchApplicantCount column is not incremented.

Patch( 'Pitch Submissions', Defaults ('Pitch Submissions'), {PitchApplicantCount: Value( First( Sort( 'Pitch Submissions', "PitchApplicantCount", "Descending" ) ).PitchApplicantCount ) + 1 } );

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @marsdendd ,

Please check whether your Title column in required.

If your Title column is required, you should patch with the Title column's value, or else the record will not update successfully.

You could check this here:

To solve this problem, you have two ways:

1)patch with Title value

for example:

Patch( 'Pitch Submissions', Defaults ('Pitch Submissions'), {PitchApplicantCount: Value( First( Sort( 'Pitch Submissions', "PitchApplicantCount", "Descending" ) ).PitchApplicantCount ) + 1, Title:.... } );

2)change Title column not required.

Please choose Title column , choose "require this column contains information"

Then this column will not be required.

Best regards,

Was this reply helpful? Yes No
Verified answer

marsdendd 68 on at

Like (0)

Report
Copy link

Link copied!
Thanks to those who responded.

I was over thinking it.

I ended up taking a far simpler route and using CountRows.

CountRows(Filter('Pitch Applicants',Title = ThisItem.Title))

Was this reply helpful? Yes No