News and Announcements icon

Power Platform CommunityForums Building Flows Select an object entry...

Building Flows

Answered

Select an object entry according to a variable value

(2) Share

Report

Report

Posted on by SP-04091518-0

30

Hi there,

I want to select a column from a object dropped from a teams list. the column name depend on the current date.

The flow is triggered every sunday at 11:00 pm.

From current date I get the week number, and I create a variable with the column name I want to select in the

I want to use this variable to select the column I want in my object, to then get the data from this column

Is there a way to perform such a dynamic column selection?

thanks!

Categories:

Business Process Flows

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

SP-04091518-0 30 on at

Like (0)

Report
Select an object entry according to a variable value

I create an array "dynamicFields' with all the possible fields ['week1', 'week2', ..., 'week42']

I set up the current week number in the variable "reportNumber"

then I used the select action:

my object as input

map is set up with a function:

item()?[variables('dynamicFields')[variables('reportNumber')]]
SP-04091518-0 30 on at

Like (0)

Report

Select an object entry according to a variable value

all right, this is my flow:

here is a sample of what comes out of the "get item" action. I have 24 entries and I want to select one of them
Suggested answer

FLMike 23,258 on at

Like (0)

Report

Select an object entry according to a variable value

Hi,

Please provide actual examples with visuals. just sorta tossing out details is not enough and too much to ask of people.

Make it super simple for us to answer by providing step by step, with actual details so we can help you 1 time :-) and get you sorted.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 140,719

#2

RandyHayes 76,308

#3

Pstork1 63,355

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans