get the share point one column data as Choices column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

is there any way to get the share point one column data?

There is one list A which has column Study.

Study

There is an other list B which has the Choices column study which has the choices(A,B).

I would like to get the Study of A list data as the choices for study of B list.

Is there any way to realize this?

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey @Anonymous

Can you share more details on the scenario that you are trying to build? You can get the column data from a list by using the Get Item or Get Items actions. Post that you can configure consecutive actions to use the data retrieved from the above actions from the dynamic content. If you want to use the column items from List A to update List b, you can reference the same from the dynamic selector while using the update or create item actions. If you can share more details, we might be able to assist you better.

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 (0)

Report
Copy link

Link copied!

@yashag2255 Thank you for your response.
Please kindly check the screenshot.
I want to update the choices of Study Name 333(choice column) .
I get items from other list and get the Title data by using item()?['Title'].
And the outcome is as picture 2.
When I click pull-down, it is still the original data(1,2,3).

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

If your goal is to change the options avaiable in the option column, there is no "out of the box" Flow action that allows you to accomplish that goal. You can probably update the available option values by using the Send an HTTP request to SharePoint action and call a SharePoint web service.

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

Like (0)

Report
Copy link

Link copied!

hi @ScottShearer

Thank you vey much.

I tried to use Send an HTTP request, could you please kindly help confirm whether it is written correcly since error happened as below.
"message": "Invalid JSON. A comma character ',' was expected in scope 'Object'. Every two elements in an array and properties of an object must be separated by commas.\r\nclientRequestId: 23756ab0-0ebc-4a7e-8949-9dfef2355069\r\nserviceRequestId: f2af0e9f-f0d0-9000-742e-7b85eef6fe53",

Body:
{
"StudyName333":
{
"@odata.type":
"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Value": "@{outputs('Compose')}"
}
}

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

Like (0)

Report
Copy link

Link copied!

Add:
The outputs of Compose is as below:

[
{
"Value": "0906"
},
{
"Value": "MK123 test2"
},
{
"Value": "MK456"
},
{
"Value": "4444"
},
{
"Value": "4"
}
]

Was this reply helpful? Yes No