Answered

How to have a field in a concat expression

(0) Share

Report

Posted on by JBennett12

212

I have a unique value for Title, it's being used as a key for items that I'm looking up in power apps. I'm trying to create a new item in my sharepoint list and need to retrieve the specific title. There's probably an easier way to do this, but this is what I came up with. How do I add a field to my concat() expression that way I can put together the Title (key) for my field?

Thank you,

Categories:

Building flows

All responses (3)

Answers (1)

Sort by

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@JBennett12

Can you explain a little more about what you need. Is your question how to use the concat() expression or how to retrieve a list item with a specific title from a SharePoint list?
JBennett12 212 on at

Like
a
(1)

Report
Copy link

Link copied!

@ScottShearer
Sorry my fault, I'm trying to have the Title field in my create item step contain the 'WorkArea' of the item its getting as well as the month and year all together. Example) "HR62022". Where WorkArea = HR, Month = 6, and
Year = 2022. These values will come from my WorkArea field and Date field.
My question is, I can choose any of the fields I want for Title, however when I use the concat() function. The only choice I get is body and value. I'm still new to power automate, and I'm not sure how to populate the field with what I want. I will post pictures below of each.

Thank you
Verified answer

JBennett12 212 on at

Like
a
(3)

Report
Copy link

Link copied!

@ScottShearer
I was actually able to fix it. I thought like traditional coding I would need the variable inside my concatenation function. Instead I just needed to use the SP field first then use the concat expression.
Thank you for trying to help!