Power Platform Community Forum Thread Details

Hi Sir, I am currently working in a task where the in the first screen user enter the data in the text box from the power apps and the entered data get saved in the "user input" data verse table column name(Text data). Then in the second page the user select the template(pasted above and for now created the function design specification) whatever option they need and the data in the table are already predefined that is the column names are template name and template toc. For the UI I have created gallery and check box inside the gallery. So in check box I have to integrate user input table and the template they choose from template data table. how to do that. Need the functionality in the checkbox that when I select the template name from the template data then user input table should be single data verse table. How to relate it .Help me with this sir .Its urgent . I want the power apps formula to know how to relate.

User Input table(Table 1)

Context id	Text data
01	Some kind of multiple text data
02	Some kind of multiple text data
03	Some kind of multiple text data
04	Some kind of multiple text data

Template data(Table 2 Static data)

Template Name	Template toc
Meeting Minutes	The table of context( Meeting Minutes )
Scope of work	The table of context(Scope of work)
Meeting Minutes	The table of context( Meeting Minutes )
Scope of work	The table of context(Scope of work)

integrate both into single table:

Context id	Text data	Template Name	Template toc
User1 01	Some kind of multiple text data	Meeting Minutes	The table of context( Meeting Minutes )
User2 02	Some kind of multiple text data	Scope of work	The table of context(Scope of work)
User3 03	Some kind of multiple text data	Meeting Minutes	The table of context( Meeting Minutes )
User4 04	Some kind of multiple text data	Scope of work	The table of context(Scope of work)