Answered

Error on patching data in Sharepoint list from Powerapps for dropwdown

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

So i already have a column name on my sharepoint list. I already tested this out without the dropdown function and just inputting text. It works out fine but then i wanted to add a new function where there is a dropdown button consisting of values. i wanted to add them and patch whatever is selected on the dropdown button to the sharepoint list.

Heres the code:

If(
 !IsBlank(start_inputfield.Text) && !IsBlank(session_dropdown.Selected.Value),
 Patch(
 HRProject_Start,
 Defaults(HRProject_Start),
 {
 'Session Name': session_dropdown.Selected.Value,
 Email: User().Email,
 Text: start_inputfield.Text,
 'Date and Time Submitted': Text(Now(), "mm/dd/yyyy hh:mm")
 }
 )
);

It doesnt give a hint on which errors it is. Here's a picture

hoping for your help. thanks a lot

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Please try:

If( !IsBlank(start_inputfield.Text) && !IsBlank(session_dropdown.Selected), Patch( HRProject_Start, Defaults(HRProject_Start), { 'Session Name': session_dropdown.Selected.Value, Email: User().Email, Text: start_inputfield.Text, 'Date and Time Submitted': Text(Now(), "mm/dd/yyyy hh:mm") } ) );

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @v-bofeng-msft , i just found out that the selected value im using is not Text and since my sharepointlist is on Text datatype. it gives an error. So i made a solution of adding Text(). but then it still gives an error.

The values i used for dropdown is coming from a table on a excel sheet.

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

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

The point is that there is no such a property named 'Value' in session_dropdown.Selected . Please check the items property of the session_dropdown and confirm which field you need to reference.

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

So this is my dropdown

from the excel sheet. in table 1 i used the session title column

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Please try:

If( !IsBlank(start_inputfield.Text) && !IsBlank(session_dropdown.SelectedText.Value), Patch( HRProject_Start, Defaults(HRProject_Start), { 'Session Name': session_dropdown.Selected.SelectedText.Value, Email: User().Email, Text: start_inputfield.Text, 'Date and Time Submitted': Text(Now(), "mm/dd/yyyy hh:mm") } ) );

Best Regards,

Bof

Was this reply helpful? Yes No