Concat with values in DB

(0) Share

Report

Posted on by BaptisteP

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 (3)

Answers (1)

Sort by

WarrenBelz 155,779 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

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 155,779 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@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