Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Comparing and storing data from excel into variable

Hi Everyone,

I have a data source (data1) that has six columns and a form on powerapps with different data sources. The form in powerapps has three dropdowns (name, type, description) I wanted to compare the values from the dropdowns with data1 if all the values equal, the values in columns (easy, medium, hard) of data1 should be stored in three different variables.

Thanks in advance,




@mahmoodhsaud could we have a sharing session in Skype Meet Now later today?

Helper IV
Helper IV

Sure @CNT 

@mahmoodhsaud which time zone are you in?

Helper IV
Helper IV

Mine is IST or GMT +5.30

@mahmoodhsaud Is 2:30 pm IST on Saturday ok for you?

@CNT it works for me

@mahmoodhsaud Glad it works!


Please remember to give a 👍 and accept the solution as it will help others in the future.

@CNT I am so very grateful for your time, With your support only I could able to complete the task




@mahmoodhsaud Glad you were able to get your work done! Fell free to @mention me if you post new messages for help.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,910)