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

How to save dropdown selected item to Sharepoint list as single text

Hi,

 

I created a dropdown for hours and minutes and the values are hard-coded.

 

hour_minute.jpg

I want to save this selected value in Sharepoint list as single text.

I already created a column in Sharepoint list and trying to patch it.

 

 

 

 

If(varMode = "New",

//Patch the Title and Choice and get the list ID
Set(TempCol, Patch(QAOversightApp, Defaults(QAOversightApp),
{
    Date:DataCardValue5_2.SelectedDate,
    Room: DataCardValue6_2.Selected,
    Activity:DataCardValue3_2.Selected,
    Comment:DataCardValue4_2.Text,
    Hour1:HourValue1_3.Selected.Value,
    Minute1: MinuteValue1_3.SelectedText.Value

}));
//Update with patch function the attachment 
Patch(QAOversightApp, LookUp(QAOversightApp, ID = TempCol.ID),
{

}, Form1_2.Updates);
varMode="Edit", SubmitForm(Form1_2));
Back()

No errors but I didn't save anything in the Sharepoint List.

 

What am I missing?

 

Any help is appreciated! Thanks! 🙂

3 REPLIES 3
zmansuri
Super User
Super User

if Hour1 is Text type column this line should store text value in it.

Hour1:HourValue1_3.Selected.Value

 

For debugging try storing columns one by one. So you can narrow down to the column that's causing problem

 

 

Hi,

 

Thank you for your reply.

 

I tried to use "Text" instead "Selected.Value". It gives me error because I used dropdown.

 

Any work around suggestion?

 

Thanks again,

May

a5.jpga6.jpg

 

Selected Value is the correct code that's why i told you to try saving one line at a time. So you'll narrow down the root cause of the problem

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

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