cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Add fields to gallery based on dataflex table

Hi everyone,

 

I'm currently having some issues with the following scenario:

- I have a dataflex table that contains all months (January - December)

- I can select a start and end month

- I then created a gallery and filterered all items based on the selected start and end months

- I have a number field and that number is equally divided into all months

powerapps_problems.png

I have added checkboxes and also plan to enable the edit mode of the input field, to allow users to split the costs differently for each month.

 

Unfortunately I cannot use If(ThisItem.CheckboxName.Checked; DisplayMode.Edit; DisplayMode.View) to enable/disable the DisplayMode. I can only use the columns/values that are stored within my dataflex table. I can also not modify the value of my checkbox in preview mode or access ThisItem.

 

Am I missing something?

 

Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
Memorable Member
Memorable Member

Hi @Nilsnutz 

 

Use this formula for DisplayMode of the TextInput inside Gallery:

 

If(CheckboxName.Value; DisplayMode.Edit; DisplayMode.View)

 

Please show me the error you get here:

Capture.PNG

View solution in original post

2 REPLIES 2
Memorable Member
Memorable Member

Hi @Nilsnutz 

 

Use this formula for DisplayMode of the TextInput inside Gallery:

 

If(CheckboxName.Value; DisplayMode.Edit; DisplayMode.View)

 

Please show me the error you get here:

Capture.PNG

View solution in original post

Thanks for your input. That solution worked. However i found that my the controls I am currently using are not working as expected. My app is a Teams Powerapp and I had to activate classic controls to use the .Value property. The "new" checkbox controls have a .checked property, but I cant check/uncheck it in preview mode.

 

The errormessage in Start Month is just work in progress. I was trying to clear the endmonth value if my startmonth value is changed an now higher but didnt finish that yet.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,041)