How to set value based on gallery select

(0) Share

Report

Posted on by mahmoodhsaud

202

Hi,

I have two galleries (gal1,gal2) on different screens gal 2 is an editable grid, in gal1 there's a field called ID I wanted to take the value of the selected field(ID) and populate in the Source ID field of gal2 but it should only add the values if a new field is created or it should take its default value

I used this formula "ondefault" property in the gal2 source id field.

If(
 defaultval,
 If(
 Value(sourceid) > 0,
 ThisItem.SourceId
 ),sourceid
)

Thanks in Advance

Regards,

Mahmood

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mahmoodhsaud ,

I don't quite understand your needs.

Could you provide some formulas/images or supplement your needs?

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
mahmoodhsaud 202 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @v-xiaochen-msft

I have two screens, screen1 and screen2. Each screen has a gallery on it, gallery1 and gallery2 respectively.
Each gallery's items property is pointed towards the different data source, a SQL table1, and table2.

In gallery1 onselect property, i have created a variable to store the value of selected rows (sourceid)
Set(sourceid,Gallery1.Selected.Source_Id_Label1.Text);Navigate(Screen6_1,ScreenTransition.Fade);

I have a button(addrow) on screen2 in which Onselect property has some function, used to add a row in the gallery 2
Set(varGridEditable1, true );Patch('DAP.SourceItem',Defaults('DAP.SourceItem'),{SourceItemName:""});

if the addrow button is clicked i need to set the value of source item id (textinput) of gallery2 to the variable sourceid (from gallery1) or by default the value should be ThisItem.SourceId

The below formula i have used on the Sourceid default property is not working
If(defaultval,If(Value(sourceid)>0,ThisItem.SourceId),sourceid)

Regards,
Mahmood

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @mahmoodhsaud ,

If you press the button and add a new item to table2, why don't you directly save the selected value in gallery1 to the item?

For example:

You could use this formula on your button control:

Set(varGridEditable1, true );Patch('DAP.SourceItem',Defaults('DAP.SourceItem'),{SourceItemName:"",SourceId:Value(sourceid)});

Then use this formula on Default property of your textinput control in gallery2:

ThisItem.SourceId

Does this meet your needs?

Besides, I don’t know what 'defaultval' is.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No