Answered

Patch a dropdown in SharePoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I'm trying to patch a dropdown column in a Sharepoint list with 2 arguments : "A envoyer" and "Envoyée" ('To send' and 'Sent'). I would like to modify all the status of my mail communications with "A envoyer".

However, I get the error message: The type of this argument 'Statut' does not match the expected type 'Record'. Found type' Text'.

Does anyone have an idea?

Thanks in advance!

The picture is my Gallery

ForAll(Gallery1_1.AllItems; 
Patch(Communications; 
First(Filter(Communications;Title=Label13_1.Text)); 
{Statut : "A envoyer"}))

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

jhall 636 on at

Like
a
(0)

Report
Copy link

Link copied!

https://powerusers.microsoft.com/t5/General-Discussion/How-to-Save-Choice-field-value-using-UpdateIf-Patch-functions/td-p/28338

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

Can you try to modify your expression as:

ForAll(Gallery1_1.AllItems; Patch(Communications; First(Filter(Communications;Title=Label13_1.Text)); {Statut : LookUp(Choices(Communications.Statut);Value = "A envoyer")}))

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

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

Like
a
(0)

Report
Copy link

Link copied!

Thank you!
Couldn't write the formula correctly with 'choices' or '#Microsoft.Azure'.

This one is simple and works perfectly 🙂

Was this reply helpful? Yes No