Sharepoint list item creation from appointment

(0) Share

Report

Posted on by DC-13121302-0

Hi!

I have been trying to create a item in a sharepoint list from an booking page appointment creation trigger.

I have already tested and it is creating the item, but I need some information inputted into it, and I'm struggling with it.

The appointment has some custom questions, one of which is "Type", and the customer select the answer from a list of options.

I'm trying to make a Select from the appointment, mapping both questions and answers, but when I try to compose them, specifically to 'Type' (index 2), I can't really do it.

Selection:

From: @triggerOutputs()?['body/CustomQuestionAnswers']
Map:
Questioon: @item()?['Question']
Answer: @item()?['Answer']

Compose:

@outputs('Select')[2]['Answer']

and then referencing the Compose Output at the create sharepoint item action.

I'm using Copilot for support and already tried many alternatives in order to do it (defining variables, parsing JSON etc.), but still no success.

Is there a way of referencing the specific answer?

I can provide more information if needed.

Categories:

Business Process Flows

I have the same question (0)

All responses (2)

Answers (0)

Expiscornovus 32,932 Most Valuable Professional on at

Like (1)

Report

Sharepoint list item creation from appointment

Hi @DC-13121302-0,

Can you share a screenshot of the Select outputs? That would be useful for troubleshooting.

Just want to double check if the Type is in fact the third item of your array. (Index starts counting at 0. So 0 is item 1, 1 is item 2, 2 is item 3, etc.)

Was this reply helpful? Yes No
DC-13121302-0 2 on at

Like (0)

Report
Sharepoint list item creation from appointment

Expiscornovus hi, thanks for your reply.

There's 2 outputs from the Select:

Output:

[ { "Question": "Meeting link", "Answer": "https://google.com" }, { "Question": "TP Link:", "Answer": "https://google.com" }, { "Question": "Type", "Answer": "Custom" }, { "Question": "I have read and agree with the Wiki docs.", "Answer": "I have read and agree." } ]

Output item (which I have no idea what it is. Maybe it's a preview of each possible output if it were a "for each" loop or something?!):

{ "Question": "Meeting link", "Answer": "https://google.com" }

Then the Compose function fails and the error is:

InvalidTemplate
Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language expression 'outputs('Select')[2]['Answer']' cannot be evaluated because property '2' cannot be selected. Object properties can only be selected by names. Please see https://aka.ms/logicexpressions for usage details.'.

Was this reply helpful? Yes No