web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Add a template data so...

Power Apps

Unanswered

Add a template data source to existing collection

(0) Share

Report

Report

Posted on by jed76

Hi

Can anyone assist please?

I have a form which creates a line in a SP list. Part of the list includes space for a job number and job name. I’d like to be able to add a set number of pre-filled lines to this data source based on a choice. For example if the person chooses ‘job a’ it adds an additional six lines which are pre-filled from probably another SP list. My main question is how can I make sure that this works and each line which is added has the same job number and job name added as well?

Perhaps a hidden gallery which adds x number of lines but I also need to make sure the job name and job number get added too?

Many thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

BCBuizer 22,833 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @jed76 ,

To me your question seems to go against the rules of database normalization and basically just duplicate data, growing your database without good reason.

However, if you wish to proceed, you can insert a LookUp function in the default properties of the relevant datacards to:

With( {_ColumnValue: ThisItem.ColumnName}, If( IsBlank(_ColumnValue), LookUp(DataSource, JobTitle=ComboBox.Selected.JobTitle, _ColumnValue) ) )

Was this reply helpful? Yes No
jed76 on at

Like
a
(0)

Report
Copy link

Link copied!

What would you suggest as a better solution then? Many thanks.

Was this reply helpful? Yes No

Join the conversation