Unanswered

Syntax Yes/No Choice in Collection (Dataverse)

(0) Share

Report

Posted on by FC71

I'm using Collection to Patch records into a table where an event uses multiple locations so all the user has to do is select multiple locations from combos and I create 1 collection per location but I'm stuck on the Yes/No syntax which returns question marks for the Choice fields. (and can anyone tell me what language to select when inserting a code sample?)

INPUT

ClearCollect(Loc1Record,

{eLuContact: dcvContact.Selected.cOwner,

eType: dcvEtype.Value,

eConfirmed: dcvConfirmed.Selected.Value,

eLuLocation: dcvLoc1.Selected.Location_id,

ePax: dcvPax.Text,

Edate: dcveDate.Value,

eStartDateTime: dcvStartDate.Value + Time(Value(dcvStartHour.Selected.Value), Value(dcvStartMinute.Selected.Value),0),

eEndDateTime: dcvEndDate.Value + Time(Value(dcvEndHour.Selected.Value), Value(dcvEndMinute.Selected.Value),0),

MultiLocation: MLdcv.Selected.Value,

eNotes: dcveNotes.Value,

eSetup: dcvSetup.Selected.Value,

eClearing: dcvClearing.Selected.Value,

eSetupNotes: dcvSetupNotes.Value})

OUTPUT

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

AhmedSalih 6,678 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello, @FC71, the syntax to capture Choice field of a SharePoint Choice Column as follows: (Note choices in SP are records)

ChoiceColumnName: {Value: ComboBox.Selected.Value}

Try this for your Formula:

ClearCollect(Loc1Record, { eLuContact: dcvContact.Selected.cOwner, eType: dcvEtype.Value, eConfirmed: {Value: dcvConfirmed.Selected.Value}, eLuLocation: dcvLoc1.Selected.Location_id, ePax: dcvPax.Text, Edate: dcveDate.Value, eStartDateTime: dcvStartDate.Value + Time(Value(dcvStartHour.Selected.Value), Value(dcvStartMinute.Selected.Value), 0), eEndDateTime: dcvEndDate.Value + Time(Value(dcvEndHour.Selected.Value), Value(dcvEndMinute.Selected.Value), 0), MultiLocation: MLdcv.Selected.Value, eNotes: dcveNotes.Value, eSetup: {Value: dcvSetup.Selected.Value}, eClearing: {Value: dcvClearing.Selected.Value}, eSetupNotes: dcvSetupNotes.Value })

If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

Visit my Blog: ahmedsalih.blog

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

Was this reply helpful? Yes No
FC71 9 on at

Like (0)

Report
Copy link

Link copied!

Hi Ahmed, this didn't make any difference, possibly because it's Dataverse, I'll add the dataverse tag to my question and tags. Appreciate your help

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report
Copy link

Link copied!

@FC71, that change things. I will move this question to the Dataverse Forum. In the Canvas app, can you check the collection and see if you see the choices values before the Patch?

If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

Visit my Blog: ahmedsalih.blog

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

Was this reply helpful? Yes No