Patching an email address into a sharepoint list, criteria is set by and ID field - then should update all fields that match the ID.

(0) Share

Report

Posted on by Jeffrey_H

118

So I'm trying to accomplish a couple of things.

First:

A. I have a text input box on a (Thank You) screen and a user would type in their email address and click a button to patch it to the sharepoint list.

1)Criteria for where to record is that an input box on the 2 screen (Lookup Info Screen) matches an ID number in the SP list.

What I have for a button to patch this info to a SP List:

DisplayMode = If(Not(IsMatch('TxtInput-StEmailAddress'.Text, Match.Email)), DisplayMode.Disabled, DisplayMode.Edit)

OnSelect = Patch('ThankYouCardList-Student-Donor', LookUp('ThankYouCardList-Student-Donor', Student_ID = sbox - ID),{TxtInput-StEmailAddress: {TxtInput-St_Email'})

part of the Sharepoint list"

as you can see there can be multiple records this email address needs to be patched into.

This is the screen that the "ID" gets checked against the SP list.

The Type ID here input box is then verified with an existing record in the SP list. I call this input text box "sbox - ID"

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Jeffrey_H ,

I am assuming some control names here, and the field names are based on your image, but it should be something like

UpdateIf( 'ThankYouCardList-Student-Donor', Student_ID = 'sbox - ID'.Text, {St_Email: 'TxtInput-StEmailAddress'.Text} )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Jeffrey_H 118 on at

Like
a
(0)

Report
Copy link

Link copied!
The code you suggested did not work.

UpdateIf( 'ThankYouCardList-Student-Donor', Student_ID = 'sbox - ID'.Text, {St_Email: 'TxtInput-StEmailAddress'.Text} )

Just checking to see if your code should go into "OnSelect" ? That's where I believe it should go.

UpdateIf('ThankYouCardList-Student-Donor', StudentID = 'sbox - ID'.Text, {St_Email: 'TxtInput-StEmailAddress'.Text})
I tried this too since the column header was different.
This did not work either.

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jeffrey_H ,

The code is updating any records in 'ThankYouCardList-Student-Donor' where the Student_ID field matches the value in the Text box 'sbox - ID' and then updates the St-Email field in those records to the value in the text box 'TxtInput-StEmailAddress'. If this is all correct, the code needs to go anywhere that OnSelect of the relevant button.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Jeffrey_H 118 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry to say that your code did not work for me.

Was this reply helpful? Yes No
Jeffrey_H 118 on at

Like
a
(0)

Report
Copy link

Link copied!

I copied the app and exported my Sharepoint list (in an excel format) so you can take a look at the whole picture.
I do understand that Excel and Sharepoint may take different code to communicate with the application, however please give me sample code for updating a Sharepoint list.

Thankyoucardlist-...
Student Thank You...

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Jeffrey_H ,

That is because your field name is Email (not st-email as you posted)

UpdateIf( 'ThankYouCardList-Student-Donor', Student_ID = 'sbox - ID'.Text, {Email: 'TxtInput-StEmailAddress'.Text} )

Was this reply helpful? Yes No