Append custom filed value to drop down selected value

(1) Share

Report

Posted on by allyb123

148

Team,

I would like to append a custom field(No of hours) with drop-down selected value while submitting the form. For Example, in the screenshot below, I would like to capture "Understanding the process flow - 2.5 hours" in the SharePoint. Please help.

Regards,

Alwin

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@allyb123

Put a new hidden custom DataCard, to hide it, for the Visible property use

false

for the Update property of this new hidden DataCard, you can put

TitleDataCard.Value & " - " HoursDataCard.Value

For the DataField property put name of the column that you want to capture it in SharePoint.

See if it helps @allyb123

Was this reply helpful? Yes No
allyb123 148 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks for checking @poweractivate .
I am sorry to ask you a basic question. When I add a custom datacard I don't see the Update Property. Please help.

Regards,
Alwin

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@allyb123

Let's remove the custom Datacard.

Instead, 1. select the Form, 2. click Edit Fields at the top and 3. click Add Field.

and then 4. Select the SharePoint Field you want from the list of fields so the box is checked and 5. Click Add

Now just edit that generated datacard

6. for the Update property of this new hidden DataCard, you can put

TitleDataCard.Value & " - " HoursDataCard.Value

6b. You may want to use the above formula for the Default property of this Data Card as well.

7. for the DataField property, leave it alone - it's automatically correct now due to the first 5 steps.

8. If you want, put Visible to false and then resize the control so it's very small and not interactable by mistake to cover up other Data Cards, and move it off to the side somewhere - also send it to the very back as well in case in the tree view if you want so it can't be interacted with even if it's accidentally on top of another Data Card.

see if this works better @allyb123

Was this reply helpful? Yes No
allyb123 148 on at

Like
a
(1)

Report
Copy link

Link copied!

I already brought all the required fields to the edit form. The Plan dropdown is the one for the Plan field in the SharePoint which I would like to update along with the No of hours value.

Was this reply helpful? Yes No
Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@allyb123
If Plan is a Choice column in SharePoint behind the scenes, I believe you cannot do that actually, you'll need to create a new Text column in SharePoint or else you probably won't be able to do this.

If it's a Text field, you may be able to do it by changing the Update property of the Plan Data Card and just append this to the end of what's already there

& " - " HoursDataCard.Value

Was this reply helpful? Yes No
allyb123 148 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks, @poweractivate . That's what I am planning to do. Appreciate your help.

Was this reply helpful? Yes No