cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ahmedk2021
New Member

how to get value of field in Dataverse table by field name

I'm building flow that generate sms message that will take some parameters (for example: name if entity account and fullname if entity is contact) 

the problem I faces that I'm need to send column name as parameter and while generate sms message get name from account entity or fullname from contact

 

1.png

where parameter value display as string as

clint: @{items('Apply_to_each_Account_-_dynamic')?['name']}

 

I need to send the previous string in runtime and flow understand as in image 

3 REPLIES 3
PrasadAthalye
Super User
Super User

It should work as you have entered in the expression. One other way is to use Concat function and concat both string expressions.... Something like below...

 

concat('Test', outputs('Create_file')?['body/DisplayName'])
Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
ahmedk2021
New Member

I tried to use "concat" expression but still nothing happened, value of

concat('client:', @{items('Apply_to_each_Account_-_dynamic')?['name']}) become 

"client: @{items('Apply_to_each_Account_-_dynamic')?['name']}"

not

"client: account name"

 

it still understant "@{items('Apply_to_each_Account_-_dynamic')?['name']}" as string

Can you try following?

 

concat('client:', items('Apply_to_each_Account_-_dynamic')?['name'])

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

PWREduCon768x460.png

Join us at PWR EduCon - A Power Platform Conference

Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Users online (2,245)