DId anyone tried below scenario before? Is it even possible?
we have a PowerApp with whole bunch of screen. However on landing screen we can to show 4 fields form the Excel file based up on the user login to this APP. it can be based up on user email.
Excel field names: Goals, answers, question3,question4.
I tried to import or add as an data source of the excel file called "test" however it is throuwing an error that there is no table found. But the thing is that I made the content as "Tabel" and named it as "testtable" and saved it to OneDrive too.
Not sure what I am doing wrong.
I would like to achievce two things
1. import excel data file as a data source to the form
2. on the landing screen based up on the user login/email ID it should lookup the excel file and publish/pull those four columns in read only mode.
ANy help would be much appreciated!
Thansk for the solution. What is use Email is in multiple rows? For example if UserA has multiple rows with different information, can I display on the screen of all these information? as per below screen shot, I wasnt to display objective and description of three rows for UserA on the form.
and also do Ineed to provide read only access to each and every user on "'ONEDrive" location so that they can be able to view on the scree? or it doesn't require that level of permission? I don't want users to see the other's data from those columns by accessing that excel file. Please advise.
Filter(testtable, emailcol = User().Email)
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
I was able to pull data with dummy excel file. However I have an excel file which is more than 3MB and PowerApps will allow only 2MB of content for each tabel. Can I create two excel files and lookup from bothe files and then display the information? Can you please let me know how can tweak abbove functiont hat you have mentioned?
can you please explain me a bit more? I am bit confused here. So I need to use clearcollect on "App start" right?
And then how can I display content based up on this?
I created a Gallery on a screen and a display form on the same screen. EX: Gallery will be on the left hand side and on the right hand side there will be a display form. The reaSON why I did like that is for user to view his/here lin items on same screen itself. IF they select from the gallery "using enxtarrowicon" then on the right hand side it should show detail information. Not sure how to achieve this?
I have added clear collect on "App start", it does show the information. However it shows information of email starting letter from K only. I have emails starting from letter A.
My code: ClearCollect(Mycollection,Goals_final);ClearCollect(Mycollection,Goals_final2)
Goal_final: it has columns "Email", "Objective" , Objective_description"
Goal_final2: it has columns "Email", "Objective" , Objective_description"
Both the excel sheets have similar column names.
What Ihave noticed is that if append "Goal_final" to mycollection before goals_final2 as per my above code, then it is showing results only from 'Goal_final".
Not sure how to fix this now.
Continue your learning in our online communities.
Features releasing from October 2019 through March 2020
Coming to a city near you
Fill out a quick form to claim your user group badge now!
Connect, share, and learn with your peers year-round
Register by September 5 to save $200