Answered

how to update sql table by submit button

(0) Share

Report

Posted on by Xiangchen_2019

Hi,

I want to click submit button , then the SQL DB table will be updated by studentID.TEXT and EventID from Event fropdown.

the below datatable could be refreshed aftyer submit button clicked. And the confirmed student's row will have the confirmed checkedbox to be checked.

I do not know how to setup this submit button to get the aboved action works.

I have tried patch function, it does not work for me for somereason.

Patch('[Stage].[Adv_Advising]',First(Filter('[Stage].[Adv_Advising]',StudentID = StudentID.Text and event_id = Dropdown1.value )),{Registered_ind:1})

Much appreciated!

Attachements are the screenshots of the app and table of SQL table.

Xiang

Categories:

Building Power Apps

I have the same question (0)

All responses (21)

Answers (1)

Sort by

RezaDorrani 12,145 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Xiangchen_2019

Patch('[Stage].[Adv_Advising]',First(Filter('[Stage].[Adv_Advising]',StudentID = StudentID.Text and event_id = Dropdown1.value )),{Registered_ind:1})

Firstly, First(Filter can be replaced by Lookup (more efficient way)
Lookup('[Stage].[Adv_Advising]',StudentID = StudentID.Text and event_id = Dropdown1.value )

So your patch can look like:

Patch('[Stage].[Adv_Advising]',
Lookup('[Stage].[Adv_Advising]',StudentID = StudentID.Text and event_id = Dropdown1.value )
,{Registered_ind:1})

Next, check to see if Lookup('[Stage].[Adv_Advising]',StudentID = StudentID.Text and event_id = Dropdown1.value ) matches an item in SQL to update, if it does not find a record, then it cannot patch/update your item

Add a label(for testing only) and set its text property to
Lookup('[Stage].[Adv_Advising]',StudentID = StudentID.Text and event_id = Dropdown1.value ).StudentID
If this does not get the student id, that means this function is not returning/matching any item in ur sql table

Alos, Dropdown1.value - should probably be Dropdown1.Selected.Value

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
Xiangchen_2019 70 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RezaDorrani

Thanks for the reply.

May I know for how to setup the Value and text differently in dropdown in powerapps. I only found value as properties of dropdown, not find ID. Not sure where I can pas the event_id in dropdown?

Thanks a lot,

Xiang

Was this reply helpful? Yes No
RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

@Xiangchen_2019

Share screenshot of items property for events dropdown

Was this reply helpful? Yes No
Xiangchen_2019 70 on at

Like
a
(0)

Report
Copy link

Link copied!

sure, see attachment

Was this reply helpful? Yes No
RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

@Xiangchen_2019

If you try dropdown.Selected. (intelicense should show your other properties associated with the data source)
try it out

Was this reply helpful? Yes No
Xiangchen_2019 70 on at

Like
a
(0)

Report
Copy link

Link copied!

@
RezaDorrani ,I got ID listed after I try dropdown.Selected. . But I do not know where to assign the dropdown list ID to be the event_id from SQL table?

Was this reply helpful? Yes No
RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

@Xiangchen_2019

Patch('[Stage].[Adv_Advising]',
Lookup('[Stage].[Adv_Advising]',StudentID = StudentID.Text and event_id = Dropdown1.Selected.event_id)
,{Registered_ind:1})

This should enable you to do the patch

Was this reply helpful? Yes No
Xiangchen_2019 70 on at

Like
a
(0)

Report
Copy link

Link copied!

RezaDorrani,

It keep saying not the same type.

Was this reply helpful? Yes No
RezaDorrani 12,145 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Xiangchen_2019

Add a label(for testing only) and set its text property to
Lookup('[Stage].[Adv_Advising]',StudentID = StudentID.Text and event_id = Dropdown1.value ).StudentID
If this does not get the student id, that means this function is not returning/matching any item in ur sql table

Did u try this?
with your query
Is it returnign a value?

Was this reply helpful? Yes No
Xiangchen_2019 70 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RezaDorrani ,

I have tried lable, the formular throw the error too.
see screenshot:

Was this reply helpful? Yes No