get the share point one column data as Choices column

(0) Share

Report

Posted on by Community Power Pla...

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:

Business Process Flows

All responses (5)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: get the share point one column data as Choices column

Add:
The outputs of Compose is as below:

[
{
"Value": "0906"
},
{
"Value": "MK123 test2"
},
{
"Value": "MK456"
},
{
"Value": "4444"
},
{
"Value": "4"
}
]
Community Power Pla... on at

Like (0)

Report

Re: get the share point one column data as Choices column

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')}"
}
}
ScottShearer 25,208 Most Valuable Professional on at

Like (0)

Report

Re: get the share point one column data as Choices column

@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.
Community Power Pla... on at

Like (0)

Report

Re: get the share point one column data as Choices column

@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).
yashag2255 24,442 Super User 2024 Season 1 on at

Like (0)

Report

Re: get the share point one column data as Choices column

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!