Unanswered

How to save dropdown to SharePoint list

(1) Share

Report

Posted on by I0-23070210-0

My dropdown is in a gallery and will loop together with other fields in a row. But I cant seem to configure the dropdown. The dropdown value is Yes/No. What is the best way to do it? Using Patch/Collect function? The errors are at the OnChange and Default.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

A_Madsen 67 on at

Like (1)

Report
Hello!

Try changing your formulas to these values, and see if that solves the problem.

Default:
If(ThisItem.YesNo = true, "Yes", "No")

Onchange:

Patch(ARepeatingSectionCollecton, LookUp(ARepeatingSectionCollecton, Id = Gallery3_1.Selected.Id), {YesNo: If(ADropdownYesNo.Selected.Value = "Yes", true, false)})

------------------------------------------------------------------------------------------------------------------------------
If I have solved your problem, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report
hey

can u try this:

Patch( ARepeatingSectionCollection, ThisItem, {PassThroughRingGage: ADropdownYesNo.Selected.Value} )

For the default property set it to:

ThisItem.PassThroughRingGage

If the Post help you solve your issue, please mark it as verified answer and give it a like so we can help other in the community with similar issues

Greetings

Was this reply helpful? Yes No
Suggested answer

I0-23070210-0 20 on at

Like (1)

Report

@A_Madson

Hi, I tried the formulas you have suggested. The formula for the OnChange seems fine for me but for Default its saying "Name isn't valid. YesNo isn't recognized." and "incompatible types for comparison" for this =

Was this reply helpful? Yes No
I0-23070210-0 20 on at

Like (1)

Report

@mmbr1606

Hi, I also tried yours, but for both formulas I got the "Name isn't valid. Name isn't recognized". I used the name Pass Through Ring Gage in my SP list, but in my power apps that name sometimes valid sometimes not, thus I've rename it in power apps as YesNo. Pass Through Ring Gage is in the same SP list as Top1, Top2, Top3 and so on, the others field is recognized, but the Pass Through Ring Gage isn't. I don't know why.

Was this reply helpful? Yes No
A_Madsen 67 on at

Like (1)

Report
@I0-23070210-0

Is your SharePoint column a Yes/No column? Or is it just a text column?

If it's a Yes/No column it should work. However, it seems that your SharePoint column is called 'Pass Through Ring Gage' and not 'YesNo'. In that case the function should look like this:

If(ThisItem.'Pass Through Ring Gage' = true, "Yes", "No")

Was this reply helpful? Yes No