App pulling from SharePoint list pulls old information

(0) Share

Report

Posted on by JimmyW

2,563

So I have a combo box that pulls information from a SharePoint list to display values.

Now for some reason it stopped updating values, for example I deleted one item, but that Item still shows up in the Combo box, like it's not refreshing.

I tried removing the SharePoint list and re-adding it in the Data.

Combo box items

Distinct(Choices('ColumnTest'.Site),Value)

I don't know why, this item that shows up was deleted more then 8 hours ago.

I do index this column in SharePoint, don't know if that might be the issue here but seems a bit weird because that value is no longer in the list but still being displayed.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@JimmyWork

The Choices function gets the Choices that are defined in the column settings. It does not get choices based on the records.

So, are you stating that you deleted a Choice from the choice list in the column settings, or that you were deleting a record in the list and expecting different results?

Was this reply helpful? Yes No
JimmyW 2,563 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes Thank you Randy I was so set on this updating due to my second dropdown filters based on the first using lookup.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@JimmyWork

Well, you still can do that, but you just can't base it on the Choices function because that is only going to return the choices that are defined in the column settings. You would need to base it on the distinct values that are currently chosen in the list. You can run into record limit issues with that method though, so choose wisely!

Was this reply helpful? Yes No