Forum Discussion
Translytical Task Flow – Create/Edit Not Reflecting in Report (Only Delete Working)
Hi Mohan128256,
Thanks for the update and follow-up question.
It sounds like your SQL logic is fine, but the issue is with how inputs are passed from the report to your User Data Function. Since all values are typed together (like 1,test1,test2…), Power BI can’t identify which value belongs to which parameter, so it’s mapping them randomly. Please try this below I mentioned:Create separate text inputs for each field PageNo, ReportName, PageName, ReportDescription, and ReportLink. Go to your Submit button → Format → Action → User Data Function, and make sure each parameter is mapped to the correct input visual. For optional Add a message box to show the success message after submission. After mapping them separately, the record should be created with correct values.
Hope this clarifies it. Let us know if you have any doubts regarding this. We will be happy to help.Thank you for using the Microsoft Fabric Community Forum.
Hi v-kpoloju-msft
The records are updating but i want to create a record in report. I have Pageno,ReportName,PageName,ReportDescription,ReportLink . Whenever i click on created description only updating remaning values are taking randamly and if i type 1,test1,test2.. in text Slicer how the system know that pageno is 1, report name is test1. Can you please give any suggestions. End of the Output i want it like Pageno,reportname,pagename,reportdescription,reportlink values if type in serach slicer and clicked on created record. The record should be updated. it should not take random values.
Hi Mohan128256,
Thanks for the update and follow-up question.
It sounds like your SQL logic is fine, but the issue is with how inputs are passed from the report to your User Data Function. Since all values are typed together (like 1,test1,test2…), Power BI can’t identify which value belongs to which parameter, so it’s mapping them randomly. Please try this below I mentioned:Create separate text inputs for each field PageNo, ReportName, PageName, ReportDescription, and ReportLink. Go to your Submit button → Format → Action → User Data Function, and make sure each parameter is mapped to the correct input visual. For optional Add a message box to show the success message after submission. After mapping them separately, the record should be created with correct values.
Hope this clarifies it. Let us know if you have any doubts regarding this. We will be happy to help.Thank you for using the Microsoft Fabric Community Forum.
Hi Mohan128256,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.Thank you.