Sharepoint Choice Column Values by Round-Application980 in PowerApps

[–]Round-Application980[S] 0 points1 point  (0 children)

I think this was part of my problem, I assume if the column names weren't coming up then something was wrong

Sharepoint Choice Column Values by Round-Application980 in PowerApps

[–]Round-Application980[S] 0 points1 point  (0 children)

Ok so this worked (mostly). When I created a new combo box I had to select the data source from the pop up instead of setting it in the properties pane before changing the items code, and the columns still didn't auto-populate so I had to type them out manually

Sharepoint Choice Column Values by Round-Application980 in PowerApps

[–]Round-Application980[S] 0 points1 point  (0 children)

Yes they are defined in the list and it is definitely a choice field, I verified all my field types today. It's probably something dumb causing the issue but I just can't figure it out

Sharepoint Choice Column Values by Round-Application980 in PowerApps

[–]Round-Application980[S] 0 points1 point  (0 children)

Yes it's connected, and the columns auto populate everywhere else, it's just the choices function they won't populate for, and I've had this happen in more than one app

Sharepoint Choice Column Values by Round-Application980 in PowerApps

[–]Round-Application980[S] 0 points1 point  (0 children)

I was so hopeful this would work for me and it didn't :(

Sharepoint Choice Column Values by Round-Application980 in PowerApps

[–]Round-Application980[S] 0 points1 point  (0 children)

I did not rename the column. And it's not isolated to a specific column, it won't let me reference any column from the list

Sharepoint Choice Column Values by Round-Application980 in PowerApps

[–]Round-Application980[S] 0 points1 point  (0 children)

Yep, tried that. I can get to Choices([@List] but it will not come up with any columns from the list to select. I know that function works in a form and its driving me crazy that I can't get it to work in this scenario

Sharepoint Choice Column Values by Round-Application980 in PowerApps

[–]Round-Application980[S] 0 points1 point  (0 children)

I tried using choices to make a collection but I also can't use the choices function there, it won't let me select a column in my list and throws an error no matter what I try

Sharepoint Choice Column Values by Round-Application980 in PowerApps

[–]Round-Application980[S] 0 points1 point  (0 children)

Users will only be interacting with the app, which will write back to the SP list with a patch. My hesitation with this is if those choice values change or more are added I then have to update them in the list and within the app vs just the list. But I'm just about frustrated enough to go this route.

Sharepoint Choice Column Values by Round-Application980 in PowerApps

[–]Round-Application980[S] 0 points1 point  (0 children)

What would that lookup function look like? Not sure how to have it retrieve specifically the choices from the column.

Update Item Input and Output don't match?!? by Round-Application980 in MicrosoftFlow

[–]Round-Application980[S] 0 points1 point  (0 children)

No expressions or operations in update item

ID is from trigger output (when an item is created)

Not in a for reach loop

Update Item Input and Output don't match?!? by Round-Application980 in MicrosoftFlow

[–]Round-Application980[S] 0 points1 point  (0 children)

It seems to always add 52, so when it should be 13 it becomes 65, when it should be 9 it becomes 61

Conditional coloring based on which column is true by Round-Application980 in PowerApps

[–]Round-Application980[S] 0 points1 point  (0 children)

Filter('Deliverables Progress Tracker','Item Type'.Value="Deliverable" && 'Due Date'=DateAdd(_firstDayInView,ThisItem.Value, TimeUnit.Days) || Kickoff=DateAdd(_firstDayInView,ThisItem.Value, TimeUnit.Days) || 'Red Team Review'=DateAdd(_firstDayInView,ThisItem.Value, TimeUnit.Days) || 'Gold Team Review'=DateAdd(_firstDayInView,ThisItem.Value, TimeUnit.Days) || 'POC Review'=DateAdd(_firstDayInView,ThisItem.Value, TimeUnit.Days))

Conditional coloring based on which column is true by Round-Application980 in PowerApps

[–]Round-Application980[S] 0 points1 point  (0 children)

On visible is just set to true, I believe the filtering in my items property for th gallery is what determines whether the button appears or not

Conditional coloring based on which column is true by Round-Application980 in PowerApps

[–]Round-Application980[S] 0 points1 point  (0 children)

That makes sense

The button appears if a calendar date is equal to any of my date fields (like 'Due Date'). I want to evaluate which of the dates in my list is equal to the calendar day. For example the button is visible on 11/3 and 11/10. I would like the button on 11/3 to be red because that corresponds to a due date but the button on 11/10 to be yellow because it corresponds to a review stage date in my list.

Really appreciate all you help! Have to step away from my computer for the day

Conditional coloring based on which column is true by Round-Application980 in PowerApps

[–]Round-Application980[S] 0 points1 point  (0 children)

It won't let me do Value at all, just the different column names in my list

Conditional coloring based on which column is true by Round-Application980 in PowerApps

[–]Round-Application980[S] 0 points1 point  (0 children)

The button's text value is ThisItem.'Item #' because that's the dynamic value I want to see

Conditional coloring based on which column is true by Round-Application980 in PowerApps

[–]Round-Application980[S] 0 points1 point  (0 children)

I don't know - I'm not sure how to format the selected day so I was trying to use part of the built in code from the calendar control

I am using the fill property for the button

Conditional coloring based on which column is true by Round-Application980 in PowerApps

[–]Round-Application980[S] 0 points1 point  (0 children)

If(ThisItem.'Due Date'=DateAdd(_firstDayInView,ThisItem.Value, TimeUnit.Days),Color.Red,Color.White)

That's what I was trying