I have been using this formula successfully to pull data from excel for over a month. In the last week, it has suddenly stopped working. The error seems to be in the DataCardValue1 field. Has anyone had a similar issue or know of an update that might have broken this formula? I've tried rebuilding the fields and re-importing the data to no effect.
Solved! Go to Solution.
Based on the issue that you mentioned, do you want to populate the WELL_NAME field based on the PN field?
Could you please share a bit more about the scenario, do you mean the WELL_NAME field could not display the correct value ?
Actually, it has been an known issue for almost a month. For now, it displays when you preview the formula but the error will not make sense to your App.
I have a test on my side and the formula works well.
As for the error message you provided, I think you could try the following steps.
If the above steps could not help you solve it, you could provide more details or choose to contact our support team.
Hope it could help.
Thank you, Qi.
I have tried refreshing and then deleting and reconnecting the data. Unfortunately that did not work. Nor did deleting the "Well Name is" &. The formula in your example is exactly what I'm trying to do with no luck. I even started a blank canvas to see if it was an issue with the existing app only, but I could not get the formula to work in there either.
What I'm trying to do is have the user enter the PropertyNumber (stored here as text) and then have Well Name populate automatically. This will allow the user to double check that the PropertyNumber is correct. However, when I link the formula to DataCardValue1 it pulls that vague error message.
Like I said before, the was working before last week. I hope this additional information helps to solve the issue.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!