web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Dropdown values not pa...

Power Apps

Answered

Dropdown values not patched correctly in the shareoint

(0) Share

Report

Report

Posted on by MostafaGamal

Hi All,

I have a gallery with dropdown menu (0,1,2,3)

i use the following formula to patch the choices from the dropdown into the SP but the data didnt store correctly, how to solve this

{Safe111:[@Safe].Selected.Value,UnSafe111:[@Unsafe].Selected.Value}

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

RishabBehl31 180 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @MostafaGamal ,

You can try using the below formula:

Patch(SharepointlistName, Default(SharepointlistName) or use any filter formula you want to, {Column1Name : Dropdown1.SelectedText.Value, Column2Name : Dropdown2.SelectedText.Value, ...., Till nth column}).

Hope it helps & simplifies.

Warmly. 🙂
----------------------------------------------------------------------------------------------------------------
Thanks for taking my inputs. If you're digging into it, a Thumbs up is appreciated! Or if my suggestion solved your issue, please Accept it as a solution. This way everyone would be able to get the solution if they face a similar problem
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@MostafaGamal,
Based on the issue that you mentioned, do you want to patch Dropdown selected to the SP list?
Could you please share a bit more about the scenario:
are those columns corresponding to the Dropdown Choices type?
do you want to create new records or update the existing records?
I assume that those are Choices type and you want to create new records.
I have a test on my side, please take a try as below.
Set the Items property of the Dropdown as:

Items property: Choices(Safe.Safe111) Default property: LookUp(Safe,ID=ThisItem.ID).Safe111.Value

Add a Button and set the OnSelecte property as below:

Patch( Safe, Defaults(Safe), { Safe111: {Value: Dropdown1.Selected.Value}, Safe222: {Value: Dropdown2.Selected.Value} } )

Note: If those columns corresponding to the Dropdown are Text type, you could modify the formula as below:

Patch( Safe, Defaults(Safe), { Safe111: Dropdown1.Selected.Result, Safe222: Dropdown2.Selected.Result } )

Hope it could help you.
Best Regards,
Qi

Join the conversation