web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Concat with values in DB

Power Apps

Answered

Concat with values in DB

(0) Share

Report

Report

Posted on by BaptisteP

67

Hi everyone,

I'm pretty new on PowerApps, and I need help to set DefaultValue in one of my forms :

I got a card, and I want its default value to be the concatenation of today's date and a value stored in my db at [dbo].[numberIndic].

What I've tried so far :

Concatenate(Text(Today();"yyyymmdd");<here the value from table>)

How can I do this ?

Thanks !

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report
Hi @BaptisteP,
Assuming that the DataSource of the Form that is housing your DataCard is based on the table [dbo].[numberIndic],, you would have something like
Text(Today();"yyyymmdd") & ThisItem.YourFieldName

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
BaptisteP 67 on at

Like (0)

Report

Thanks for you answer @WarrenBelz !
But actually my form is based on an other table, is there a way to get that value anyway ?

Or maybe I can use the ID value from the current table, but since the row isn't yet generated I do not know how to retrieve the ID that will be generated with the validation of the form.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report

@BaptisteP ,
That is a bit different subject to what you posted.
You can use a Lookup to the other table if you have a common key to the form, or you can retrieve the ID of a new record with YourFormName.LastSubmit.ID

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No

Join the conversation