Unanswered

Data Not Appearing in Excel Data Source

(0) Share

Report

Posted on by WNow4321

I have been asked to change the look of the power app to have select fields as view text only. Below I switched the Therm. Certification Pass/Fail field from a dropdown field or allowed values field to a view text only, so when people use the app, they can't accidently switch it. Now that it is in view text, the data does not appear in the excel file that the app is connected too. I tried to refresh and reconnect the data source, it still doesn't appear. Everything was working fine as a dropdown field, it just doesn't seem to work as view text only field. Does anyone know why the data isn't appearing all of a sudden?

Power Apps1.PNG Power Apps2.PNG Power Apps3.PNG

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@WNow4321

First of all, Excel is a terrible data source. See Shane Young's video here for why. https://www.youtube.com/watch?v=RtmZM3tm2Zs . I can't tell from your description but if you have changed the schema of the Excel file, it won't work right. I am not sure what you mean by a view text field. Have you changed the DisplayMode of the card to View? If you want to be able to edit it on a new record but not show it once it has been entered, you can set the DisplayMode of the card to If(IsBlank(Parent.Default), Edit, View)

Was this reply helpful? Yes No
WNow4321 31 on at

Like (0)

Report
Copy link

Link copied!

Excel is not a terrible data source. It has been working fine for me until I switched it to view text. Under edit fields you can select how the field for your text is displayed. I had it as allowed values which makes it a dropdown field. I switched it to view text, so people cannot edit the field when the app is being used.

As you can see below, I switched it back to allowed values field making it a dropdown and it worked by showing up on the excel data when submitted. So, I am wondering why it won't submit the data as a view text field to the excel data source?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@WNow4321

I believe that SubmitForm() only submits data when the card it in edit mode. I may be wrong though.

Was this reply helpful? Yes No
WNow4321 31 on at

Like (0)

Report
Copy link

Link copied!

Thanks, I believe that is the answer to. It just doesn't make much sense to do it like that. I will keep working on it.

Was this reply helpful? Yes No
WNow4321 31 on at

Like (0)

Report
Copy link

Link copied!

I have decided to switch the text field back to an edit text or allowed values and just disable the display mode. It works this way.

Was this reply helpful? Yes No