How to Output Sharepoint List Row Data

[B_Rax]

Hi, I'm currently trying to create a flow with which I can specify a JobID and then get back the list of values from its row in a sharepoint list. This is a list of permissions based on JobID and will be changed fairly frequently, so manually typing column names and using dynamic content for the values isn't the most viable solution for me.

I see in dynamic content all of the values I am interested in and their proper column names, but I can't find out how to iterate across them and, for example, append them all to a string variable like:
JobClassID: Value
EMPCNT: Value
Payroll Access Setup: Value

This step is only part of a larger process of creating planner tasks. This generated list of permissions will be later used to create a check list in Planner. I also have the table as an excel sheet if it would be easier to utilize than a list.

[wyattdave]

Hi @B_Rax ,

to get the columns you can use below api all to list all of your columns

/_api/web/lists/getbytitle('<list title>')/fields?$filter=Hidden eq false and ReadOnlyField eq false

 Use the SharePoint HTTP connector and then loop over each field within the get items loop.

You can then use dynamic variables to select them, ive written blog here https://dev.to/wyattdave/power-automate-dynamic-variables-4mb0 

>----------------------------------------------------------------------------------------------------------------------------------------------
If this helped solve your question please mark it as the solution.

I also do a weekly Power Platform blog at https://dev.to/wyattdave

[Andrew_J]

@B_Rax 

Would SELECT be what you are looking for, for the below:

JobClassID: Value
EMPCNT: Value
Payroll Access Setup: Value

If not then please advise.

Andrew

[B_Rax]

I have considered select, but while it does achieve the desired layout it would also require each column to be manually typed and then later managed as the list is added to and removed from. The final flow will be looking across more than 100 columns. I need a method of dynamically listing all column names and their values for a given row. 

[B_Rax]

Hi, I'm working on implementing your solution. I am not exactly sure how to apply the dynamic variables yet, but am trying to simply list the column names first. I've made the HTTP request and Parsed the JSON using a sample payload. However, I've been unable to iterate on the output to create an array of the column titles.