Hello All,
I am new to Powerapps, i have 2 datasources namely
1. ScanData1 : URN, InoutDate, User
2. Preregister : URN, CompanyName, Visitor Name
Both of them have URN as the common field.
I want to get the data from Preregister Database : CompanyName and VisitorName
Please advice how to go about this
Solved! Go to Solution.
Use this:
ForAll(GalleryName.AllItems, Patch('[dbo].[ScanData1]', Defaults('[dbo].[ScanData1]'),{URN: urn.Text, InOutDate: Now(), User: User().FullName, 'Visitor Name': visitornamelookup.Text, 'Company Name': companylookup.Text}); Select(BarcodeScanner1)
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution
Try this:
Hi,
I am getting error as Invalid Argument Type near equal sign
Two questions:
1. Is urn in the Table Preregister?
2. Is urn a number field? If so put: Value(ThisItem.URN)
Remove the Space in the "Company Name": CompanyName
Put the Company Name in single quotes 'Company Name'
I was able to save the data. But however the lookup works fine in the Powerapps, but when it goes to SQL it showing wrong numbers.
For ex: attached URN one is abc company and visitor name is nagaraj
and other is def company and visitor name is jagadeesh
But SQL shows both as nagaraj and abc company only.
Please advice. Attached is the SQL data
Check out new user group experience and if you are a leader please create your group
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
256 | |
254 | |
81 | |
41 | |
30 |
User | Count |
---|---|
320 | |
263 | |
122 | |
65 | |
49 |